How to prepare for the DP-700 exam
DP-700, the Microsoft Certified: Fabric Data Engineer Associate exam, is for data engineers who ingest, transform, secure, monitor and optimize analytics data in Microsoft Fabric, and who work with SQL, PySpark and KQL.
DP-700 exam at a glance
- Questions
- About 40–60
- Time limit
- 100 minutes
- Passing score
- 700 on a scale of 1–1,000
- Exam fee
- $165 USD (varies by country)
- Certification valid for
- 12 months, renewable free online
- Delivery
- Pearson VUE, online proctored or at a test centre. Microsoft Learn is open during the exam
- Retakes
- After 24 hours the first time; longer waits for later retakes
Domains and weights
- Domain 1: Implement and manage an analytics solution30–35%
- Domain 2: Ingest and transform data30–35%
- Domain 3: Monitor and optimize an analytics solution30–35%
Exam details as published when this guide was written. Microsoft can change them, so check the official exam page before you book.
Where to focus
Study in order of weight. The top two domains alone are worth 60–70% of the exam.
- Domain 1: Implement and manage an analytics solution (30–35%, 7 lessons)
- Domain 2: Ingest and transform data (30–35%, 8 lessons)
- Domain 3: Monitor and optimize an analytics solution (30–35%, 8 lessons)
A study plan
- Read the study guide domain by domain. The free DP-700 study guide covers every domain in 23 short lessons, each ending with links to Microsoft Learn.
- Answer the practice scenario after each lesson. There are 23 scenarios, each with an explanation of why every option is right or wrong (the first domain's are free). Read the explanations even when you get one right.
- Take a timed mock exam. The DP-700 mock has 50 questions in 100 minutes, drawn from a bank of 156, and you pass at 72%. It shows your score per domain. Mock exams are part of Pro.
- Go back to your weakest domains, reread those lessons and retake the mock until you pass it comfortably. Then book the real exam.
Frequently asked questions
- How many questions are on the DP-700 exam?
- About 40–60 questions, with a 100-minute time limit.
- What is the passing score for DP-700?
- 700 on a scale of 1–1,000.
- How much does the DP-700 exam cost?
- $165 USD (varies by country). The certification is valid for 12 months, renewable free online.
- Which DP-700 domains carry the most weight?
- Implement and manage an analytics solution (30–35%) and Ingest and transform data (30–35%).
- Is Skillmarked official DP-700 material?
- No. Skillmarked is independent and not affiliated with Microsoft. All lessons and questions are original, written from the public exam outline and Microsoft Learn.