The case study can open the exam.
Passers who expected the case study last were surprised to get it as the first group of questions, with a lot of detail. One suggests sketching the requirements on the digital whiteboard.
Microsoft Certified: Fabric Analytics Engineer Associate (DP-600) Exam Guide
Validates knowledge of preparing data and building semantic models in Microsoft Fabric, including governance, SQL, KQL and DAX.
DP-600 tests whether you can prepare, secure and model data for analysis in Fabric through scenarios and a case study. Build lakehouse, warehouse and semantic model work yourself in a Fabric trial, practise SQL, KQL and DAX queries, and give security and Direct Lake real study time.
Understand the exam
Syllabus
Maintain a data analytics solution25–30%
- Implement security and governance
- Maintain the analytics development lifecycle
Example scenario: Sales managers must see only their region's rows in a shared semantic model, and finance must not see a margin column at all. What would you configure?
Prepare data45–50%
- Get data
- Transform data
- Query and analyze data
Example scenario: A lakehouse table has duplicate customer rows with different update times. How would you build a clean dimension table from it in a warehouse?
Implement and manage semantic models25–30%
- Design and build semantic models
- Optimize enterprise-scale semantic models
Example scenario: A Direct Lake model falls back to DirectQuery and reports slow down. What would you check, and how could you stop the fallback?
DP-600 study guide · Skills measured as of October 19, 2026
Format
- Questions
- 40–60
- Duration
- 100 min
- Passing score
- 700 / 1000
- Delivery
- Test centre or online
- Languages
- English, Japanese, Chinese (Simplified), German, French, Spanish, Portuguese
Question types
Choose the best answer from the options, or the stated number of answers when a question asks for more than one.
CertUp example
Each sales manager must see only their own region's rows in a shared semantic model. What should you configure?
Show answer
A. Row-level security filters rows by role. Object-level security hides tables or columns, not rows.
Move items from a list into the correct places, such as matching items to targets or putting steps in order.
CertUp example
Drag each task to the language best suited to it.
Show answer
Write a measure → DAX; query the SQL analytics endpoint → T-SQL; explore events in an eventhouse → KQL.
Choose the correct option for each part of an exhibit or statement list, often Yes or No for each statement.
CertUp example
For each statement, select Yes or No.
Show answer
Yes, No, Yes. The lakehouse SQL analytics endpoint is read-only.
Read one scenario with its background, requirements and exhibits, then answer several questions about it.
CertUp example
Case study: A retailer keeps order history in a Fabric lakehouse and wants reports that read it without copying the data into the model. Question 1 of 3: Which storage mode should the semantic model use?
Show answer
A. Direct Lake reads Delta tables in OneLake directly, so there is no import copy to refresh.
Eligibility and booking
Sign in to Microsoft Learn with a personal Microsoft account, complete your certification profile, then schedule DP-600 with Pearson VUE.
Make a study plan
Take the free practice assessment to see where you start, then work through the official learning paths and build each item in a Fabric trial.
Most candidates spend 40–80 hours. Plan for the low end if you already build Fabric semantic models; add time if Fabric is new to you or you are also new to SQL.
- 1Understand the examRead the syllabus and format, check you’re eligible and pick a target date.3 h
- 3Learn the core conceptsWork through one main course or book, topic by topic.36 h
- 4Practice with mock examsTake timed practice tests and review every mistake.18 h
- 5Prepare for exam dayBook the exam and check the ID and delivery rules.3 h
Learn the core concepts
The free learning paths cover the skills measured. A video course helps if you prefer watching demos. Use a Fabric trial for hands-on practice.
Best free official courseImplement analytics solutions using Microsoft Fabric (DP-600T00)
Best video courseMicrosoft DP-600 prep: Fabric Analytics Engineer AssociateDo not skip security. Passers say workspace and item security, T-SQL and semantic model design carry more weight than basic KQL. Practise each in your trial tenant.
Practice with mock exams
Start with Microsoft's free practice assessment. MeasureUp's official test adds timed sets. Several candidates scored high on practice and still failed, so review every explanation and rebuild weak areas.
Free official checkDP-600 practice assessment
Official practice testDP-600 Practice Test: Implementing Analytics Solutions Using Microsoft Fabric
DP-600 Fabric Analytics Engineer Practice ExamsAre you ready?
- You can set up workspace, item and row-level security without notes.
- You can explain Direct Lake fallback and when to use incremental refresh.
- You can write the same filter and aggregation in SQL, KQL and DAX.
Prepare for exam day
Choose the checklist for your test-centre or online appointment.
Before going to the test centre
Before testing from home
- Bring a current government-issued ID whose name matches your Microsoft certification profile exactly.
- Arrive early enough to check in and store your belongings.
- Allow about 120 minutes of seat time for 100 minutes of questions.
- Run the OnVUE system test on the same computer, network and room you will use. A personal computer works better than a work laptop.
- Use a walled room with a closed door. Clear the desk of notes, pens and extra screens, and keep your phone out of reach.
- Check in from 30 minutes before your appointment. You photograph your ID and workspace with your phone.
- The case study can come first. Use the on-screen whiteboard to note its requirements.
- You can take a break, but the clock keeps running and you cannot return to questions you saw before it.
- You see your score and a skill-area chart within minutes. If you fail, you can retake after 24 hours.
Advice from exam takers
High practice scores do not guarantee a pass.
One candidate failed with 672 despite 80% or more on MeasureUp, then passed with 850 after focused review. Another scored 90 to 100% on practice and still failed.
Do the labs; weight T-SQL and security.
A passer new to Fabric scored 838 after two to three weeks of daily study and said not to skip the Microsoft Learn exercises. Others say KQL questions are basic while T-SQL, security and semantic models carry more weight.