What are two features that you can use?

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 Bl report named Report1 that uses the model. Report! 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.
A . user-defined aggregations
B . automatic aggregation
C . query caching
D . OneLake integration

View Answer

Answer: A, B

Explanation:

User-defined aggregations (A) and query caching (C) are two features that can help reduce query execution time. User-defined aggregations allow precalculation of large datasets, and query caching stores the results of queries temporarily to speed up future queries.

Reference = Microsoft Power BI documentation on performance optimization offers in-depth knowledge on these features.