Implementing Analytics Solutions Using Microsoft Fabric — Question 24

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.

Answer options

Correct answer: A, B

Explanation

User-defined aggregations and automatic aggregation help optimize performance by pre-calculating results, which reduces the need to query the entire dataset each time a visual is rendered. Query caching is not applicable here as it focuses on storing query results rather than aggregating data, and OneLake integration does not directly address query execution time.