Microsoft DP-600 Practice Exam Questions & Answers
Microsoft DP-600 Exam Details
Key details for this exam, checked against the published exam outline
- Exam Code
- DP-600
- Full Name
- Implementing Analytics Solutions Using Microsoft Fabric
- Issuing Body
- Microsoft
- Question Format (Our Bank)
- Multiple Choice, Hotspot, Drag & Drop, Case Studies
- Delivery
- Online proctored or at a Pearson VUE test centre
- Eligibility
- Subject matter expertise in designing, creating, and deploying enterprise-scale data analytics solutions using Microsoft Fabric components
- Full Question Set
- 230 questions Get All Questions
Free DP-600 Practice Questions
Each question shows the correct answer and an explanation of why it is right
Question 1 Domain 1 Prepare data
You have a Fabric tenant.
You plan to create a Fabric notebook that will use Spark DataFrames to generate Microsoft Power Bl visuals.
You run the following code.

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Correct answer area highlighted in green

Introduction to DataFrames - Spark SQL
Power BI and Azure Databricks
Question 2 Domain 2 Implement and manage semantic models
What should you use to implement calculation groups for the Research division semantic models?
Unable to provide explanation - the question lacks the necessary options and context. While calculation groups are a feature in Tabular models, the specific tools or methods available for implementing them in the Research division's semantic models are not listed in the question.
Question 3 Domain 3 Maintain a data analytics solution
You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 contains a single semantic model that has two Microsoft Power BI reports.
You have a Microsoft 365 subscription that contains a data loss prevention (DLP) policy named DLP1.
You need to apply DLP1 to the items in Workspace1.
What should you do?
Step 1: Understand the scenario
Workspace1 contains a semantic model and two Power BI reports.
A Microsoft 365 Data Loss Prevention (DLP) policy (DLP1) already exists.
Requirement: Apply DLP1 to the workspace items.
In Microsoft Fabric and Power BI, DLP policies are enforced through Microsoft Purview Information Protection (MIP) sensitivity labels.
Step 2: Evaluate each option
A . Apply a master data endorsement to the semantic model.
Endorsements (promoted, certified) help users find and trust datasets but do not enforce DLP policies.
Not correct.
B . Apply a certified endorsement to the semantic model.
Certification improves discoverability and trust, but again, it does not trigger DLP policy enforcement.
Not correct.
C . Create a workspace identity.
Workspace identity (service principal) is used for connecting to external resources with managed identity.
It does not relate to DLP policy application.
Not correct.
D . Apply sensitivity labels to the semantic model and reports.
Sensitivity labels (from Microsoft Purview) integrate with Microsoft 365 DLP policies.
When sensitivity labels are applied to Power BI datasets, reports, dashboards, and workspaces, DLP1 can enforce protections such as preventing sharing or exporting sensitive data.
This is the correct answer.
Step 3: Correct Action
To apply DLP1 to Workspace1 items, you must:
Configure sensitivity labels in Microsoft Purview.
Apply those sensitivity labels to the semantic model and reports inside Workspace1.
The existing DLP1 policy will then govern data handling for those items.
Reference
Sensitivity labels in Power BI
Apply sensitivity labels to Power BI items
DLP policies in Microsoft Purview
Get the complete DP-600 question set
$20$40
Question 4 Domain 1 Prepare data
You need to create a data loading pattern for a Type 1 slowly changing dimension (SCD).
Which two actions should you include in the process? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.
For a Type 1 SCD, you should include actions that update rows when non-key attributes have changed (A), and insert new records when the natural key is a new value in the table (D). A Type 1 SCD does not track historical data, so you always overwrite the old data with the new data for a given key. Reference = Details on Type 1 slowly changing dimension patterns can be found in data warehousing literature and Microsoft's official documentation.
Question 5 Domain 2 Implement and manage semantic models
You need to refresh the Orders table of the Online Sales department. The solution must meet the semantic model requirements. What should you include in the solution?
Unable to provide explanation - the question is missing critical details. The semantic model requirements are not specified, and the options for the solution are not provided. To recommend what to include in a table refresh solution, these specific requirements and available options are essential.
Question 6 Domain 3 Maintain a data analytics solution
You have a Fabric workspace named Workspace1 that contains a dataflow named Dataflow1. Dataflow1 returns 500 rows of data.
You need to identify the min and max values for each column in the query results.
Which three Data view options should you select? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.
When analyzing 500 rows of data in a dataflow to identify min and max values for each column, you should select three Data view options:
- Column distribution - Shows the distribution of values in each column, helping identify min and max occurrences and value ranges
- Column statistics - Displays statistical summaries including minimum and maximum values, mean, median, and other metrics for numeric columns
- Column type - Confirms the data type of each column, which is essential for correctly interpreting min/max values (e.g., numeric vs. text sorting)
These three options together provide a comprehensive view to identify min and max values across all columns in the query results.
Question 7 Domain 3 Maintain a data analytics solution
You have a Microsoft Power Bl semantic model that contains a single table named Orders. Orders contains the following columns:
* Product Name
* Order Date
* Quantity
You have a Power Bl report that contains a page named Inventory. Inventory contains a slicer for the Product Name column and a clustered column chart that shows Quantity by Order Date.
You need to ensure that users can select whether to display Quantity by Product Name or Quantity by Order Date in the chart. The solution must minimize development effort.
What should you create?
To allow users to select whether to display Quantity by Product Name or Quantity by Order Date with minimal development effort, you should create a bookmark. Bookmarks capture the current state of a report page (including which fields are in the visualization) and can be toggled via buttons. This is the most straightforward solution that requires no additional measures or complex DAX logic. Alternatively, a field parameter could be used, but bookmarks offer the most minimal development effort for this scenario.
Question 8 Domain 2 Implement and manage semantic models
You have the following KQL query named Query1.

You need to improve the performance of Query1.
The solution must minimize resource use How should you restructure Query1?
A)

B)

C)

D)

What the Microsoft DP-600 Exam Covers
Exam domains verified against the Official Microsoft DP-600 exam guide, last checked November 2026.
Domain 1 Prepare data
45% - 50%Create objects in a lakehouse or warehouse and copy data efficiently. Transform data through dataflows, Spark notebooks, and Data Factory pipelines. Optimize query performance and organize data for analytical readiness.
Domain 2 Implement and manage semantic models
25% - 30%Design and construct semantic models that structure data meaningfully for analysis. Build DAX calculations and establish table relationships. Optimize large-scale semantic models to enhance efficiency and usability in enterprise environments.
Domain 3 Maintain a data analytics solution
25% - 30%Implement security through row-level security and object-level security alongside Purview governance. Monitor solution health and handle capacity management. Maintain the analytics development lifecycle through proper deployment and version control.
DP-600 Exam FAQ
Common questions about the exam itself
How hard is the DP-600 exam compared to other Microsoft data certifications?
What background do I need before attempting DP-600?
Which objective area causes candidates the most trouble on DP-600?
How long should I plan to prepare for DP-600?
What happens on exam day for DP-600?
What are the retake rules for DP-600?
How long does the Fabric Analytics Engineer Associate certification stay valid?
What job role does DP-600 lead to?
How does DP-600 relate to the other Fabric certification exams?
Can I reschedule my DP-600 exam after booking it?
Other Microsoft Exams
Free practice questions for more Microsoft certification exams
