DP-600: Implementing Analytics Solutions Using Microsoft FabricDemo

By Microsoft · Question Mode

QuestionQ37

Implement and manage semantic models

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.

Choose two
  • A user-defined aggregations
  • B automatic aggregation
  • C query caching
  • D OneLake integration
Explanation

User-defined aggregations and automatic aggregations both pre-aggregate data to reduce query scans over 500 million rows. Query caching does not work with DirectQuery mode (it applies only to imported data on first page load). OneLake integration is not a performance optimization for query execution time on external data sources. Both A and B are valid architectural solutions for reducing execution time.

Community Discussion

No comments yet. Be the first to start the discussion!