Free DP-600 Practice Test Questions and Answers (2026) | Cert Empire

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 Bl Desktop?

You are the administrator of a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains the following tables: • Table1: A Delta table created by using a shortcut • Table2: An external table created by using Spark • Table3: A managed table You plan to connect to Lakehouse1 by using its SQL endpoint. What will you be able to do after connecting to Lakehouse1?

HOTSPOT You need to create a DAX measure to calculate the average overall satisfaction score. How should you complete the DAX code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

You have a Fabric tenant tha1 contains a takehouse named Lakehouse1. Lakehouse1 contains a Delta table named Customer. When you query Customer, you discover that the query is slow to execute. You suspect that maintenance was NOT performed on the table. You need to identify whether maintenance tasks were performed on Customer. Solution: You run the following Spark SQL statement: EXPLAIN TABLE customer Does this meet the goal?

You need to recommend which type of fabric capacity SKU meets the data analytics requirements for the Research division. What should you recommend?

You need to provide Power Bl developers with access to the pipeline. The solution must meet the following requirements: • Ensure that the developers can deploy items to the workspaces for Development and Test. • Prevent the developers from deploying items to the workspace for Production. • Follow the principle of least privilege. Which three levels of access should you assign to the developers? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

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.

DRAG DROP You have a Fabric tenant that contains a lakehouse named Lakehouse1 Readings from 100 loT devices are appended to a Delta table in Lakehouse1. Each set of readings is approximately 25 KB. Approximately 10 GB of data is received daily. All the table and SparkSession settings are set to the default. You discover that queries are slow to execute. In addition, the lakehouse storage contains data and log files that are no longer used. You need to remove the files that are no longer used and combine small files into larger files with a target size of 1 GB per file. What should you do? To answer, drag the appropriate actions to the correct requirements. Each action may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

You have a Fabric tenant that contains a semantic model named Model1. Model1 uses Import mode. Model1 contains a table named Orders. Orders has 100 million rows and the following fields. You need to reduce the memory used by Model! and the time it takes to refresh the model. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

HOTSPOT You have a Fabric workspace named Workspace1 and an Azure Data Lake Storage Gen2 account named storage"!. Workspace1 contains a lakehouse named Lakehouse1. You need to create a shortcut to storage! in Lakehouse1. Which connection and endpoint should you specify? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.