CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-600

Free DP-600 Exam Braindumps (page: 8)

Page 7 of 36
PDF with 183 Questions

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.

  1. user-defined aggregations
  2. automatic aggregation
  3. query caching
  4. OneLake integration

Answer(s): A,B



You have a Fabric tenant that contains 30 CSV files in OneLake. The files are updated daily.
You create a Microsoft Power BI semantic model named Model1 that uses the CSV files as a data source. You configure incremental refresh for Model1 and publish the model to a Premium capacity in the Fabric tenant.
When you initiate a refresh of Model1, the refresh fails after running out of resources.
What is a possible cause of the failure?

  1. Query folding is occurring.
  2. Only refresh complete days is selected.
  3. XMLA Endpoint is set to Read Only.
  4. Query folding is NOT occurring.
  5. The delta type of the column used to partition the data has changed.

Answer(s): D



You have a Fabric tenant that uses a Microsoft Power BI Premium capacity.
You need to enable scale-out for a semantic model.
What should you do first?

  1. At the semantic model level, set Large dataset storage format to Off.
  2. At the tenant level, set Create and use Metrics to Enabled.
  3. At the semantic model level, set Large dataset storage format to On.
  4. At the tenant level, set Data Activator to Enabled.

Answer(s): C



You have a Fabric tenant that contains a warehouse. The warehouse uses row-level security (RLS).
You create a Direct Lake semantic model that uses the Delta tables and RLS of the warehouse.
When users interact with a report built from the model, which mode will be used by the DAX queries?

  1. DirectQuery
  2. Dual
  3. Direct Lake
  4. Import

Answer(s): C






Post your Comments and Discuss Microsoft DP-600 exam with other Community members:

DP-600 Exam Discussions & Posts