DP-600 Question #21: Real Exam Question with Answer & Explanation

Question

You have a Fabric workspace that contains a DirectQuery semantic model. The model queries a data source that has 500 million rows. You have a Microsoft Power Bi report named Report1 that uses the model. Report1 contains visuals on multiple pages. You need to reduce the query execution time for the visuals on all the pages. What are two features that you can use? Each correct answer presents a complete solution, NOTE: Each correct answer is worth one point.

Options

• Auser-defined aggregations
• Bautomatic aggregation
• Cquery caching
• DOneLake integration

Explanation

For a DirectQuery semantic model with a large data source, both user-defined and automatic aggregations are effective features to reduce query execution time for report visuals.

Common mistakes.

• C. Query caching improves performance for repeated queries by storing results, but it does not fundamentally reduce the execution time of the initial query to the data source or for complex, unique queries.

Concept tested. DirectQuery performance optimization (aggregations)

Reference. https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-aggregations-overview

No community discussion yet for this question.