DP-600 Study Guide 2026: Best Way to Prepare for Fabric Analytics Engineer
By the QlearnAI team · Updated
To pass DP-600 (Microsoft Certified: Fabric Analytics Engineer Associate), plan for about six weeks of study. Spend half of it on preparing data, because that area is worth 45–50% of the exam. Split the rest between semantic models and maintaining a solution, about a quarter each. Practice in Microsoft Fabric with SQL, DAX and a little KQL, then sit a timed mock exam to find your gaps. You need a scaled score of 700 out of 1,000 to pass.
What does the DP-600 exam cover?
Microsoft lists the skills measured on the DP-600 study guide page on Microsoft Learn. The current list is dated October 19, 2026:
| Skill area | Weight |
|---|---|
| Maintain a data analytics solution | 25–30% |
| Prepare data | 45–50% |
| Implement and manage semantic models | 25–30% |
Here is what sits inside each area.
Maintain a data analytics solution
- Access control at workspace and item level, and at row, column, object and file level
- Sensitivity labels and endorsement
- Git version control and Power BI Desktop projects (.pbip)
- Deployment pipelines and impact analysis of downstream items
- Deploying and managing semantic models through the XMLA endpoint
- Reusable assets: .pbit templates, .pbids data source files and shared semantic models
Prepare data
- Creating data connections, and finding data with the OneLake catalog and Real-Time hub
- Choosing between a lakehouse, a warehouse and an eventhouse
- Ingesting data, or accessing it in place with shortcuts and mirroring
- OneLake integration for eventhouses and semantic models
- Views, functions and stored procedures; star schemas; joins, aggregation and cleaning
- Querying with the Visual query editor, SQL, KQL and DAX
Implement and manage semantic models
- Storage modes: Import, DirectQuery, Direct Lake and Dual
- Relationships, bridge tables and many-to-many
- DAX with variables, iterators, table filters, window functions and information functions
- Calculation groups, dynamic format strings and field parameters
- Composite models and the large semantic model storage format
- Performance, Direct Lake fallback and refresh, and incremental refresh
Who is DP-600 for?
DP-600 is for people who turn data into something a business can trust and report on. That includes Power BI developers moving to Fabric, data analysts who want to own the model rather than only the report, and SQL people who sit between data engineers and business users.
If your work is mostly pipelines, Spark and streaming, look at DP-700 instead. Our DP-600 vs DP-700 guide compares the two.
Do you need experience before you start?
No certification is required first. Microsoft expects you to query data with SQL, KQL and DAX, but it doesn't test you on writing long programs. Most code questions ask you to read a short snippet, pick the version that returns the right result, or spot the bug.
If you've never used the cloud or Power BI, give yourself an extra week for the basics: what a tenant and capacity are, what a lakehouse is, and what a semantic model holds. It's a week well spent. Every later topic builds on those ideas.
The best way to prepare for DP-600: a 6-week plan
Weight your time like the exam does. Prepare data gets the most weeks.
| Week | Focus | What to do |
|---|---|---|
| 1 | Basics and getting data | Learn OneLake, workspaces and items. Create a data connection. Find an endorsed item in the OneLake catalog. Compare a lakehouse, a warehouse and an eventhouse for the same data. |
| 2 | Prepare data: shape it | Build a Dataflow Gen2 with filters, type changes, a merge and an append. Remove duplicates and fix nulls in Power Query and in T-SQL. Create a shortcut and look at mirroring. |
| 3 | Prepare data: model and query | Build a star schema with surrogate keys and a slowly changing dimension. Write a view, a function and a stored procedure. Query the same question in the Visual query editor, SQL, KQL and a DAX query. |
| 4 | Semantic models | Pick a storage mode for each table. Build relationships, including a bridge table. Write measures with CALCULATE, variables, an iterator and a window function. Add a calculation group. |
| 5 | Optimize and secure | Set up a Direct Lake model and see when it falls back. Configure incremental refresh. Find a slow visual with Performance analyzer. Add row-level and object-level security, a label and an endorsement. |
| 6 | Lifecycle and review | Connect a workspace to Git and save a .pbip project. Run a deployment pipeline with a rule. Use impact analysis. Sit a full timed mock exam and spend the rest of the week on what you missed. |
Space your reviews out. A short quiz on week 2 in week 4 does more than rereading notes the night before. Our guide on how to learn explains why practice testing and spaced review beat rereading.
What the best DP-600 prep course should give you
Whatever you study with, check it against this list:
- Every skill Microsoft measures, at the right depth. Some topics you must be able to do; others you only need to recognize among four options. A good course tells you which is which, so you don't spend a week on something worth one question.
- Scenario questions, not just recall. Most DP-600 questions describe a situation and one deciding constraint, such as least privilege, no data movement or no refresh window. Practice should look like that.
- Explanations for every option. Knowing why the wrong answers are wrong is how you get the next question right.
- Timed mock exams in the real format. Including multiple-answer questions and a case study, with a score for each skill area.
- Spaced review. Flashcards and questions that come back days later, so week 1 is still there in week 6.
- Current facts. Fabric changes fast. Names, defaults and preview status should match today's Microsoft Learn pages.
We built our free DP-600 exam prep course to meet that list. It has 35 lessons that start from zero, and every lesson is mapped to the skills measured and marked "know it cold" or "recognize it". It also has exam-style scenario quizzes, flashcards for daily review, lessons you can listen to as audio, and two 100-minute timed mock exams with a score per skill area. Each lesson cites the Microsoft Learn pages it relies on. It isn't made by Microsoft, so use it alongside Microsoft Learn. You can start lesson 1 without an account.
Topics that trip people up
These come from the skills list. They're where it pays to slow down, not predictions of real questions.
- Direct Lake. Know when Direct Lake on a SQL analytics endpoint falls back to DirectQuery, and that Direct Lake on OneLake doesn't fall back at all. Know what refresh (framing) does and when to turn automatic updates off.
- Storage modes. Import, DirectQuery, Direct Lake and Dual each fit a different constraint. Learn the constraint words that decide each one.
- Relationships. Cardinality, cross-filter direction, inactive relationships, bridge tables and why bidirectional filters are risky.
- DAX reading. CALCULATE and filter context, SUMX versus SUM, ALL versus ALLSELECTED, and window functions such as OFFSET. Trace small examples by hand.
- Security layers. Row-level security in a semantic model doesn't apply to workspace Admins, Members or Contributors. Warehouse security and OneLake security work differently again.
- Incremental refresh. RangeStart and RangeEnd, the filter that must use
>=on one side and<on the other, and query folding. - Lifecycle. Git versus deployment pipelines, deployment rules, what a deployment doesn't copy, and impact analysis before a change.
Where can you get free DP-600 practice?
- Microsoft's free Practice Assessment at aka.ms/DP600-PA. It's the closest to the real question style. Use it near the end, not on day one.
- The exam sandbox at aka.ms/examdemo, to try the exam screens before the day.
- A Fabric trial, so you can click through everything you study.
- Two timed mock exams in our free DP-600 course, 50 questions each, with a case study and an explanation for every option.
Skip the brain dumps. Microsoft treats them as fraud and can revoke a certification, and they teach you answers, not the work.
How the exam works
- Time: 100 minutes of exam time. Plan for about two hours in the seat.
- Questions: Microsoft exams usually have 40 to 60 questions. Candidates report a case study among them.
- Types: single answer, multiple answer, drag and drop, hot area, and a yes/no series that you can't go back to.
- Pass mark: 700 out of 1,000, scaled. It isn't the same as 70%.
- Microsoft Learn is open in a split screen during the exam, but the clock keeps running. Use it for one or two lookups, not every question.
- Cost: the fee depends on your country; in the US most associate exams cost $165.
- Renewal: free, online and open book, once a year.
Frequently asked questions
How long does it take to study for DP-600?
About six weeks at a few hours a week if you already know some SQL or Power BI. Add a week or two if you're starting from zero with the cloud and data basics.
Is DP-600 hard?
It's broad rather than deep. You need SQL, DAX, Power Query and a little KQL, plus semantic models and deployment. Power BI people usually find data prep the hardest part; SQL people usually find DAX and semantic models the hardest.
What is the passing score for DP-600?
700 out of 1,000. The score is scaled, so 700 isn't the same as getting 70% of questions right.
Can I use Microsoft Learn during the DP-600 exam?
Yes, in a split screen, but no extra time is added. Know the core facts without looking them up and save lookups for one or two details.
What is the best way to prepare for DP-600?
Follow the skills list area by area, build each thing in a Fabric trial, practice with scenario questions that explain every option, and finish with timed mock exams. Our free DP-600 exam prep course is built in that order, from the basics to two full mocks.
Is there a free DP-600 course?
Yes. Microsoft Learn has free self-paced modules for DP-600, and our DP-600 exam prep course is free too: 35 lessons, flashcards, audio and two timed mock exams.
Does the DP-600 certification expire?
It's valid for one year. You renew it for free by passing an online assessment on Microsoft Learn in the six months before it expires.
Should I take DP-600 or DP-700 first?
Take the one closest to your work. DP-600 suits analytics and Power BI work; DP-700 suits pipelines and data engineering. See DP-600 vs DP-700.