DP-600 Practice Test

DP-600 Practice Test practice questions, page 6 of 9, with answer review and explanations.

Question 26

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.

Question 27

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.

Question 28

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

Question 29

You have a Fabric tenant that contains a complex semantic model. The model is based on a star schema and contains many tables, including a fact table named Sales. You need to create a diagram of the model. The diagram must contain only the Sales table and related tables. What should you use from Microsoft Power BI Desktop?

  1. data categories
  2. Data view
  3. Model view
  4. DAX query view

Question 30

You have a Fabric tenant that contains a semantic model. The model uses Direct Lake mode. You suspect that some DAX queries load unnecessary columns into memory. You need to identify the frequently used columns that are loaded into memory. What are two ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.

  1. Use the Analyze in Excel feature.
  2. Use the Vertipaq Analyzer tool.
  3. Query the $System.DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS dynamic management view (DMV).
  4. Query the DISCOVER_MEMORYGRANT dynamic management view (DMV).