DP-600 Exam Guide 2026: Microsoft Fabric Analytics Engineer Associate
DP-600 is Microsoft’s certification for analytics engineers who prepare data, build semantic models, and optimize DAX and Direct Lake performance on Microsoft Fabric. This guide covers every exam domain, the skills measured as of July 21, 2026, a 6-week study plan with hands-on practice links, DP-600 vs DP-700 vs PL-300, and everything you need to pass first time.
DP-600 (Implementing Analytics Solutions Using Microsoft Fabric) is the Microsoft Certified: Fabric Analytics Engineer Associate exam. It validates your ability to prepare and enrich data, secure and maintain analytics assets, and implement and manage semantic models on Microsoft Fabric. The exam is 100 minutes, roughly 40–60 questions, passing score 700/1000, and costs approximately USD $165. It covers three domains: Maintain a data analytics solution (25–30%), Prepare data (45–50%), and Implement and manage semantic models (25–30%). (per Microsoft Learn official exam page)
What the DP-600 Exam Is and Why It Matters in 2026
DP-600 is Microsoft’s certification for the analytics engineer role — the person who sits between raw data and the business-facing semantic model. It is officially titled Implementing Analytics Solutions Using Microsoft Fabric, and passing it earns you the Microsoft Certified: Fabric Analytics Engineer Associate credential.
Where DP-700 tests your ability to build pipelines and DP-203 (now retired) tested classic Azure Synapse skills, DP-600 sits at the intersection of data preparation and Power BI semantic modeling. It’s the exam that validates you can take data from a Lakehouse or Warehouse and turn it into a fast, well-governed, enterprise-scale semantic model — with heavy emphasis on DAX, Direct Lake, and query languages (SQL, KQL, and DAX all appear).
Who Should Take DP-600
- Power BI developers moving into Fabric-native analytics engineering roles
- Analytics engineers who design semantic models, star schemas, and DAX calculation logic
- BI leads responsible for enterprise-scale semantic model performance and governance
- Data engineers who also own the “last mile” — turning Lakehouse/Warehouse tables into consumable models
- PL-300 holders looking for the natural next-step certification toward senior Fabric roles
Is PL-300 a Prerequisite for DP-600?
Not formally, but Microsoft’s own DP-600 training notes it’s “best suited for those who have the PL-300 certification or similar expertise using Power BI.” If you’re new to Power BI and DAX, take PL-300 first — DP-600 assumes you’re already comfortable with Power Query and basic DAX and builds on that with enterprise-scale semantic modeling, calculation groups, and Direct Lake.
Certification Validity and Renewal
DP-600 is valid for 12 months from the date you pass. Microsoft sends a renewal reminder before expiration. The renewal assessment is free, online, and open-book (Microsoft Learn access), and takes approximately 30 minutes. It covers new Fabric features added since your certification date — not a full re-exam. Fabric ships monthly updates, so renewal keeps your credential aligned with the current platform rather than a year-old snapshot.
DP-600 Exam Domains — Skills Measured as of July 21, 2026
Three domains, unevenly weighted — this is the detail most competing “study guides” gloss over, and it’s the single most important number on this page: Prepare data carries 45–50% of the exam, nearly half. If you split your study time evenly across all three domains, you are under-preparing for the domain that decides the exam.
Domain 1 — Maintain a Data Analytics Solution
- Implement workspace-level and item-level access controls
- Implement row-level, column-level, object-level, and file-level access control
- Apply sensitivity labels to items
- Endorse items (Promoted / Certified)
- Configure version control (Git) for a workspace
- Create and manage a Power BI Desktop project (.pbip)
- Create and configure deployment pipelines
- Perform impact analysis of downstream dependencies
- Deploy/manage semantic models via the XMLA endpoint
Domain 2 — Prepare Data (largest domain — study this first)
- Create data connections; discover data via OneLake catalog & Real-Time hub
- Choose between data stores; implement OneLake integration for Eventhouse and semantic models
- Create views, functions, and stored procedures
- Implement a star schema; denormalize, aggregate, merge/join data
- Resolve duplicate, missing, or null data; convert data types; filter data
- Query and analyze using the Visual Query Editor, SQL, KQL, and DAX
Domain 3 — Implement and Manage Semantic Models
- Choose a storage mode; implement a star schema for a semantic model
- Implement relationships — bridge tables, many-to-many
- Write DAX using iterators, table filtering, windowing, information functions
- Implement calculation groups, dynamic format strings, field parameters
- Configure large semantic model storage format; design composite models
- Improve DAX and report visual performance
- Configure Direct Lake — default fallback and refresh behavior
- Choose Direct Lake on OneLake vs. Direct Lake on SQL analytics endpoint
- Implement incremental refresh for semantic models
Always Check the Current Skills Measured Document
The domains above reflect the skills measured document effective July 21, 2026 (last updated on Microsoft Learn June 22, 2026). Before your exam date, verify the current version at the official DP-600 study guide page — Microsoft revises skills measured periodically as Fabric features reach general availability.
DP-600 vs DP-700 vs PL-300 — Which Certification Should You Take?
| Factor | PL-300 — Power BI Data Analyst | DP-600 — Fabric Analytics Engineer | DP-700 — Fabric Data Engineer |
|---|---|---|---|
| Target role | Report/dashboard builder, self-service BI | Analytics engineer bridging data + BI | Data engineer, pipeline architect |
| Core focus | Power Query, DAX basics, report design, RLS | Data prep, enterprise semantic models, DAX, Direct Lake | Ingestion, orchestration, Spark, optimization |
| Heaviest domain | Model the data (~30%) | Prepare data (45–50%) | Even split, ~30–35% each |
| DAX depth | Core measures, basic time intelligence | Calculation groups, field parameters, iterators, windowing | Not tested |
| Spark / PySpark | Not covered | Not a core focus | Core exam topic |
| KQL coverage | Not covered | Included — query and analyze data | Included — Eventstream/Eventhouse |
| Direct Lake depth | Not covered | Core exam topic — fallback, refresh, storage modes | Lighter coverage |
| Pass score | 700 / 1000 | 700 / 1000 | 700 / 1000 |
| Exam duration | 100 minutes | 100 minutes | 100 minutes |
| Cost (USD) | ~$165 | ~$165 | ~$165 |
| Typical prerequisite path | Entry point | Recommended after PL-300 | Independent — or after DP-600 |
Simple Decision Rule
New to Power BI entirely → start with PL-300. Already comfortable with DAX and Power Query and want to own semantic models, Direct Lake performance, and data prep at enterprise scale → DP-600. Spend most of your day in PySpark, pipelines, and Lakehouse/Warehouse engineering rather than DAX → DP-700. If your role genuinely spans both analytics engineering and data engineering, sit DP-600 first — it has the broader data-prep coverage — then DP-700 for deeper engineering depth. Holding both is the strongest signal to a hiring manager evaluating senior Fabric candidates.
Key Technical Topics You Must Know for the DP-600 Exam
These are the specific Fabric and Power BI capabilities that appear consistently in exam questions based on the official skills measured document. Use this as your study checklist — rate yourself on each topic before you begin and prioritize the Prepare Data and semantic model gaps first, since together they make up 70–80% of the exam.
The most under-studied part of DP-600 is the overlap between OneLake security and Direct Lake. Enabling OneLake data access roles (OneSecurity) on a Lakehouse currently conflicts with Direct Lake semantic models on that same Lakehouse and forces a fallback to DirectQuery — a real production limitation, not just an exam trick question. Know this interaction cold — it shows up both in “configure Direct Lake fallback behavior” objectives and in real deployments.
6-Week DP-600 Study Plan — With Hands-On Practice Links
This plan assumes 1–2 hours of study per day and existing Power BI / PL-300-level familiarity. Candidates newer to Power BI should extend the plan to 8–10 weeks and start with our PL-300 fundamentals before Week 1. Because Prepare Data is 45–50% of the exam, weeks 2–4 below deliberately get the most time.
Free Practice Assessment on Microsoft Learn
Microsoft provides a free DP-600 practice assessment on the official exam page. Take it at the start of Week 1 to baseline your knowledge gaps, and again at the end of Week 6 to verify readiness before scheduling. Pay particular attention to how many missed questions fall under Prepare Data — given its 45–50% weight, that’s where extra review time pays off most.
DP-600 Exam Format — What to Expect on Exam Day
| Factor | Detail |
|---|---|
| Duration | 100 minutes total. Budget extra time before the timer starts for instructions, survey, and NDA acknowledgment. |
| Question count | Approximately 40–60 questions. Exact count varies per exam instance. |
| Question types | Multiple choice, multiple select, drag-and-drop ordering, and case studies (multi-page scenarios with several related questions). |
| Case studies | Multi-page semantic-model or data-prep architecture scenarios — budget 12–15 minutes each. They typically appear at the start of the exam and cannot be revisited after you leave them. |
| Passing score | 700 out of 1000 on Microsoft’s scaled scoring. Not a raw percentage — it adjusts for question difficulty. |
| Microsoft Learn access | Split-screen access to Microsoft Learn is available during the exam, restricted to the learn.microsoft.com domain. Use for DAX function syntax or configuration lookups, not as a primary information source. |
| Exam delivery | Pearson VUE — test center or online proctored (OnVUE). Online proctoring requires a clear desk, no second monitor, no phone. |
| Languages | English, Japanese, Chinese (Simplified), German, French, Spanish, Portuguese (Brazil). |
| Result | Pass/fail displayed immediately after submission. Full score report available in your Microsoft Learn profile within 24 hours. |
| Retake policy | If you fail, you must wait 24 hours before retaking. After a second fail, the wait extends. Maximum attempts apply per Microsoft’s standard retake policy. |
| Renewal | Free renewal assessment on Microsoft Learn, available starting before your 12-month expiration. Approximately 30 minutes, open-book. |
Exam Day Tips and Common Mistakes to Avoid
Before You Sit the Exam
- Weight your study time to match the exam weight. Prepare Data is 45–50% of the exam. If you’ve spent equal time on all three domains, you’re under-prepared for the domain that decides your score.
- Check the skills measured document one week before. Microsoft periodically updates it — confirm no new topics were added since you started studying.
- Use the Exam Sandbox on the Microsoft Learn exam page. It shows the actual exam UI — get comfortable with navigation, flagging, and question review before the real thing.
During the Exam
- Tackle case studies first. They appear early and cannot be revisited. Read all requirements and exhibits before answering any question inside a case study.
- Use Microsoft Learn strategically. Split-screen access is available — use it for exact DAX function syntax or KQL operators you’re unsure about, not to look up every answer.
- Flag uncertain questions and return. DP-600 scenario questions often present multiple technically-valid options — the correct one meets a specific stated constraint (performance, storage mode, refresh cadence).
Common Failure Points
- Treating DP-600 like an extension of PL-300: DP-600 goes considerably deeper into DAX (calculation groups, iterators, windowing), Direct Lake internals, and data preparation with SQL/KQL — surface-level PL-300 knowledge isn’t enough.
- Skipping KQL entirely: Many Power BI-background candidates have never written KQL. It’s explicitly listed under “query and analyze data” in Domain 2 — don’t skip it.
- Not understanding Direct Lake fallback triggers: Knowing what causes a Direct Lake model to fall back to DirectQuery — including the OneLake security (OneSecurity) conflict — is tested directly and matters in production.
- Underestimating Domain 1 governance detail: Row/column/object/file-level access control are each distinct concepts with different configuration paths — don’t lump them together while studying.
Interview Questions as Additional Exam Prep
UIG Data Lab’s Microsoft Fabric interview question banks — particularly the Power BI and Data Warehouse sets — cover scenario-based questions that closely parallel DP-600 exam case studies. They’re organized by workload, making them an efficient way to test domain knowledge before the real exam.
Frequently Asked Questions — DP-600 Exam Guide
Official Resources and All UIG Study Links
Official Microsoft Resources
UIG Data Lab — Complete Study Library by Domain
Every article below maps to specific DP-600 exam domains and topics. Use the study plan above to sequence them.
⚠️ Accuracy Disclaimer
Exam details — domain weights, question count, duration, pass score, and cost — are sourced from the official Microsoft DP-600 exam page and skills measured document (effective July 21, 2026). Microsoft updates exam content regularly. Always verify the current skills measured document before your exam date. UIG Data Lab is an independent publication, not affiliated with or endorsed by Microsoft Corporation.