Black Friday50% off your first month on any monthly plan with EARLY50 See plans
All 33 lessons
  1. Start here: cloud and data basics

    1. 1. Start here: the exam, the plan and what you already know
    2. 2. Cloud in plain words: SaaS, PaaS, IaaS and where Fabric fits
    3. 3. Data basics: files, tables, formats and the lakehouse idea
    4. 4. A tour of Microsoft Fabric: OneLake, workspaces and items
    5. 5. The three languages: SQL, PySpark and KQL side by side
    6. 6. Getting data in: the map of Fabric tools
  2. Store, ingest and transform batch data (exam area 2, 30-35%)

    1. 7. Choosing a data store and a transformation tool
    2. 8. Shortcuts and mirroring: use data without copying it
    3. 9. Ingest data with pipelines and Copy job
    4. 10. Transform with PySpark and SQL: join, denormalize, aggregate
    5. 11. Messy data: duplicates, missing values and late arrivals
    6. 12. Full and incremental loads, and loading a star schema
  3. Orchestrate and stream (exam areas 1 and 2)

    1. 13. Pipeline or notebook? Choosing how to orchestrate
    2. 14. Schedules and event-based triggers
    3. 15. Parameters and dynamic expressions
    4. 16. Streaming in Fabric: Eventstreams, Spark streaming and KQL
    5. 17. KQL and windowing functions for real-time data
  4. Set up and secure a Fabric solution (exam area 1, 30-35%)

    1. 18. Workspace settings: Spark, domains, OneLake and data workflows
    2. 19. Version control with Git and database projects
    3. 20. Deployment pipelines: development, test and production
    4. 21. Who can see what: workspace roles and item permissions
    5. 22. Fine-grained security: rows, columns, objects, files and masking
    6. 23. Governance: sensitivity labels and endorsement
  5. Monitor, fix and optimize (exam area 3, 30-35%)

    1. 24. Monitoring hub, alerts and Activator
    2. 25. Fixing errors in pipelines, dataflows and notebooks
    3. 26. Fixing errors in Eventhouse, Eventstream and T-SQL
    4. 27. Optimize lakehouse tables: V-Order, OPTIMIZE, VACUUM and partitions
    5. 28. Optimize Spark, pipelines and warehouses
    6. 29. Optimize eventstreams, eventhouses and queries
  6. Exam practice and final review

    1. 30. Exam day: question types, timing and how to think
    2. 31. Mock exam 1
    3. 32. Mock exam 2
    4. 33. Final review: every decision on one page
See the leaderboard

100 min

Mock exam 2

Sit a second full timed practice exam with new scenarios and a new case study, then compare your area scores.

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
  • Choose the last lessons to review before exam day

From earlier lessons · 1 of 2

On the real exam, a case study is a long company scenario followed by several questions. How much time should you keep for it?

Pick one answer.

From earlier lessons · 2 of 2

A lakehouse table has thousands of tiny files and storage full of old versions. Which pair of commands fixes both problems?

Pick one answer.

Back at Northwind Rides, your mock exam 1 score showed one weak area, and you spent the week on those lessons. Now the real test of that work: a new set of 50 questions you've never seen, with a different case company. If your weakest area moved up, the review worked.

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.

[6][7]

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%.

[4][74][161][191][196][211][213][255]

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 areaBelow 70%? Revisit these lessons
Implement and manage an analytics solutionOrchestration: 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 dataTools 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 solutionMonitoring 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.

Compare each area with your mock exam 1 score. An area that rose is working. An area that stayed low needs one more pass before exam day.

[4]

Mock 1: guessing. Mock 2: reading the constraint first. Picture: Two-panel claymation-style scene.

Worth keeping

  1. A second mock with new scenarios shows whether your review worked
  2. Security questions turn on scope: workspace role, item share, schema, column, row or folder
  3. Streaming questions turn on code or no code: Eventstream for no code, Spark structured streaming for code
  4. Optimization questions name a symptom, so match it to the fix the lessons paired it with

One lesson left: every decision from this course on a single page, so the night before the exam is a quick read and not a cram.

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.

  1. [4]Microsoft Learn: Study Guide for Exam DP-700
  2. [6]Microsoft Learn: Exam duration and exam experience
  3. [7]Microsoft Learn: Exam scoring and score reports
  4. [74]Microsoft Learn: OneLake shortcuts
  5. [161]Microsoft Learn: Configure high concurrency mode for Fabric notebooks in pipelines
  6. [191]Microsoft Learn: Roles in workspaces in Microsoft Fabric
  7. [196]Microsoft Learn: Data security in OneLake
  8. [211]Microsoft Learn: Sensitivity label downstream inheritance
  9. [213]Microsoft Learn: Endorsement overview
  10. [255]Microsoft Learn: Transactions in Fabric Data Warehouse