Microsoft Certified: SQL AI Developer Associate

---

Exam at a Glance

DP-800 measures whether you can do the day-to-day work of a developer building AI-enabled database solutions on Microsoft SQL platforms: designing tables and T-SQL on SQL Server, Azure SQL and SQL database in Fabric, securing, tuning and shipping them through CI/CD, and adding embeddings, vector search and RAG inside the database.

 

What the Exam Covers

The exam has three domains, and the AI domain is the smallest: the two classic database domains together cover most of the exam. Coming for vector search and RAG while skimming the T-SQL, security and CI/CD bullets would leave most of the syllabus uncovered.

 

Design and develop database solutions — 35-40%

Tables, indexes and columnstore; specialized tables (in-memory, temporal, external, ledger, graph); JSON columns and indexes, constraints, sequences and partitioning; views, functions, stored procedures and triggers; advanced T-SQL (CTEs, window functions, JSON, regular-expression and fuzzy-matching functions, graph MATCH queries, correlated queries, error handling); and AI-assisted development with GitHub Copilot and Copilot in Fabric, including MCP tool options, instruction files and MCP server endpoints.

 

Secure, optimize, and deploy database solutions — 35-40%

Security and compliance (Always Encrypted, column-level encryption, Dynamic Data Masking, Row-Level Security, object-level permissions, passwordless access, auditing, securing model, GraphQL, REST and MCP endpoints); performance (configuration, isolation levels, execution plans, DMVs, Query Store, blocking and deadlocks); CI/CD with SQL Database Projects (testing strategy, reference data in source control, SDK-style projects, branching and pull requests, secrets, schema drift, pipeline controls); and Azure integration (Data API builder REST and GraphQL endpoints, Azure Monitor, and change handling with change event streaming, CDC, Change Tracking, Azure Functions or Logic Apps).

 

Implement AI capabilities in database solutions — 25-30%

External models and embeddings (evaluating and managing models, maintenance methods, column choice, chunking); intelligent search (full-text versus vector versus hybrid search, the vector data type and indexes, VECTOR_DISTANCE and VECTOR_SEARCH, approximate versus exact nearest neighbors, reciprocal rank fusion); and RAG (use cases, prompts built with sp_invoke_external_rest_endpoint, converting rows to JSON, sending results to a language model and extracting its responses).

 

The full bullet-level list lives in the official study guide. Treat it as your checklist:

The Official DP-800 Study Guide

 

How This Maps to CertiAce Practice Modules

The CertiAce question bank is organized into three practice modules that map one-to-one to the exam domains, so you can drill each area in isolation:

 

Where DP-800 Fits

DP-800 has no official prerequisites, and passing it is not a prerequisite for any other Microsoft certification. If you are new to SQL, data concepts or cloud platforms, starting with DP-900 is strongly recommended: it builds the vocabulary DP-800 assumes without being required. If you already write T-SQL on SQL Server or Azure SQL and understand embeddings and vectors conceptually, go straight to DP-800.

Microsoft Certified: SQL AI Developer Associate

 

Before You Start

The exam assumes practical database development experience, not just reading. Check yourself against this table. Anything unfamiliar is where your preparation should start:

 

---

Step-by-Step Study Plan

How long you need depends on where you start. Treat these estimates as planning guidance and adjust them to your starting knowledge and weekly study hours:

 

Step 1: Read the Official Study Guide

Skim the full skills-measured list once, and mark every bullet you could not explain to a colleague. That marked-up list is your personal syllabus: everything else in this plan exists to clear it. DP-800 is a young exam: revisit the page before you sit.

The Official Study Guide

 

Step 2: Schedule Your Exam

Choose a realistic target date after reviewing the skills list and your available study time. A date on the calendar turns studying into a countdown, so pick one using the prep-time table above and plan backwards from it. The exam is offered in English only. If the exam is not available in your native language, check the English as a Second Language accommodation and arrange any approved extra time before booking.

Exam accommodations

Certification and Exam Details Page

 

Step 3: Work Through the Official Learning Path

Complete the DP-800 course modules on Microsoft Learn: eleven modules grouped by the three exam domains, each ending in a hands-on exercise. Take notes on concepts you cannot explain in simple terms, and flag anything that needs more practice. You will come back to those in Step 5. Pay special attention to specialized tables, the newer T-SQL functions, SQL Database Projects and vector search.

Official Learning Path Course Page

 

Step 4: Watch a Full Video Course

No single full-length DP-800 video course exists yet (the exam is only months old). The best available substitute is Microsoft Reactor's official "Get Certified: SQL AI Developer (DP-800)" series: six hour-long recorded sessions covering the exam outline, design and development, security and deployment, embeddings, search and RAG, and exam-day preparation. Watch them after the learning path and replay your weakest domain later.

Get Certified: SQL AI Developer (DP-800)

 

Step 5: Get Hands-On Practice

DP-800 is a practical exam: it rewards real experience building, securing and shipping SQL solutions, and tests whether you recognize real implementation patterns and trade-offs. SQL Server 2025 Developer edition, the Azure SQL Database free offer and the Fabric trial support many of the core exercises at no cost. Some AI objectives need other access, such as a model endpoint for the embedding and RAG calls or Copilot licensing, so cover those from the documentation or a demo if you cannot deploy them. The official lab repository is still only a template, so build from the module exercises and make sure you personally touch:

• Tables with JSON columns, a temporal or ledger table, constraints and partitioning
• Window-function, JSON, regular-expression and fuzzy-matching queries
• Row-Level Security, Dynamic Data Masking, Always Encrypted and passwordless Microsoft Entra authentication
• An execution plan and Query Store used to resolve a blocking or deadlock problem
• A SQL database project deployed through GitHub Actions, then exposed through Data API builder
• Embeddings stored in the vector data type, VECTOR_DISTANCE and VECTOR_SEARCH queries, and a model call through sp_invoke_external_rest_endpoint

Deploy Azure SQL Database for free

 

Step 6: Benchmark Your Knowledge

Use CertiAce to benchmark your readiness module by module. The practice modules map to the exam domains as shown above, so use the module mapping and the topics behind your missed questions to identify the skills-measured areas to revisit. Microsoft also offers a free official practice assessment for DP-800 on AI Skills Navigator (sign in to launch it). Aim for consistent performance across every module, not one lucky high score; if a topic is unstable, go back to learning plus hands-on practice.

CertiAce DP-800 Exam Practice

Official Practice Assessment on AI Skills Navigator

 

Step 7: Take the Exam

The day before, review only your weak topics: no brand-new material. On exam day, read each question for what it is truly asking, eliminate wrong options first, and watch for wording that implies constraints such as least privilege, cost, performance, or operational simplicity. Notice which platform the scenario names and whether it wants a T-SQL feature, a security control, a deployment mechanism or an AI function. That alone often eliminates half the options.

Worth knowing before you sit down:

• Microsoft Learn is available during the exam in a split screen. Use it to check details you genuinely need: the timer keeps running, and the exam is deliberately too long to look up every answer. Browsing is limited to Microsoft Learn itself (no Q&A, practice assessments, or profile), and personal notes and other websites are unavailable.
• You can take unscheduled breaks, but the clock keeps running and you cannot return to questions you already saw.
• Case studies lock when you leave them: finish each one before moving on, because you cannot revisit its questions afterwards.
• Labs may appear: DP-800's 120-minute allotment is the one Microsoft uses for role-based exams that may contain labs. The introduction screen tells you whether yours does; if it does, budget extra time for them.
• Try the exam sandbox beforehand so the question formats and interface hold no surprises: Exam Sandbox

 

---

Additional Learning Resources