Microsoft DP-600 Practice Exam Questions & Answers

8 Free Questions Last reviewed November 18, 2026 Prepared & Reviewed by the ValidExamDumps Editorial Team

230 Practice Questions (Our Bank)
100 minutes Exam Duration
700 out of 1000 Passing Score
USD 165 Official Exam Fee (United States)
Exam Facts

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
Practice Questions

Free DP-600 Practice Questions

Each question shows the correct answer and an explanation of why it is right

VA
ValidExamDumps Editorial Team Every question and its answer is checked by our DP-600 exam preparation team, who also write the explanation shown with each one. How we research and review these pages

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.

Question 1 exhibit

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

Question 1 exhibit

Explanation

Correct answer area highlighted in green

Hotspot answer


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?

Correct Answer C
Explanation

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?

Correct Answer D
Explanation

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

Get Full Access

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.

Correct Answer A, D
Explanation

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?

Correct Answer C
Explanation

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.

Correct Answer B, D, E
Explanation

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?

Correct Answer A
Explanation

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.

Question 8 exhibit

You need to improve the performance of Query1.

The solution must minimize resource use How should you restructure Query1?

A)

Question 8 exhibit

B)

Question 8 exhibit

C)

Question 8 exhibit

D)

Question 8 exhibit

Correct Answer A
Study Guide

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.

Sample questions from this domain above Q1Q4

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.

Sample questions from this domain above Q2Q5Q8

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.

Sample questions from this domain above Q3Q6Q7

FAQ

DP-600 Exam FAQ

Common questions about the exam itself

How hard is the DP-600 exam compared to other Microsoft data certifications?
DP-600 is moderately challenging and very hands-on. It expects you to work across the entire Fabric stack from data ingestion through modelling to reporting. It sits between the analyst-focused PL-300 and the engineer-focused DP-700, demanding both breadth and depth in a single exam.
What background do I need before attempting DP-600?
You should have expertise in designing, creating, and deploying enterprise-scale analytics solutions using Fabric components like lakehouses, warehouses, notebooks, and semantic models. Prior experience with SQL, DAX, and data transformation is expected. Knowledge of Power BI is beneficial but not mandatory.
Which objective area causes candidates the most trouble on DP-600?
Semantic model design typically challenges candidates because it requires both understanding DAX expressions and making architectural decisions about table relationships and calculated columns. Spend time practising DAX writing and working through real-world model optimization scenarios.
How long should I plan to prepare for DP-600?
A realistic preparation timeframe is 8 to 12 weeks if you already work with data platforms. If you are new to Fabric, plan for 12 to 16 weeks to become comfortable with the platform. The exact time depends on your existing experience with SQL, DAX, and cloud data services.
What happens on exam day for DP-600?
You have 100 minutes to answer approximately 40 questions. The exam includes multiple-choice, multiple-response, drag-and-drop ordering questions, and at least one case study. Some items present DAX or T-SQL code and ask you to identify or complete the correct statement.
What are the retake rules for DP-600?
You must wait 24 hours after your first failed attempt before retaking. For subsequent attempts, there is a 14-day waiting period between each attempt. You can attempt the exam a maximum of five times within a 12-month period. After five failures, you must wait 12 months from your first attempt before trying again.
How long does the Fabric Analytics Engineer Associate certification stay valid?
The certification is valid for one year. You can renew it free of charge by completing an online assessment on Microsoft Learn before the expiration date. The renewal assesses your current knowledge of the technology.
What job role does DP-600 lead to?
DP-600 qualifies you as a Fabric Analytics Engineer, a role that designs, builds, and maintains enterprise-scale analytics solutions on Microsoft Fabric. Organisations migrating from Synapse or standalone Power BI increasingly seek this credential as a senior data analytics qualification.
How does DP-600 relate to the other Fabric certification exams?
DP-600 focuses on analytics and semantic modelling. If you write more DAX than Spark code, DP-600 is for you. DP-700 covers Fabric data engineering and suits candidates writing more Spark. PL-300 is the Power BI analyst foundation, and many teams now expect DP-600 as the senior Fabric credential alongside or after PL-300.
Can I reschedule my DP-600 exam after booking it?
Yes, you can reschedule through your Pearson VUE account online. The specific rescheduling rules and any associated fees depend on how close your exam date is and whether Microsoft or Pearson VUE has promotional policies in effect at the time of rescheduling.

Other Microsoft Exams

Free practice questions for more Microsoft certification exams

All Microsoft exams