Exam Details
Microsoft · DP-600
Prepare for DP-600: Implement analytics solutions using Microsoft Fabric lakehouses, warehouses, semantic models, and deployment pipelines.
Overview
No ExamOS resources linked to this exam yet.
Approved links shared by the community. Earn credits when yours gets approved!
No community resources yet. Be the first to suggest one!
Know a strong article, guide, or explainer for this exam? Submit it for review and earn credits when it gets approved.
ExamOS may provide links to third-party websites, books, videos, courses, and other materials ("External Resources") for your convenience and reference. These resources are not created, owned, or controlled by ExamOS unless explicitly stated.
For official and up-to-date information, always refer to the certification provider website.
No resources have been linked to this exam yet.
Video Library
No video resources are available for this exam yet.
Found a strong walkthrough, lesson, or exam breakdown on YouTube? Submit it here and earn credits if it gets approved.
FAQ
The DP-600 certification validates your ability to design, create, and manage analytical assets in Microsoft Fabric. This associate-level exam targets analytics engineers who build lakehouses and warehouses, transform data using SQL, PySpark, KQL, and Power Query, implement and manage semantic models, and maintain analytics solutions. You'll demonstrate skills in data preparation, data transformation, semantic model design, DAX calculations, storage mode configuration, security and governance, and lifecycle management. As Microsoft positions Fabric as its next-generation analytics platform, certified analytics engineers who can build modern data architectures are increasingly sought after.
Exam details: 40–60 questions, 100 minutes of testing time, passing score of 700 out of 1000, and a registration fee of $165 USD. The certification is valid for 12 months and renews free through an online assessment on Microsoft Learn.
You're a fit for DP-600 if you:
Not sure if you're ready? Try a free sample quiz: 10 questions, instant results, identify weak areas.
| Domain | Weight | What This Means |
|---|---|---|
| Prepare data | 45–50% | Get data from OneLake, databases, and real-time sources. Transform data using SQL, PySpark, KQL, and Power Query. Implement star schemas, denormalize, aggregate, and resolve data quality issues. Query and analyze data using Visual Query Editor, SQL, KQL, and DAX. |
| Implement and manage semantic models | 25–30% | Design and build semantic models with star schemas, relationships, and DAX calculations. Configure storage modes, Direct Lake, composite models, and calculation groups. Optimize enterprise-scale models for performance, including incremental refresh and DAX tuning. |
| Maintain a data analytics solution | 25–30% | Implement security and governance at workspace, item, row, column, and file levels. Apply sensitivity labels and endorsements. Configure version control, deployment pipelines, and Power BI Desktop projects. Perform impact analysis and manage downstream dependencies. |
Prepare data is the dominant domain at 45–50%. You cannot pass the exam on semantic modeling strength alone. Nearly half your score depends on data ingestion, transformation, and query skills.
You're probably ready if you can:
You might need more prep if:
If this feels too advanced:
If you know the basics but want to build confidence:
The DP-600 exam consists of 40 to 60 questions with 120 minutes of testing time. Question formats include multiple-choice, multiple-response, drag-and-drop ordering, and at least one case study. Some items show DAX or T-SQL and ask you to select or complete the correct statement. The total appointment time is typically longer than 120 minutes, as it includes time for the NDA and exam setup.
The passing score is 700 out of 1000 on a scaled score. Microsoft notes that a scaled score may not equal 70% of the points, so the conversion from raw to scaled scores is not linear. The exam fee is $165 USD in the United States, though pricing varies by region. Microsoft frequently runs free or discounted exam vouchers, particularly for exams in beta or during promotional periods.
The exam covers three domains, measured as of October 19, 2026:
| Domain | Weight |
|---|---|
| Prepare data | 45–50% |
| Implement and manage semantic models | 25–30% |
| Maintain a data analytics solution | 25–30% |
Prepare data is the dominant domain. It covers data ingestion with Dataflows Gen2, pipelines, and shortcuts; transformation in Spark notebooks (PySpark) and T-SQL; managing Delta tables, partitioning, and incremental loads; and choosing between a lakehouse and a warehouse for a given workload. Nearly half your score lives in this domain.
DP-600 is aimed at analytics engineers, BI developers, and data analysts who build analytics solutions on Microsoft Fabric. There is no mandatory prerequisite, but the exam assumes real fluency in:
The exam is a natural next step after PL-300 (Power BI Data Analyst). PL-300 teaches the modeling and visualization layer, while DP-600 adds the data-engineering-adjacent skills that turn a report author into an analytics engineer.
DP-600 validates that you can design, build, and maintain enterprise-scale analytics solutions on Microsoft Fabric. It qualifies you for roles such as Fabric Analytics Engineer, BI Developer, and Data Analyst (Senior) . As Microsoft Fabric gains traction, certified Fabric Analytics Engineers have a competitive edge in the data job market. The certification proves you can deliver analytics on the Fabric platform, not just describe it.
After earning the Fabric Analytics Engineer Associate credential, you can deepen your specialization with:
| Certification | Exam Code | Focus |
|---|---|---|
| Fabric Data Engineer Associate | DP-700 | Data engineering workloads in Fabric |
| Azure Data Scientist Associate | AI-300 (successor) | MLOps and operationalizing ML/GenAI solutions |
| Azure AI Apps and Agents Developer Associate | AI-103 | Generative AI and agentic solutions with Microsoft Foundry |
ExamOS provides Mock Exams and practice modes for these paths to help you transition your skills across the Microsoft data and AI stack.