PL-300 Question #408: Real Exam Question with Answer & Explanation

Question

You have a Power BI semantic model that contains two queries. You discover that a report based on the model has performance issues. You plan to use Power Query to reduce the data loaded to the model. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

Options

• AApply group by and summarize techniques.
• BCombine the queries by using Append.
• CRemove unnecessary columns and rows.
• DCombine the queries by using Merge.
• ECreate a new query group.

Explanation

To reduce the data loaded to a Power BI model and improve performance using Power Query, you should apply group by and summarize techniques, and remove unnecessary columns and rows.

Common mistakes.

• B. Combining queries using Append adds rows, which can increase the data loaded if not coupled with other data reduction steps, thereby potentially worsening performance.
• D. Combining queries using Merge joins columns, which can also increase data volume and complexity, especially if not used to filter or summarize data effectively.
• E. Creating a new query group is an organizational action within Power Query Editor and does not affect the amount of data loaded or the model's performance.

Concept tested. Power Query data reduction techniques

Reference. https://learn.microsoft.com/en-us/power-bi/guidance/power-query-folding

No community discussion yet for this question.