The short version
DP-800 is Microsoft’s associate-level exam for developers who build AI-enabled database solutions on SQL platforms. It mixes classic database development (T-SQL, JSON, security, CI/CD) with newer work: embeddings, vector search, and retrieval-augmented generation (RAG). This guide uses the study guide that Microsoft lists as “Skills measured as of October 19, 2026”.
What the exam is
The full name is Developing AI-Enabled Database Solutions. Passing it earns the Microsoft Certified: SQL AI Developer Associate credential, which Microsoft labels as intermediate level. Microsoft describes the platforms in scope as Microsoft SQL Server, Azure SQL, and SQL databases in Microsoft Fabric.
This is a developer exam, not a theory exam. The skills list uses verbs like “design”, “implement”, “write”, “configure”, and “create”. Expect to choose the right T-SQL, the right setting, or the right sequence of steps, usually inside a short work scenario. You may also meet interactive components, which Microsoft mentions on the exam page without naming the format.
Two things make DP-800 different from older SQL developer exams. First, a quarter or more of it is about AI in the database: external models, vector data, hybrid search, and calling a language model from T-SQL. Second, it expects modern engineering habits, such as source-controlled database projects, pull requests, and deployment pipelines.
Who it is for
Microsoft says candidates should have subject matter expertise in designing and developing AI-enabled database solutions, experience writing T-SQL and developing databases, and familiarity with CI/CD in GitHub, AI-assisted development tools, and AI concepts such as embeddings, vectors, and models. The typical reader of this page is a database developer, a SQL Server or Azure SQL professional, or an application developer who now owns the data layer. Microsoft lists no formal prerequisite exam. See the prerequisites page for a self-check.
Format at a glance
| Item | What Microsoft says |
|---|---|
| Exam code | DP-800 |
| Level | Intermediate |
| Time | 120 minutes to complete the assessment |
| Passing score | 700 or greater on a scale of 1 to 1,000 |
| Delivery | Proctored, scheduled through Pearson VUE |
| Languages | 10, including English, Spanish, French, and Portuguese (Brazil) |
| Number of questions | Not published; Microsoft says most exams have 40 to 60 |
The exam format page covers scoring, breaks, retakes, and renewal.
The three domains and their weightings
| Domain | Weighting |
|---|---|
| Design and develop database solutions | 35-40% |
| Secure, optimize, and deploy database solutions | 35-40% |
| Implement AI capabilities in database solutions | 25-30% |
Design and develop database solutions
Tables, indexes, and constraints, specialized tables (in-memory, temporal, external, ledger, graph), JSON columns, sequences, and partitioning. Then views, functions, stored procedures, and triggers, plus advanced T-SQL: CTEs, window functions, JSON and regular-expression functions, fuzzy string matching, and graph queries. It also includes using GitHub Copilot and Model Context Protocol (MCP) servers with your database work.
Secure, optimize, and deploy database solutions
Encryption, Dynamic Data Masking, Row-Level Security, permissions, auditing, and passwordless access. Performance work with execution plans, Query Store, isolation levels, and blocking. CI/CD with SQL Database Projects, and integration through Data API builder, Azure Monitor, and change-tracking features such as CDC and change event streaming.
Implement AI capabilities in database solutions
External models, embedding design (which columns, what chunk size, how to keep them fresh), full-text, vector, and hybrid search, ANN versus KNN, reciprocal rank fusion, and RAG built with `sp_invoke_external_rest_endpoint`.
Official source
For the vendor’s own page, see the Microsoft Learn DP-800 study guide. It is the final authority if anything here differs. Microsoft notes that the English version of the exam is updated on October 19, 2026, so check which version you are booking.
More guides for DP-800
- DP-800 Study Plan: 4-Week and 8-Week
- DP-800 Sample Questions With Answers
- Is DP-800 Hard? An Honest Difficulty Check
- DP-800 Renewal and Retakes Explained
- Is DP-800 Worth It? An Honest Look
- DP-800 Cheat Sheet: Key Facts to Review
- DP-800 vs DP-700: Which Exam First?
Next step
Read the domains explained page to see where your time should go. When you want to check yourself, our DP-800 practice tests are five original practice sets of 100 questions each, with an explanation for every answer.
Frequently asked questions
Does the SQL AI Developer Associate credential expire?
Microsoft says associate, expert, and specialty certifications expire annually and can be renewed for free with an online, unproctored assessment on Microsoft Learn. Only fundamentals certifications do not expire.
Is DP-800 offered in English only?
No. Microsoft lists 10 languages. Localized versions are updated about eight weeks after the English one.
Do I need to be an AI specialist?
No. You need to understand embeddings, vectors, and models well enough to use them from SQL. You do not need to train models.