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
Start here: the exam, the plan and what you already know
See what DP-700 tests, how this course gets you to a pass on your schedule, and where you should start.
By the end of this lesson you can
- State the DP-700 exam facts: time, questions, pass mark and renewal
- Name the three skill areas, their weights and where this course covers them
- Claim the free Data Days voucher and book your exam
- Pick your starting lesson from a six-question self-check
It's Monday at Northwind Rides, a city bike-and-scooter rental company. You've just joined as its data engineer. By Friday the ops manager wants a report of scooter trips by station, and finance wants payment data it can trust. The data sits in four different places, and none of them talk to each other.
DP-700 in one minute
DP-700 is Microsoft's exam for the Microsoft Certified: Fabric Data Engineer Associate certification. Its full title is Implementing Data Engineering Solutions Using Microsoft Fabric.
Microsoft Fabric is Microsoft's analytics platform. It brings data storage, data movement, transformation, real-time data and reports into one online service. Its reports come from Power BI, Microsoft's reporting tool.
The facts you need:
- Time: 100 minutes to answer, as the DP-700 exam page states. Plan about 120 minutes in the seat, with instructions.
- Questions: Microsoft says most of its exams have 40 to 60 and doesn't give a DP-700 count. Candidates report about 40 questions, then a case study at the end. That count isn't official. A case study is a long company scenario with several questions about it.
- Pass mark: 700 or more, on a scale of 1 to 1,000.
- No penalty for guessing: a wrong answer just scores zero, so answer everything.
- Renewal: the certification lasts one year. You renew it free with a short online assessment, open book, in the six months before it expires.
- Language: if the exam isn't offered in your language, you can request 30 extra minutes.
The three skill areas, and where this course covers them
Microsoft publishes the skills measured: the official list of what the exam tests. It has three skill areas, each worth 30-35% of the exam.
| Skill area | Weight | Where you learn it here |
|---|---|---|
| Implement and manage an analytics solution | 30-35% | Module 3, lessons 13-15. Module 4, lessons 18-23. |
| Ingest and transform data | 30-35% | Module 2, lessons 7-12. Module 3, lessons 16-17. |
| Monitor and optimize an analytics solution | 30-35% | Module 5, lessons 24-29. |
Module 1 (lessons 1-6) gives you the basics all three areas need. Module 6 (lessons 30-33) is exam day: timing, two mock exams and a final review.
The weights are equal. So no area is safe to skip, and the one you find dullest still decides a third of your score.
Match
Match each skill from the official list to its skill area
Pick an item on the left, then its match on the right.
A colleague is booked for DP-700 in three weeks. He plans to skip monitoring and optimization because it's "only one area" and he finds it dull. What's the problem with his plan?
Pick one answer.
Take the exam free: the Data Days voucher
Microsoft's Data Days event offers a voucher that covers 100% of the DP-700 exam fee. A voucher is a code you enter instead of paying.
Claim it:
- Open the Data Days voucher page.
- Pick the 100% offer and fill out the short form. You need a free account on the Fabric Community, Microsoft's online forum for Fabric users.
- Watch your Fabric Community inbox. The code arrives there by private message, not by email. It can take up to 2 weeks.
The rules: take the exam by December 31, 2026. You get one voucher per person, supplies are limited, and eligibility requirements apply. Vouchers can't be extended.
Book the exam:
- Open the exam page on Microsoft Learn and select the button to schedule the exam.
- Sign in to your Learn profile. Microsoft recommends a personal Microsoft account. Your legal name must match your ID.
- Fill in your contact details. You then move to Pearson VUE, the company that runs the exam.
- Choose an online exam from home or a test center, then a date.
- On the payment screen, select Add Voucher or Promo Code and enter your code.
How this course works
Depth tags. Microsoft's docs link deeper at every step, so it's easy to study the wrong things. Each topic here opens with one of these tags:
- Exam depth: know it cold. You must choose it or do it in a scenario. You get the settings and traps.
- Exam depth: recognize it. You must pick it out of four options. You get one line on what it is and how it differs from its look-alike.
- Not on the exam. You get a short note on what to ignore and why.
Exam-style questions. Most questions are scenarios at Northwind Rides, the company you work for in this course. Each has one constraint that decides the answer.
Daily review. The flashcards and questions you get wrong come back about 1, 3, 7 and 30 days after each lesson. Five minutes a day beats a long weekend cram.
Two timed mock exams. Lessons 31 and 32 run like the real exam, with a score for each skill area. They show you what to revise.
XP and the leaderboard. You earn 50 XP for each lesson you finish. You earn 10 XP for each right answer in quizzes, recaps, this self-check and a passed mock exam. Answers to the self-check and the basics lessons count even if you then skip those lessons.
Your XP shows in the lesson list under Listen & review, next to a Leaderboard link. The leaderboard ranks learners by XP. It shows only people who turn on Show me on leaderboards in their profile settings, as first name and last initial.
Meet Northwind Rides
Northwind Rides is fictional, but its data is typical. You'll build its data platform in Fabric across this course.
- Trip events stream from scooters every few seconds: start, location, battery, end.
- A SQL Server database holds customers and payments. SQL Server is Microsoft's database product.
- CSV files of station maintenance arrive from a repair partner each night. CSV is a plain text file of comma-separated values.
- Power BI reports show the ops team how the fleet is doing.
Your job is to bring that data together, keep it correct and secure, and keep it running. That's what a Fabric data engineer does, and it's what DP-700 tests.
Self-check: where should you start?
Six quick questions on cloud and data basics. Answer without looking anything up. Lessons 2 and 3 teach all of this from zero.
Northwind Rides wants a data platform where it never installs, patches or sizes servers. It just signs in and builds. Which cloud service model fits that need?
Pick one answer.
In Microsoft Fabric, what gives a workspace the compute power to run its queries and jobs?
Pick one answer.
Northwind Rides opens in Berlin. A rule says Berlin riders' trip data must be stored in the EU. The company's Fabric home region is in the US. What decides where a workspace's data is stored?
Pick one answer.
A trips file has 60 columns and 500 million rows. An analyst only needs the average trip length. Why does this query run faster on Parquet than on CSV?
Pick one answer.
Fabric stores tables in Delta Lake format. What does Delta Lake add on top of plain Parquet files?
Pick one answer.
Northwind's SQL Server database records each payment the moment a rider ends a trip, thousands of small writes an hour. What kind of system is that?
Pick one answer.
Got 5-6 right? Start at lesson 4. Fewer? Start at lesson 2.
Everyone should take lessons 4, 5 and 6. They tour Fabric itself, its three query languages and its loading tools, and every later lesson builds on them.
Worth keeping
- DP-700: 100 minutes, a pass at 700 of 1,000 (scaled). Candidates report about 40 questions plus a case study.
- Three skill areas, each 30-35%, so none is safe to skip.
- Request the Data Days voucher now; it takes up to 2 weeks, and the exam is due by Dec 31, 2026.
- Microsoft Learn is open during the exam, but the clock keeps running.
- Self-check: 5-6 right, start at lesson 4; fewer, start at lesson 2.
The first self-check question said Fabric is SaaS, so you never touch a server. Then who runs the machines, and what exactly are you paying for? Lesson 2 answers that in plain words.
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 (15)
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
- [3]Microsoft Learn: Vouchers and redeeming discounts
- [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
- [8]Microsoft Fabric Community: Data Days | Certification Vouchers
- [9]Microsoft Learn: What is Microsoft Fabric?
- [10]Microsoft Learn: Understand Microsoft Fabric licenses and capacity
- [11]Microsoft Learn: Explore file storage
- [12]Microsoft Learn: Delta Lake overview
- [13]Microsoft Learn: Explore transactional data processing
- [14]Microsoft Learn: Find your Fabric home region
- [15]Microsoft Learn: Configure Multi-Geo support for Fabric