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 1
Sit a full timed practice exam in the real format and get a score for each skill area.
By the end of this lesson you can
- Finish 50 exam-style questions across all three skill areas in 100 minutes
- Find the constraint word that decides each scenario
- Read a case study and answer questions against its requirements
- Use your per-area score to pick the lessons to revisit
From earlier lessons · 1 of 2
The real DP-600 reports a scaled score from 1 to 1,000. What do you need to pass?
Pick one answer.
From earlier lessons · 2 of 2
You create a deployment rule for a semantic model in the Test stage of a deployment pipeline. When does the rule take effect?
Pick one answer.
It's Thursday evening at Juniper Coffee. You've built the café chain's lakehouse, its Direct Lake model and the regional reports for store managers. Your exam is booked for next week. The next 100 minutes show whether you can make the same decisions against a clock, on questions you've never seen.
How to sit this mock. Treat it like exam day.
- Sit it in one go. The timer runs for 100 minutes, the same as the real exam.
- There are 50 questions. The case study comes last here; on the real exam its place can vary. Keep about 20 minutes for it.
- The pass mark here is 70%. The real exam reports a scaled score, and you need 700 out of 1,000. A scaled 700 isn't the same as 70% correct, so treat 70% as a rough line, not a promise.
- "Choose two" questions score only when you pick both right answers and nothing else.
- Code questions test small details. Read every line before you look at the options.
- Don't look anything up. On the real exam you can open Microsoft Learn, but the clock keeps running.
- When you finish, read every explanation, including the ones you got right. A lucky guess looks the same as knowing the answer in your score.
Timed practice exam
Mock exam 1
- 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. Your result shows a score for each of the three skill areas. Work on the lowest one first.
| 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 |
Each explanation names the lesson behind the question, for example "(lesson 24)". List the lesson numbers you missed and count them. A lesson that shows up three times is worth an hour; one miss may just be a slip.
- 85% or more in an area: you're ready there. Skim the explanations and move on.
- 70-84%: reread the warnings and comparison tables in the lessons you missed.
- Below 70%: redo those lessons, including their quizzes, before mock exam 2.
Don't retake this mock right away. You'd remember the answers, and the score would mean nothing.
Worth keeping
- Most questions turn on one constraint: least privilege, no copy, no code, freshest data or smallest model
- Direct Lake questions turn on the flavor: on SQL can fall back to DirectQuery, on OneLake never does
- Code questions test small details: DESC or ASC, WHERE or HAVING, ON or WHERE, = on one boundary only
- Use your per-area score to pick the lessons to redo before mock exam 2
Next, lesson 34 puts every decision rule from the course on one page and walks you through exam day. Then mock exam 2 checks whether your score has moved.
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
- [198]Microsoft Learn: How Direct Lake works
- [200]Microsoft Learn: Table storage mode in Power BI semantic models
- [245]Microsoft Learn: Configure incremental refresh and real-time data for Power BI semantic models
- [246]Microsoft Learn: Semantic model connectivity with the XMLA endpoint
- [265]Microsoft Learn: Roles in workspaces in Microsoft Fabric
- [306]Microsoft Learn: The deployment pipelines process
- [312]Microsoft Learn: Impact analysis