PL-300 practice questions 171–180

1. Question 171 · 358 in bank

   Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys: • Due Date • Order Date • Delivery Date You need to support the analysis of sales over time based on all three dates at the same time. Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. You create active relationships between the sales table and each date table. Does this meet the goal?

   • AYes
   • BNo

   Show answer

   Answer: A

   Explanation

   Your explanation is correct but your answer is wrong. This is because power Bi can only allow one active relationship at a time. the others will be inactive until you need them. Check these links: https://support.microsoft.com/en-us/office/create-relationships-in-diagram-view-in-power-pivot-12e00cb6-cb4d-469c-97ce-caa08349ad76#:~:text=Tables%20can%20have%20multiple%20relationships,calculations%20via%20the%20USERELATIONSHIP%20function https://community.fabric.microsoft.com/t5/Desktop/Power-BI-quot-An-Active-relationship-already-exists-between/m-p/768911#:~:text=Proud%20to%20be%20a%20Super%20User Based on the referenced links, I support that the answer is NO: B

   Source: Adapted from community discussion — Paulkuzzio

   References

   • Microsoft Learn

   Next question

2. Question 172 · 358 in bank

   HOTSPOT - You are creating a Power BI report that will show the number of current employees over time. The report will use Import storage mode for all tables. The employment data will be imported from Azure SQL Database in a monthly snapshot. The data will be stored in a table named Headcount and will contain the following: • One row per employee for each month the employee is employed • In each row, a date key that shows the first day of the month of each snapshot You have a related date table that contains dates for the years 2020 to 2030. You need to create a semi-additive DAX measure that will return the count of employees for the last available date in a year, quarter, or month. How should you complete the measure? To answer, select the appropriate options in the answer area.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   LASTNONBLANK doesn't work as it requires 2 inputs LastDate('headcount'[datekey])/ FirstDate('headcount'[datekey]) doesn't work simply because firstdate and lastdate requires a date. Datekey is not a date Therefore, Lastdate('date'[date]) is correct

   Source: Adapted from community discussion — aloysiusjw

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

3. Question 173 · 358 in bank

   HOTSPOT - You have a query named All Sales that imports sales data into a Power BI model. You plan to create a star schema by separating columns into separate queries and performing further transformations. The solution must meet the following requirements: • Use All Sales as the source for three other queries named Sales Fact, Product Dimension, and Customer Dimension. • Minimize maintenance effort. What should you do to create the Sales Fact query, and for which query should you clear Enable load? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Reference is the most common way to replicate origninal query. Clear "enable load" to "All Sales" cause the data of this query is now loaded to other table. It is not necessary to load it to Report view anymore

   Source: Adapted from community discussion — tranquanghuy2111

   

   Next question

4. Question 174 · 358 in bank

   Select 2

   You have the Power BI model shown in the following exhibit.

   

   A manager can represent only a single country. You need to use row-level security (RLS) to meet the following requirements: ✑ The managers must only see the data of their respective country. ✑ The number of RLS roles must be minimized. Which two actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • ACreate a single role that filters Country[Manager_Email] by using the USERNAME DAX function.
   • BCreate a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function.
   • CFor the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.
   • DCreate one role for each country.
   • EFor the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single.

   Show answer

   Answer: AC

   Explanation

   The given answer is correct. A. Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function. C.For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.

   Source: Adapted from community discussion — Nurgul

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

5. Question 175 · 358 in bank

   You have a Power BI model that contains the following data.

   

   The Date table relates to the Sales table by using the Date columns. The model contains the following DAX measure. Total Sales = SUM(Sales[Sale]) You need to create another measure named Previous Quarter to display the sales one quarter before the selected period. Which DAX calculation should you use?

   • ACALCULATE ( [Total Sales], DATEADD (Date[Date], -1, QUARTER ) )
   • BCALCULATE ( [Total Sales], DATESQTD (Date[Date] ) )
   • CTOTALQTD ( [Total Sales], Date[Date] )
   • DCALCULATE ( [Total Sales], PARALLELPERIOD (Date[Date], 1, QUARTER ) )

   Show answer

   Answer: A

   Explanation

   DATEADD is correct. PARALLELPERIOD also calculate one quarter before, but the out come is the total sales of three months of previous quarter not only one day or one month of previous quarter

   Source: Adapted from community discussion — tranquanghuy2111

   Next question

6. Question 176 · 358 in bank

   You are reviewing a Power BI data model. You have a calculated table that has the following definition. ProductList = INTERSECT ( ProductsGroupA, ProductsGroupB ) You need to identify the results of the DAX expression. Which rows will be returned in ProductList?

   • Aall the rows in ProductsGroupB that have a matching row in ProductsGroupA
   • Ball the rows in both tables
   • Call the rows in ProductsGroupA that have a matching row in ProductsGroupB
   • Dall the rows in ProductsGroupA that have no matching row in ProductsGroupB.

   Show answer

   Answer: C

   Explanation

   The INTERSECT function in DAX is order-independent. It returns the common rows between two tables, regardless of the order in which you specify the tables. both a and c are correct.

   Source: Adapted from community discussion — iamamantrivedi

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

7. Question 177 · 358 in bank

   HOTSPOT - You have a Power BI tenant that contains a workspace. The workspace contains a dataset named datasetA. You need to build a pivot table report in Microsoft Excel. The report must use datasetA as the data source. The solution must meet the following requirements: • Ensure that the report can be refreshed to get the latest available data from the Power BI service. • Ensure that all the visible data in datasetA is available for use in Excel. What should you do to connect Excel to datasetA, and which element in datasetA will be incompatible with the Excel connection? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Para conectar Excel a datasetA: Select Analyze in Excel: Esta opción te permite conectar Excel directamente a un conjunto de datos en Power BI usando "Analizar en Excel". Esto es lo que necesitas para crear un informe de tabla dinámica en Excel que se puede actualizar con los datos más recientes desde el servicio Power BI. Incompatible con la conexión a Excel: Field parameters: Los parámetros de campo (Field parameters) en Power BI no son totalmente compatibles con las conexiones a Excel. Esto puede causar problemas al intentar utilizar estas características avanzadas en un entorno de Excel. Por lo tanto, las selecciones correctas son: Para conectar Excel a datasetA: Select Analyze in Excel. Incompatible con la conexión a Excel: Field parameters.

   Source: Adapted from community discussion — hatem.ayed

   References

   • Microsoft Learn

   

   Next question

8. Question 178 · 358 in bank

   You have a Power BI data model that contains two tables named Sales and Date. The Sales table contains three measures named Order Quantity, Product Cost, and Sales Amount. You need to create the visual shown in the following exhibit.

   

   In which section of the Fields well should you place the measures?

   • AColumns
   • BRows
   • CValues
   • DDrill through

   Show answer

   Answer: C

   Explanation

   Correct answer is C To have the same exact matrix, you need to put the different measures in the "Values" well and then to go to the format pane of your matrix and select "Switch values to rows" under the "Values" section.

   Source: Adapted from community discussion — Datapassion

   Next question

9. Question 179 · 358 in bank

   HOTSPOT - You have Power BI report that contains the fields shown in the following exhibit.

   

   Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   - one explicit measure - summarization settings explanation: from the visual, there is only one implicit measure that can be replaced which is the 'sum of sales amount'. the 'sum of product cost' is not an implicit measure because the cost of individual products cannot be aggregated, hence, there is no such thing as 'sum of product cost'. It is only a wrong guess by power bi. what power bi does is that whenever a table is loaded into the model, it goes through each column of the table and make a guess of their data types. whenever it sees numeric columns such as date, product cost, and sales amount, it assumes that they are aggregable and automatically creates implicit measures for those columns by adding the summation sign next to those columns as shown in the example. To mitigate this weakness, developers have to manually go through each numeric column in their data model and change the summarization settings for non-aggregable columns just as part B of this question is suggesting. Thanks, Shalom!

   Source: Adapted from community discussion — Wadyba

   

   Next question

10. Question 180 · 358 in bank

    Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys: • Due Date • Order Date • Delivery Date You need to support the analysis of sales over time based on all the date foreign keys. Solution: You create measures that use the USERELATIONSHIP DAX function to filter sales on the inactive relationship between the sales table and the date table. Does this meet the goal?

    • AYes
    • BNo

    Show answer

    Answer: A

    Explanation

    you need to link the tables using the three Date fields require in the analysis. Only one relationship between two tables can be active. In the measures involving the Dates fields linked with the inactive relationships, the RELATIONSHIP() function is required to turn (within that measure) that relation to Active

    Source: Adapted from community discussion — jaume

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

PL-300 practice, question 171. 358 questions available.