All 35 lessons
Start here: cloud, data, Fabric and Power BI basics
- 1. Start here: the exam, the plan and what you already know
- 2. Cloud in plain words: SaaS, PaaS, IaaS and where Fabric fits
- 3. Data basics: files, tables, formats and the lakehouse idea
- 4. A tour of Microsoft Fabric: OneLake, workspaces and items
- 5. Power BI in plain words: semantic models, reports and DAX
Prepare data: get data in (exam area 2, 45-50%)
- 6. Connect to data and find it: connections, gateways, OneLake catalog and Real-Time hub
- 7. Choosing a data store: lakehouse, warehouse or eventhouse
- 8. Use data without copying: shortcuts, mirroring and OneLake integration
- 9. Ingest data: Dataflow Gen2, pipelines, Copy job and notebooks
- 10. Power Query in Dataflow Gen2: filter, data types, merge and new columns
- 11. Messy data: duplicates, missing values and nulls
Prepare data: transform and query (exam area 2)
Design and build semantic models (exam area 3, 25-30%)
- 18. Choose a storage mode: Import, DirectQuery, Direct Lake and Dual
- 19. Relationships: star schemas, bridge tables and many-to-many
- 20. DAX foundations: measures, filter context, CALCULATE and variables
- 21. DAX functions the exam tests: iterators, table filters, windows and information functions
- 22. Calculation groups, dynamic format strings and field parameters
- 23. Composite models and large semantic model storage format
Optimize models, then secure them (exam areas 3 and 1)
- 24. Direct Lake in depth: fallback, refresh and the two flavors
- 25. Incremental refresh for semantic models
- 26. Faster reports and DAX: finding and fixing slow queries
- 27. Who can see what: workspace roles and item permissions
- 28. Fine-grained security: rows, columns, objects and files
- 29. Governance: sensitivity labels and endorsement
Lifecycle, then exam practice (exam area 1)
100 min
Mock exam 2
Sit a second full timed practice exam with new questions and a new case study, then check you're ready.
By the end of this lesson you can
- Finish a second 50-question timed exam with new scenarios and a new case company
- Compare your per-area scores with mock exam 1 to see what improved
- Spot the deciding constraint quickly under time pressure
- Decide whether you're ready to book the real exam
From earlier lessons · 1 of 2
During the real exam, you take an unscheduled break. What happens to the questions you saw before the break?
Pick one answer.
From earlier lessons · 2 of 2
Microsoft Learn is available during the real DP-600 exam. How should you use it?
Pick one answer.
A week later at Juniper Coffee, your mock exam 1 scores sit on a sticky note beside the till-sales dashboard. You've redone the lessons your weakest area pointed to. Now 50 new questions and a new case company show whether that work paid off.
How to sit this mock. Treat it like exam day, the same way as mock exam 1.
- Sit it in one go. The timer runs for 100 minutes, the same as the real exam.
- There are 50 questions with the same blueprint as mock exam 1, but every scenario is new. The case study comes last; keep about 20 minutes for it.
- The pass mark here is 70%. The real exam needs a scaled 700 out of 1,000, which isn't the same as 70% correct.
- "Choose two" and "Choose three" questions score only when you pick every right answer and nothing else.
- Don't look anything up. On the real exam Microsoft Learn is open in a split screen, but the clock keeps running.
- When you finish, read every explanation, including the ones you got right.
Timed practice exam
Mock exam 2
- 50 questions, including 1 case study
- 100 minutes. The timer keeps running if you leave the page.
- No answers are shown until you submit. Pass mark: 70%.
What to do with your score. Compare each area with your mock exam 1 score. An area that rose is working. An area that stayed low needs one more pass.
| Skill area | Below 70%? Revisit these lessons |
|---|---|
| Maintain a data analytics solution | Workspace roles and item permissions: 27. Row, column, object and folder security: 28. Labels and endorsement: 29. Git and .pbip: 30. Deployment pipelines and impact analysis: 31. XMLA and reusable assets: 32 |
| Prepare data | Connections and discovery: 6. Choosing a store: 7. Shortcuts, mirroring and OneLake integration: 8. Ingestion: 9. Power Query: 10. Messy data: 11. Views, functions and procedures: 12. Star schemas: 13. Aggregate and join: 14. Visual query editor and SQL: 15. KQL: 16. DAX queries: 17 |
| Implement and manage semantic models | Storage modes: 18. Relationships: 19. DAX: 20, 21. Calculation groups and field parameters: 22. Composite and large models: 23. Direct Lake: 24. Incremental refresh: 25. Performance: 26 |
Readiness rule. Book the real exam when you score 80% or more on both mock exams. That 80% leaves a margin for new question wording and for the scaled score.
- 80% or more on both: book the exam. Reread lesson 34's decision tables the night before.
- 70-79% on either: redo the lessons behind every miss, then take Microsoft's free practice assessment for DP-600 before you book.
- Below 70%: work through your two lowest areas again, lesson by lesson, before you book.
Don't retake either mock to raise the number. You'd be testing your memory of these questions, not your skills.
Worth keeping
- Book the real exam when you score 80% or more on both mock exams
- Security questions turn on scope and engine: workspace role, item permission, OneLake folder, SQL row or model role
- Lifecycle questions turn on what a deployment copies: metadata yes; data, credentials and role members no
- Semantic model questions turn on storage mode, relationships and filter context, so read DAX line by line
- On exam day, find the constraint word first, then pick the answer that meets it
Leaderboard
Loading…
50 XP for each lesson you finish, 10 for each right answer. Names show only for learners who turn on Show me on leaderboards.
Sources for this lesson (10)
Each fact in the lesson is marked with the number of the page it comes from.
- [3]Microsoft Learn: Exam duration and exam experience
- [4]Microsoft Learn: Exam scoring and score reports
- [6]Microsoft Learn: Study guide for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric
- [40]Microsoft Learn: What is Mirroring in Fabric?
- [45]Microsoft Learn: Direct Lake overview
- [139]Microsoft Learn: T-SQL surface area in Fabric Data Warehouse
- [281]Microsoft Learn: Dynamic data masking in Fabric Data Warehouse
- [283]Microsoft Learn: Row-level security in Fabric Data Warehouse
- [306]Microsoft Learn: The deployment pipelines process
- [324]Microsoft Learn: How OneLake security controls data access