How to prepare for the DP-800 exam
DP-800, the Microsoft Certified: SQL AI Developer Associate exam, is for database developers who build, secure and deploy AI-enabled solutions on SQL Server, Azure SQL and SQL database in Microsoft Fabric, using T-SQL, GitHub CI/CD and AI concepts such as embeddings and vectors.
DP-800 exam at a glance
- Questions
- About 40–60
- Time limit
- 120 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: Design and develop database solutions35–40%
- Domain 2: Secure, optimize, and deploy database solutions35–40%
- Domain 3: Implement AI capabilities in database solutions25–30%
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 70–80% of the exam.
- Domain 1: Design and develop database solutions (35–40%, 8 lessons)
- Domain 2: Secure, optimize, and deploy database solutions (35–40%, 8 lessons)
- Domain 3: Implement AI capabilities in database solutions (25–30%, 6 lessons)
A study plan
- Read the study guide domain by domain. The free DP-800 study guide covers every domain in 22 short lessons, each ending with links to Microsoft Learn.
- Answer the practice scenario after each lesson. There are 22 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-800 mock has 50 questions in 120 minutes, drawn from a bank of 112, 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-800 exam?
- About 40–60 questions, with a 120-minute time limit.
- What is the passing score for DP-800?
- 700 on a scale of 1–1,000.
- How much does the DP-800 exam cost?
- $165 USD (varies by country). The certification is valid for 12 months, renewable free online.
- Which DP-800 domains carry the most weight?
- Design and develop database solutions (35–40%) and Secure, optimize, and deploy database solutions (35–40%).
- Is Skillmarked official DP-800 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.