How to Pass the Microsoft DP-600 Exam in 2026: An 8-Week Fabric Analytics Engineer Study Plan for the New 21 July Objectives

The Microsoft DP-600 exam is passable in eight weeks if you study the current objectives rather than the ones most blog posts still describe. Microsoft last updated the skills measured on 21 July 2026, and a good deal of the free study material in circulation predates that refresh. If you are revising against a four-domain outline you found on a training site, you are revising against a version of the exam that no longer exists.

DP-600 (Implementing Analytics Solutions Using Microsoft Fabric) earns you the Microsoft Certified: Fabric Analytics Engineer Associate credential. You get 100 minutes, you need a score of 700 or greater to pass, and the exam is proctored through Pearson VUE. This guide gives you the current outline, the honest difficulty picture, and an eight-week plan that assumes you have a job and roughly six to eight hours a week to spare.

What the DP-600 Exam Actually Covers in 2026

Microsoft restructured DP-600 into three skill areas. These are the weightings published on the official study guide as of 21 July 2026, and they are what your revision hours should be split against.

The headline is that Prepare data is nearly half the exam. Candidates who come from a Power BI reporting background consistently underweight this domain because it feels like somebody else's job. It is not. Almost one question in two comes from here.

Exam Tip: Prepare data is worth 45 to 50% of DP-600, more than the other two domains combined at their minimums. If your study time is not split roughly 30/45/25, you are studying the wrong exam.

The exam facts, from Microsoft

• Time allotted: 100 minutes.
• Passing score: 700 or greater, on Microsoft's 1 to 1000 scale. This is a scaled score, not a percentage, so do not assume 70% of questions correct.
• Level: Intermediate. There are no formal prerequisites.
• Delivery: Proctored via Pearson VUE, online or at a test centre.
• Languages: English, Japanese, Chinese (Simplified), German, French, Spanish and Portuguese (Brazil). If the exam is not offered in your preferred language, you can request an extra 30 minutes.
• Renewal: Every 12 months, free, via an online assessment on Microsoft Learn. You do not resit DP-600.
• Retakes: You can resit 24 hours after a first failure. Later retakes have longer waits.
• Cost: Priced by the country or region in which the exam is proctored, commonly listed at USD 165 in the United States.

Microsoft does not publish an official question count for DP-600. Candidate reports put it in the region of 45 to 60 items, including a case study block. Treat that as a guide, not a guarantee.

What Changed in the 21 July 2026 DP-600 Objectives

Microsoft's own change log rates the July 2026 update as a light refresh rather than a rewrite. The audience profile did not change, and the Implement and manage semantic models group is unchanged at group level, with the movement concentrated in the Optimize enterprise-scale semantic models sub-area.

That does not make the update irrelevant. It means the trap is subtler: the outline is stable enough that stale study guides look correct, while a handful of specific bullets have quietly become fair game. These are the ones worth checking against your notes.

• Direct Lake on OneLake versus Direct Lake on SQL analytics endpoint. The outline now asks you to choose between the two, not merely configure Direct Lake. Know the trade-offs and when each applies.
• Calculation groups, dynamic format strings and field parameters. These sit as an explicit bullet under designing semantic models. They are no longer advanced extras.
• File-level access control. Security is now listed as row-level, column-level, object-level and file-level. OneLake file security is examinable.
• Impact analysis of downstream dependencies. You need to know how to trace what breaks when you change a lakehouse, warehouse, dataflow or semantic model.
• OneLake catalog and Real-Time hub as the named discovery surfaces, plus OneLake integration for Eventhouse and semantic models.

If you have been away from Fabric for a year, those five bullets are where your gaps will be.

DP-600 vs DP-700 vs DP-800: Which Fabric Certification Should You Take?

This is the single most common question from people about to book, and it comes up in Google's People Also Ask box for the exam. The three exams are not a ladder. They are three different roles.

Take DP-600 if your background is Power BI, reporting and modelling. Take DP-700 if you spend your day in pipelines and notebooks; our DP-700 study plan covers that route. DP-800 is the newest of the three and sits on a separate SQL and AI track rather than replacing either.

DP-600 and DP-700 overlap on lakehouse and warehouse fundamentals, which is why plenty of people sit both. If you are doing that, sit DP-600 first if you are stronger in DAX, and DP-700 first if you are stronger in Python and Spark.

The 8-Week DP-600 Study Plan

This plan assumes six to eight hours a week. Fabric is a hands-on platform and DP-600 punishes pure reading, so every week has a build task. Use a Microsoft Fabric trial capacity or a developer workspace so you can actually click things.

Weeks 1 and 2: Fabric foundations and getting data in

Do not start with DAX. Start by understanding what Fabric actually is, because a large share of wrong answers come from picking the wrong item type rather than writing the wrong code.

• Learn the difference between a lakehouse, a warehouse, an eventhouse and a semantic model, and when each is the right destination.
• Create data connections and practise discovering data through the OneLake catalog and the Real-Time hub.
• Work through the "choose between different data stores" decision, which is a recurring exam pattern.
• Build task: ingest a public dataset into a lakehouse and the same data into a warehouse. Note what you can and cannot do in each.

Weeks 3 and 4: Transforming and querying data

This is the heart of the 45 to 50% domain, so give it a full fortnight.

• Star schema design for both a lakehouse and a warehouse. Know fact tables, dimension tables, denormalisation and aggregation cold.
• Create views, functions and stored procedures. Practise resolving duplicates, nulls and missing data.
• Query the same dataset four ways: Visual Query Editor, SQL, KQL and DAX. The exam expects genuine fluency in all four, not just the one you use at work.
• Build task: take a messy flat file, model it into a star schema, then answer the same three business questions using SQL, KQL and DAX.

Exam Tip: KQL is the most commonly skipped language on DP-600 and the cheapest marks to lose. You do not need to be an expert. You need to read a KQL query and say what it returns.

Weeks 5 and 6: Semantic models and performance

• Storage modes: Import, DirectQuery, Direct Lake and composite models. Know why you would choose each.
• Direct Lake in depth: default fallback behaviour, refresh behaviour, and the choice between Direct Lake on OneLake and Direct Lake on SQL analytics endpoint.
• Relationships including bridge tables and many-to-many.
• DAX beyond the basics: variables, iterators, table filtering, windowing and information functions.
• Calculation groups, dynamic format strings and field parameters. Build one of each so they stop being abstract.
• Incremental refresh and large semantic model storage format.
• Build task: take a slow report and make it measurably faster. Record what you changed and why.

Week 7: Security, governance and the development lifecycle

The Maintain domain is worth up to 30% and is the easiest to revise because it is largely factual rather than syntactic.

• Workspace-level versus item-level access controls, and where each one is the right answer.
• Row-level, column-level, object-level and file-level security. Be able to say which one solves a given scenario.
• Sensitivity labels and endorsement (promoted versus certified).
• Version control for a workspace, Power BI Desktop projects (.pbip), and deployment pipelines.
• Impact analysis of downstream dependencies.
• Deploying and managing semantic models via the XMLA endpoint.
• Reusable assets: .pbit template files, .pbids data source files and shared semantic models.

Week 8: Practice, gaps and exam readiness

Stop learning new material. Week 8 is for closing gaps.

1. Sit Microsoft's free official practice assessment on the DP-600 certification page. It is the best available guide to question style and wording.
2. Sit a full timed practice exam under exam conditions. Score every domain separately.
3. Rebuild anything you scored under 70% on. Actually rebuild it, do not just reread the notes.
4. Run the exam sandbox so the interface is familiar and you are not learning the UI on the day.
5. Do a final pass on the five refreshed bullets listed earlier in this article.

If your practice scores are sitting consistently above 80% by the end of week 8, book it. If they are in the 60s, take another fortnight on Prepare data specifically rather than pushing on and hoping.

How Hard Is the DP-600 Exam, Really?

DP-600 is a genuine intermediate exam and it is harder than its reputation suggests, for one specific reason: it spans two jobs. It expects an analyst's comfort with DAX and semantic modelling and an engineer's comfort with SQL, KQL, lakehouses and warehouses. Most candidates arrive strong in one half and weak in the other.

The failure pattern is predictable. Power BI professionals underestimate Prepare data, which is the largest domain. Data engineers underestimate the semantic model optimisation content, especially Direct Lake behaviour and advanced DAX. Neither group tends to revise the governance content properly because it feels like admin.

The exam is also scenario-heavy. Questions rarely ask what a feature is. They give you a situation and ask which feature solves it, which means recognition-level knowledge is not enough. This is why the build tasks in the plan above matter more than the reading.

The Five Topics That Fail Most DP-600 Candidates

1. Choosing the wrong data store. Lakehouse versus warehouse versus eventhouse comes up constantly and rewards understanding the trade-offs, not memorising definitions.
2. Direct Lake specifics. Fallback and refresh behaviour, and the OneLake versus SQL analytics endpoint choice, are precise topics with precise answers.
3. KQL. Skipped by most, examined anyway.
4. Security granularity. Being able to name row, column, object and file-level security is easy. Picking the right one for a scenario is where marks go.
5. Deployment pipelines and version control. Dull to revise, straightforward to answer, and routinely left until it is too late.

Exam Day: Format, Timing and Tactics

You have 100 minutes. If the exam runs to roughly 50 items, that is about two minutes per question, but the distribution is uneven because case studies eat time.

• Do the case study block deliberately. Read the requirements before the questions, and note the constraints. Case study questions are usually gettable if you read carefully, and they are the most expensive place to rush.
• Flag and move. Never spend more than three minutes on a single item. Flag it, move on, come back with whatever time remains.
• Watch for constraint words. "Minimise cost", "minimise administrative effort" and "with the least amount of development" change which of several technically correct answers is right.
• Expect interactive components. Microsoft states the exam may include interactive elements, so the sandbox run in week 8 is not optional.
• Do not panic about the score scale. 700 out of 1000 is a scaled score. You do not need 70% of questions correct.

If you fail, you can resit after 24 hours. Most people who fail DP-600 fail it narrowly and on one domain, so read the score report and fix that domain rather than starting from scratch.

Frequently Asked Questions

Is DP-600 difficult?

It is a fair intermediate exam that is difficult mainly because of its breadth. You need working knowledge of SQL, KQL, DAX, semantic modelling and Fabric governance in the same sitting. Candidates who prepare hands-on for eight weeks and score above 80% on practice assessments generally pass. Those who revise by reading alone tend not to.

What is a DP-600 certificate?

DP-600 is the Microsoft exam titled Implementing Analytics Solutions Using Microsoft Fabric. Passing it earns the Microsoft Certified: Fabric Analytics Engineer Associate certification, which validates your ability to design, create and manage analytical assets such as semantic models, warehouses and lakehouses in Microsoft Fabric.

How much does the DP-600 certification cost?

Microsoft prices the exam according to the country or region in which it is proctored, and it is commonly listed at USD 165 in the United States. Check the exam page for your own region before booking, since local pricing and taxes vary. Renewal costs nothing: you renew annually through a free online assessment on Microsoft Learn.

What is the passing score for the DP-600 exam?

You need a score of 700 or greater. Microsoft scores on a scale from 1 to 1000, and that scaled score does not correspond directly to a percentage of questions answered correctly, so do not treat 700 as "70% right".

What is the difference between DP-600 and DP-700?

DP-600 certifies the analytics engineer role and centres on semantic models, star schemas, DAX and delivering business-ready analytics. DP-700 certifies the data engineer role and centres on ingestion, pipelines, transformation and orchestration. They share lakehouse and warehouse fundamentals, so many people eventually sit both, but neither is a prerequisite for the other.

Is DP-600 still valid?

Yes. DP-600 is active and was updated as recently as 21 July 2026. It does not appear on Microsoft's 2026 retirement lists. The certification it earns expires after 12 months unless you renew it, which you do for free through an online assessment on Microsoft Learn rather than by resitting the exam. You can check what else is changing in our guide to every Microsoft certification retiring in 2026.

Ready to Start Practising?

Reading about Direct Lake fallback behaviour will not tell you whether you can pick it out of four plausible options under time pressure. Only practice questions do that.

CertCrush gives you exam-style practice with full explanations for every option, so you learn why the three wrong answers are wrong, which is exactly the skill DP-600's scenario questions test. Track your scores per domain, find the gap between your Prepare data and semantic model knowledge, and close it before exam day rather than during it.

Create your free CertCrush account and start practising today. Already studying something else alongside it? Browse the full certification course catalogue, including the PL-300 Power BI Data Analyst study plan if you are building the analyst half of your Fabric skill set first.