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
15 min
Exam day: question types, timing and how to think
Know every DP-700 question type, manage the 100-minute clock and use a method that finds the deciding constraint.
By the end of this lesson you can
- Recognize every DP-700 question type, including the case study and yes/no series
- Budget 100 minutes so the case study gets the time it needs
- Use Microsoft Learn during the exam for a few quick lookups, not every question
- Find the constraint word that decides a scenario question
From earlier lessons · 1 of 3
A KQL filter must match the whole word "Dock" in station names across billions of rows. Which operator is fastest?
Pick one answer.
From earlier lessons · 2 of 3
An Eventhouse keeps 1 year of data with a 1-year hot cache. Only the last 14 days get queried often. How do you cut cost and keep the year?
Pick one answer.
From earlier lessons · 3 of 3
An analyst must read one Lakehouse and nothing else in its workspace. What follows least privilege?
Pick one answer.
Priya, your teammate at Northwind Rides, has booked DP-700 for Friday. She knows Fabric well. What worries her is the exam itself: how long each question gets, what a case study looks like, and whether she can look things up. A strong engineer can still fail on the clock. This lesson makes sure that isn't you.
The exam in numbers
Exam depth: know it cold.
| Fact | Value |
|---|---|
| Exam time | 100 minutes (120 minutes in the seat, with instructions). |
| Questions | Most Microsoft exams have 40 to 60; the exact number varies. |
| Pass mark | 700 on a 1 to 1,000 scale. It's scaled, so it isn't 70%. |
| Wrong answers | No penalty. Answer every question. |
| Multi-part questions | Usually one point per correct part. |
| Skill areas | Three, each 30 to 35% of the exam. |
Some questions are unscored trials, and you can't tell which. Your score report shows a pass or fail, one overall number, and a bar per skill area.
The question types
Exam depth: know it cold.
Microsoft doesn't publish the question types for each exam. Its free exam sandbox (aka.ms/examdemo) lets you try all of them in the real interface.
- Multiple choice: pick one answer, or pick several when the question says how many.
- Drag and drop: move code pieces or terms into slots.
- Build list: put steps in the right order.
- Hot area: click a spot in a picture, or choose from dropdowns inside a code snippet.
- Case study: a long company description with tabs, then several questions about it.
- Yes/no series: Microsoft calls these problem-solution sets. You see one problem and a proposed solution, and answer whether it meets the goal.
Some role-based exams include labs. The overview screens at the start of your exam tell you what yours contains, so read them.
Match
Match each question type to what you do
Pick an item on the left, then its match on the right.
Budget the clock
Exam depth: know it cold.
Candidates advise keeping at least 20 minutes for the case study, and 30 is safer. That leaves about 70 minutes for everything else. As a rough estimate, if you get around 45 standalone questions, that's about a minute and a half each. Your real count may differ.
- Answer every question on the first pass. If you're unsure, pick your best guess and mark it for review. A blank never scores.
- Don't let one question eat five minutes. Guess, mark, move on.
- Check the clock at the halfway question. If you're behind, speed up there, not at the end.
- Use the review screen last. It lists the questions you marked.
Breaks are allowed, but the clock keeps running. After a break you can't return to any question you saw before it.
Microsoft Learn in the exam: a few lookups only
Exam depth: know it cold.
DP-700 is a role-based exam, so you can open Microsoft Learn during it. It opens in a split screen beside the question.
- You can browse everything on learn.microsoft.com except Q&A, Practice Assessments and your profile. Other websites are blocked.
- No extra time is added. The clock runs while you read.
- Ctrl+F (Command+F on a Mac) finds text on the open page.
Microsoft says plainly that if you look up every question, you won't finish, and that is by design.
Use it for one or two exact facts: an operator's syntax, a setting name, a limit. One candidate's advice: answer everything first, then use any spare time for lookups.
- Decision guide: choose a data store (Lakehouse, Warehouse, Eventhouse, SQL database)
- Decision guide: choose a data movement strategy (Mirroring, Copy job, copy activity, Eventstreams)
- Decision guide: copy activity, Copy job, dataflow, Eventstream, or Spark
- Roles in workspaces in Microsoft Fabric (the full Admin, Member, Contributor, Viewer table)
- Best practices for Kusto Query Language queries (the "In short" table)
Find the constraint word
Exam depth: know it cold.
Most DP-700 scenarios have two or three answers that would work. One phrase, the constraint word, decides which is best. Use the same four steps every time.
- Read the last sentence first. It tells you what to pick: a tool, a setting, a role or a line of code.
- Find the constraint. Look for phrases like least effort, no code, cheapest, least privilege, near real-time or without copying data.
- Cross out options that break it. A notebook breaks no code. A workspace role breaks least privilege when one item is enough.
- Pick the option that meets the goal and the constraint best. Ignore options that are clever but unasked.
Common constraint words and where they usually point:
| Constraint in the question | Usually points to |
|---|---|
| Without copying the data | a shortcut. |
| Free replication of a database | Mirroring. |
| No code, a business analyst maintains it | Dataflow Gen2 or Copy job. |
| Simple copy, no pipeline to build | Copy job. |
| Near real-time events | Eventstream into an Eventhouse. |
| Least privilege for one item | share the item, not a workspace role. |
These are patterns, not laws. Always check the rest of the scenario still fits.
You are a data engineer at Northwind Rides. Station maintenance files sit in an Amazon S3 bucket owned by a partner. Analysts need to query them from a Lakehouse. The data must not be duplicated in OneLake. What should you use?
Pick one answer.
Booking, ID, retakes and renewal
Exam depth: recognize it.
Booking. Schedule from the certification page through Pearson VUE, Microsoft's exam delivery partner. You can test online or at a test center. Online, you run a system test first. You sit in a walled room with the door closed, nobody else, and a clear desk. A proctor, the exam supervisor, watches by webcam. At most two exams can be scheduled at once.
ID. Bring one original, unexpired, government-issued photo ID. Your name on it must match your certification profile exactly.
Language. If DP-700 isn't offered in your language, you can request 30 extra minutes.
Retakes. Failed? Wait 24 hours for the second try, then 14 days between later tries. You get at most five attempts in 12 months.
Renewal. The certification lasts one year. Renewing is free: an online, unproctored, open-book assessment you take in the six months before it expires. You can retake it until you pass, as long as the certification hasn't expired.
Exam-style practice
You're in a yes/no series about loading Northwind's trip data. The first proposed solution looked right, so you answered Yes. The second solution also looks right. What should you do?
Pick one answer.
You have 30 minutes left. The case study hasn't started, and you have 8 marked questions to review. What should you do?
Pick one answer.
A question asks for the KQL operator that reads only the stored part of a materialized view. You're torn between two similar names. You're on schedule. What's the best use of Microsoft Learn here?
Pick one answer.
Priya passed DP-700 last year. Her certification expires in four months. What should she do to keep it?
Pick one answer.
Worth keeping
- 100 minutes, a scaled pass mark of 700, and no penalty for guessing: answer everything.
- Keep 20 to 30 minutes for the case study; mark hard questions and move on.
- In a yes/no series, judge each solution alone and answer once; candidates report you can't go back.
- Microsoft Learn is open but costs time: use it for one or two exact facts.
- Read the last sentence first, find the constraint word, cross out options that break it.
You have the method. Now test it under real pressure: Mock exam 1 is a full timed set across all three skill areas, case study included. Sit it in one go, with a timer, and no notes.
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 (18)
Each fact in the lesson is marked with the number of the page it comes from.
- [1]Microsoft Learn: Renew your Microsoft Certification
- [2]Microsoft Learn: Register and schedule an exam
- [4]Microsoft Learn: Study Guide for Exam DP-700
- [5]Microsoft Learn: Microsoft Certified: Fabric Data Engineer Associate
- [6]Microsoft Learn: Exam duration and exam experience
- [7]Microsoft Learn: Exam scoring and score reports
- [67]Microsoft Learn: Get data into Microsoft Fabric
- [68]Microsoft Learn: Microsoft Fabric decision guide: copy activity, Copy job, dataflow, Eventstream, or Spark
- [69]Microsoft Learn: Microsoft Fabric decision guide: Choose a data movement strategy
- [73]Microsoft Learn: Microsoft Fabric decision guide: choose a data store
- [191]Microsoft Learn: Roles in workspaces in Microsoft Fabric
- [282]Microsoft Learn: Best practices for Kusto Query Language queries
- [288]Microsoft Learn: Exam and Applied Skills assessment lab retake policies
- [289]Microsoft Learn: About online exams with Pearson VUE
- [290]Microsoft Learn: Exam and assessment lab security policy
- [291]Microsoft Learn: Frequently asked questions (FAQs) about online proctored exams
- [292]Datakuity: Tips for the DP-700 exam (candidate report)
- [293]Microsoft Learn: Best practices for OneLake security