PL-300 practice questions 71–80

1. Question 71 · 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 an on-premises data gateway. You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode. Solution: You create aggregations to summarize results. Does this meet the goal?

   • AYes
   • BNo

   Show answer

   Answer: B

   Explanation

   Create aggregations to summarize results. This seems to be saying group and summarize after the data has come through the gateway as an import. This will not reduce the traffic as it has already come through the gateway. Answer : B.No.

   Source: Adapted from community discussion — 1CY1

   Next question

2. Question 72 · 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 an on-premises data gateway. You need to reduce the amount of data sent through the gateway by semantic models that run in import storage mode. Solution: You increase Automatic page refresh intervals. Does this meet the goal?

   • AYes
   • BNo

   Show answer

   Answer: B

   References

   • Microsoft Learn

   Next question

3. Question 73 · 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 an on-premises data gateway. You need to reduce the amount of data sent through the gateway by semantic models that run in import storage mode. Solution: You configure incremental refresh. Does this meet the goal?

   • AYes
   • BNo

   Show answer

   Answer: A

   Explanation

   Incremental refresh allows you to load only new or changed data, rather than refreshing the entire dataset. This can significantly reduce the amount of data that needs to be processed and transferred, especially in large datasets.

   Source: Adapted from community discussion — ec338ed

   Next question

4. Question 74 · 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 an on-premises data gateway. You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode. Solution: You decrease the dashboard cache update frequency. Does this meet the goal?

   • AYes
   • BNo

   Show answer

   Answer: B

   Explanation

   Chat GPT: The dashboard cache update frequency determines how often Power BI refreshes the dashboard visuals from the dataset. Adjusting this frequency does not directly reduce the amount of data sent through the on-premises data gateway for semantic models in Import storage mode.

   Source: Adapted from community discussion — 0e11c58

   Next question

5. Question 75 · 358 in bank

   HOTSPOT - You have a Power BI semantic model named Model1. You need to create a measure that will display the sales result for all blue units. The solution must maintain the existing filter context. How should you complete the DAX expression? 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

   I would go for CALCULATE and KEEPFILTERS. CALCULATE evaluates a single expression (like [Sales]) within a modified filter context. In this scenario case, you want to filter the 'Unit'[Color] to "blue" while maintaining the existing filter context. CALCULATETABLE would return a table, which would then need to be aggregated further (e.g., using SUMX), making it less direct and has a layer of complexity. Second one , use KEEPFILTERS is the most appropriate for ensuring that the filter for blue is added to the existing context without overriding it.

   Source: Adapted from community discussion — Odidepse

   

   Next question

6. Question 76 · 358 in bank

   You have a Power BI semantic model named Model1 that runs in Import storage mode. You need to reduce the size of Model1. The solution must NOT increase report query response times. What should you do?

   • ARemove unnecessary columns.
   • BUnpivot unnecessary columns.
   • CRename unnecessary columns.
   • DChange Model1 to DirectQuery storage mode.

   Show answer

   Answer: A

   Explanation

   Presented answer is correct, Removing unnecessary columns will directly reduce the model's size by eliminating data that isn't needed. This change won't affect query performance since the excluded data is not part of the model. The others B. Unpivot unnecessary columns: Increases model size by adding rows. C. Rename unnecessary columns: Doesn't reduce size, only changes labels. D. Change to DirectQuery: May reduce size but can slow down query performance.

   Source: Adapted from community discussion — Odidepse

   Next question

7. Question 77 · 358 in bank

   Select 2

   You have a Power BI semantic model named Model1 that runs in Import storage mode. You need to reduce the size of Model1. Which two actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • ASummarize the detail data.
   • BUpgrade to Power BI premium.
   • CImplement row-level security (RLS).
   • DOptimize the column data types.
   • EChange the active relationships between tables to inactive relationships.

   Show answer

   Answer: AD

   Explanation

   Presented answer is correct A. Summarize the detail data: Since Import mode loads the entire dataset into memory, reducing the amount of detail data (for example, aggregating granular data like daily sales into monthly or yearly totals) can significantly reduce the size of the model in memory. This approach helps minimize memory usage and improves query performance. D. Optimize the column data types: In Import mode, data is compressed and optimized by the VertiPaq storage engine. Using more efficient column data types reduces memory consumption and ensures better compression when the data is loaded into memory. For instance, using integer or decimal data types instead of string can help achieve better compression and optimize performance. link: https://learn.microsoft.com/en-us/power-bi/connect-data/service-dataset-modes-understand

   Source: Adapted from community discussion — Odidepse

   References

   • Microsoft Learn

   Next question

8. Question 78 · 358 in bank

   Select 3

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

   

   You need to create a solution that meets the following requirements: • Presents transaction amount totals for each month for the current and prior year • Follows the star schema modeling approach • Minimizes the data model size Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   • ACreate one-to-many relationships between the tables.
   • BIn the Transactions query, delete the TransactionID column.
   • CIn the Date query, group by MonthNumber.
   • DIn the Transactions query, group by AccountID and MonthStartDate for TransactionDate. Aggregate by summing the TransAmt column.
   • EIn the Transactions query, add a column that contains the MonthStartDate value for TransactionDate.
   • FCreate many-to-many relationships between the tables.

   Show answer

   Answer: ABD

   Explanation

   I believe E is not correct because adding MonthStartDate to the Transactions table would increase the data size, and this information is already available in the Date table.

   Source: Adapted from community discussion — 5bf040d

   Next question

9. Question 79 · 358 in bank

   HOTSPOT - You have a Power BI semantic model that contains three tables named Products, OrderHistory, and Date. The Products table is a dimension table that contains the following columns: • ProductID • ProductName The OrderHistory table is a fact table that contains the following columns: • OrderID • ProductID • OrderDate The Date table is a dimension table that contains the following columns: • Year • Date • Week • Month You need to define a relationship from Products to OrderHistory and from OrderHistory to Date. Which cardinality should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct answer 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

   

   Next question

10. Question 80 · 358 in bank

    DRAG DROP - You plan to create a report that will display sales data from the last year for multiple regions. You need to restrict access to individual rows of the data on a per region-basis by using roles. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Select and Place:

    

    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

    You can define roles and rules within Power BI Desktop. When you publish to Power BI, it also publishes the role definitions. To define security roles, follow these steps. 1. Import data into your Power BI Desktop report (Step 1) 2. From the Modeling tab, select Manage Roles. 3. From the Manage roles window, select Create. (Step 2) 4. Under Roles, provide a name for the role. 5. Under Tables, select the table to which you want to apply a DAX rule. 6. In the Table filter DAX expression box, enter the DAX expressions. This expression returns a value of true or false. For example: [Entity ID] = ג€Valueג€(Step 3) 7. After you've created the DAX expression, select the checkmark above the expression box to validate the expression. 8. Select Save. Step 3: Assign Users to the role. You can't assign users to a role within Power BI Desktop. You assign them in the Power BI service. After you've created your roles, test the results of the roles within Power BI Desktop. Step 4: Publish the report. Now that you're done validating the roles in Power BI Desktop, go ahead and publish your report to the Power BI service. Reference: https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

    Source: Adapted from community discussion — vanessa1923

    References

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    

    Next question

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

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