DP-800 exam topics
The DP-800 exam (Microsoft Certified: SQL AI Developer Associate) covers 3 domains and 22 topics. This page lists all of them with the weight of each domain, so you can see what the exam tests and where most of the marks are.
Domains and weights
Domain 1: Design and develop database solutions · 35–40%
- Design Tables, Data Types and Indexes
Every other skill on this exam (security, performance, AI search) rests on well-typed tables with the right indexes. Questions describe a workload (OLTP lookups, analytics scans or both) and ask for the table and index design that fits.
- Specialized Tables: In-Memory, Temporal, External, Ledger and Graph
SQL platforms offer table types for specific problems. The exam gives you a requirement (history, tamper evidence, extreme throughput, data in a lake, relationships) and expects the matching table type.
- JSON Columns, JSON Indexes and JSON Functions
Modern SQL platforms treat JSON as a first-class citizen: a native json data type, JSON indexes, and a full set of functions to build, query and shred JSON. DP-800 expects you to pick the right function for each task.
- Constraints, Sequences and Partitioning
Constraints keep data correct, sequences generate numbers in a controlled way, and partitioning keeps very large tables manageable.
- Views, Functions, Stored Procedures, Triggers and Error Handling
Programmability objects package logic in the database, close to the data, reusable, and securable with GRANT EXECUTE or GRANT SELECT. DP-800 also expects robust error handling.
- CTEs, Window Functions and Correlated Queries
Advanced T-SQL on DP-800 means reading and writing common table expressions, window functions and correlated subqueries, and knowing which produces the requested result.
- Regular Expressions, Fuzzy String Matching and Graph Queries
Newer SQL platforms add native regular expressions and fuzzy matching, two big helps for cleansing text before it feeds search and AI. Graph tables add pattern matching across relationships.
- Design SQL Solutions with AI-Assisted Tools
DP-800 expects you to use GitHub Copilot and Copilot in Fabric productively and safely: enable them, steer them with instruction files, connect them to databases through the Model Context Protocol (MCP), and understand the security impact.
Domain 2: Secure, optimize, and deploy database solutions · 35–40%
- Data Encryption: Always Encrypted and Column-Level Encryption
Encryption questions turn on one point: who must not be able to read the data. Database administrators? Someone who steals the files? Someone sniffing the network? Each answer points to a different feature.
- Dynamic Data Masking, Row-Level Security and Object-Level Permissions
These three features control what an authenticated user sees: masked values, a subset of rows, or only certain objects. They complement encryption (lesson 2.1).
- Passwordless Access, Auditing and Securing Endpoints
AI-enabled databases talk to applications, AI model endpoints and APIs (REST, GraphQL, MCP). Every one of those connections needs an identity, least privilege, and an audit trail. Passwords and keys in connection strings are the anti-pattern.
- Database Configuration, Isolation Levels and Concurrency
Performance and correctness both depend on how the database is configured and how transactions see each other's changes. Questions ask for the setting that fixes a symptom, such as blocking, inconsistent reads or slow parallel queries.
- Evaluate Query Performance and Resolve Blocking and Deadlocks
You need to know which tool shows what, how to read an execution plan, and how to tell blocking from deadlocks.
- CI/CD with SQL Database Projects
SQL Database Projects turn a database schema into source code: one .sql file per object, built into a .dacpac and deployed by comparing it with the target. DP-800 tests the whole lifecycle, from repository to production.
- Expose Data with Data API Builder (REST and GraphQL)
Data API builder (DAB) turns tables, views and stored procedures into secure REST and GraphQL endpoints, and optionally MCP tools, from a single configuration file, with no API code. It runs as a container or process, and it also powers Fabric's API for GraphQL.
- Azure Monitor and Handling Data Changes
Production SQL solutions need observability (Azure Monitor) and a reliable way to react when data changes, for example to refresh embeddings, sync caches or feed analytics. DP-800 lists five change-handling options. Know when each one fits.
Domain 3: Implement AI capabilities in database solutions · 25–30%
- Evaluate and Manage External Models
The database calls AI models through external model objects: a named, secured definition of where a model endpoint lives, how to authenticate, and what it's for. First you choose a suitable model, then you register it.
- Embeddings: Columns, Chunking, Generation and Maintenance
An embedding is a vector that captures meaning, so similar texts get nearby vectors. Good semantic search depends on what you embed, how you split it, and how you keep it current.
- Choose Full-Text, Semantic Vector or Hybrid Search, and Implement Full-Text Search
"Intelligent search" isn't always vector search. Choose the technique from how users search and what must match.
- Vector Data, Vector Functions, Indexes and ANN vs ENN Search
SQL Server 2025, Azure SQL Database, Azure SQL Managed Instance and SQL database in Fabric store embeddings in a native vector type and search them with exact (ENN, also called kNN) or approximate (ANN) nearest-neighbor search.
- Implement Hybrid Search with Reciprocal Rank Fusion, and Evaluate It
Hybrid search runs a keyword search (full-text) and a semantic search (vector) for the same query, then merges the two ranked lists. Reciprocal rank fusion (RRF) is the standard way to merge them, because it only uses ranks, which avoids comparing incompatible scores.
- Design and Implement Retrieval-Augmented Generation (RAG)
RAG grounds a language model's answer in your data: retrieve relevant rows, pass them to the model as context, and return the answer. In SQL, the whole flow can run in T-SQL with spinvokeexternalrestendpoint.
DP-800 exam facts
| 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 |
Study these topics
- Read the free DP-800 study guide: one lesson per topic above, each with its sources in Microsoft Learn.
- See how to prepare for DP-800 for a study plan ordered by domain weight.
- Test yourself with the free 10-question DP-800 mock test, or the full DP-800 practice exam.
Skillmarked is independent and not affiliated with Microsoft. The topic list follows the public exam outline; check the official exam page for the current version before you book.