All 33 lessons
Start here: cloud and data 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. The three languages: SQL, PySpark and KQL side by side
- 6. Getting data in: the map of Fabric tools
Store, ingest and transform batch data (exam area 2, 30-35%)
- 7. Choosing a data store and a transformation tool
- 8. Shortcuts and mirroring: use data without copying it
- 9. Ingest data with pipelines and Copy job
- 10. Transform with PySpark and SQL: join, denormalize, aggregate
- 11. Messy data: duplicates, missing values and late arrivals
- 12. Full and incremental loads, and loading a star schema
Orchestrate and stream (exam areas 1 and 2)
Set up and secure a Fabric solution (exam area 1, 30-35%)
- 18. Workspace settings: Spark, domains, OneLake and data workflows
- 19. Version control with Git and database projects
- 20. Deployment pipelines: development, test and production
- 21. Who can see what: workspace roles and item permissions
- 22. Fine-grained security: rows, columns, objects, files and masking
- 23. Governance: sensitivity labels and endorsement
Monitor, fix and optimize (exam area 3, 30-35%)
- 24. Monitoring hub, alerts and Activator
- 25. Fixing errors in pipelines, dataflows and notebooks
- 26. Fixing errors in Eventhouse, Eventstream and T-SQL
- 27. Optimize lakehouse tables: V-Order, OPTIMIZE, VACUUM and partitions
- 28. Optimize Spark, pipelines and warehouses
- 29. Optimize eventstreams, eventhouses and queries
Exam practice and final review
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 that draw on its requirements
- Use your per-area score to pick the lessons to revisit
From earlier lessons · 1 of 2
On the real exam you reach a Yes/No series: one goal, a proposed solution, and "Does this meet the goal?" What should you remember about these questions?
Pick one answer.
From earlier lessons · 2 of 2
A scenario ends: "The solution must minimize development effort." Two answers would both work. How do you choose?
Pick one answer.
It's Friday afternoon at Northwind Rides. Your exam is booked for Tuesday, and your manager asks if you're ready. You've read every lesson, but you've never answered 50 questions against a clock. The next 100 minutes tell you, and they show you where the remaining gaps are.
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. Here the case study comes last; 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% here as a rough line, not a promise.
- "Choose two" questions score only when you pick both right answers and nothing else.
- For each Yes/No question, judge the solution on its own. Candidates report that on the real exam you can't go back to these.
- 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 |
|---|---|
| Implement and manage an analytics solution | Orchestration: 13, 14, 15. Workspace settings: 18. Git and database projects: 19. Deployment pipelines: 20. Access and security: 21, 22. Labels and endorsement: 23 |
| Ingest and transform data | Tools and stores: 6, 7. Shortcuts and mirroring: 8. Pipelines and Copy job: 9. Transforms: 10, 11. Loads and star schemas: 12. Streaming and KQL: 16, 17 |
| Monitor and optimize an analytics solution | Monitoring and alerts: 24. Errors: 25, 26. Optimization: 27, 28, 29 |
Each explanation names the lesson behind the question, for example "(lesson 21)". 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 the comparison tables in the lessons you missed.
- Below 70%: redo those lessons, including the quizzes, before your next mock.
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 word: least privilege, no code, no copy, near real-time or minimal effort
- Your per-area score tells you which lessons to redo, so start with the lowest area
- Code questions test small details: sort direction, filter signs, MM versus mm, argument order
- Read the case study's requirements first, then answer each question against them
Mock exam 2 uses new scenarios and a different case company. Revisit your weakest lessons first, then see if your score moves.
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.
- [4]Microsoft Learn: Study Guide for Exam DP-700
- [6]Microsoft Learn: Exam duration and exam experience
- [7]Microsoft Learn: Exam scoring and score reports
- [187]Microsoft Learn: Create deployment rules
- [191]Microsoft Learn: Roles in workspaces in Microsoft Fabric
- [196]Microsoft Learn: Data security in OneLake
- [250]Microsoft Learn: .show ingestion failures command
- [257]Microsoft Learn: Query Insights in Fabric Data Warehouse
- [261]Microsoft Learn: Optimize Delta Lake tables with V-order
- [295]Microsoft Learn: Incremental copy in Copy job