Sign In
All study guides
DP-800

Developing AI-Enabled Database Solutions Study Guide

A study path for Microsoft Certified: SQL AI Developer Associate — what to know before you start, and the order worth doing things in.

Exam at a glance

Length100–120 min (may include labs)
Questions40–60
Passing score700 / 1000
FormatsMultiple choice, drag-and-drop, case studies, possibly labs
Microsoft Learn accessAvailable (split-screen)
RenewalEvery 12 months, free online assessment
PrerequisiteNone

DP-800: exam domains

Dive deep into each exam objective with comprehensive study materials.

35-40%
Design and Develop Database Solutions
Build tables, indexes, and specialized object types; write advanced T-SQL; and safely bring GitHub Copilot and MCP into the database development workflow.
35-40%
Secure, Optimize, and Deploy Database Solutions
Lock down data with encryption, masking, and row-level security; tune performance with execution plans and Query Store; and ship schema changes through SQL Database Projects and Data API builder.
25-30%
Implement AI Capabilities in Database Solutions
Register external models and generate embeddings in T-SQL, build exact and approximate vector search with the native VECTOR type, and assemble retrieval-augmented generation with sp_invoke_external_rest_endpoint.

Where this exam fits

DP-900 · optional groundworkDP-800
Download PDF cheatsheet
Complete DP-800 study guide in PDF format

Prerequisites

No strict prerequisites, but the exam assumes subject matter expertise designing and developing AI-enabled database solutions across Microsoft SQL Server, Azure SQL, and SQL databases in Microsoft Fabric. You should be comfortable writing T-SQL, familiar with CI/CD in GitHub, and know AI concepts such as embeddings, vectors, and models.

Recommended background

  • T-SQL fundamentals — tables, constraints, views, stored procedures, and CTEs
  • Core database security concepts — encryption, masking, and row-level security
  • Basic familiarity with AI concepts like embeddings, vector search, and RAG
  • Comfort with GitHub-based CI/CD and Copilot-assisted development

Step-by-step study plan

1
Review the official study guide

Open Microsoft's official skills-measured breakdown and use it as your checklist — it's updated whenever the exam changes.

Official DP-800 study guide
2
Schedule your exam

Pick a date through the official Microsoft certification page and plan your study time backwards from it. Give yourself 2–4 weeks if you already use the tech weekly, 4–8 weeks if you're newer to it.

Exam & scheduling page
3
Go through the official learning path

Complete Microsoft's free, self-paced modules for this exam. Take notes on anything you can't explain simply — that's what to revisit.

Official documentation
4
Get hands-on practice

DP-800 rewards recognizing real scenarios and trade-offs, not memorization. Spin up a free-tier environment and actually try the concepts — resource provisioning, networking, access controls — rather than just reading about them.

5
Benchmark your knowledge

Use FabricPrep's DP-800 practice questions to find weak spots, and sit the timed Shield exam to build comfort with exam-day pacing.

Practice DP-800 now — 90 free questions
6
Take the exam

The day before: review only your weak topics, don't cram new material. On exam day: read each question carefully, eliminate wrong answers first, and watch for wording that implies a constraint (least privilege, cost, performance).

Additional resources

Official DP-800 study guide
The authoritative skills-measured breakdown, updated whenever the exam changes
Microsoft Fabric docs
Covers SQL databases in Fabric, one of the platforms the exam spans
Azure SQL docs
Canonical T-SQL and cross-platform SQL reference
Ready to test yourself?

90 realistic DP-800 practice questions with instant feedback and detailed explanations.

Practice DP-800 now