DP-800 practice test
Microsoft SQL AI Developer Associate
100 practice questions, spread across the exam's topics the same way Microsoft weights them, each with a full explanation and a link to the official documentation that proves the answer. Written by a Microsoft Certified Trainer who does this work for a living.
No card needed to start, and none to keep going: buying is not open yet.
What is inside
Every area the exam tests
Our questions are spread the same way Microsoft weights the exam, so your practice matches the real thing.
Designing and developing
35 to 40%Tables, data types, indexes and column store, specialised tables including in-memory, temporal, external, ledger and graph, JSON columns and indexes, constraints and sequences, partitioning, views, functions, stored procedures and triggers, and advanced T-SQL: common table expressions, window functions, JSON and regular expression functions, fuzzy string matching, graph queries, correlated queries and error handling, plus the AI-assisted tooling around all of it and what it means for security.
37 questionsSecuring, optimising and deploying
35 to 40%Encryption including Always Encrypted and column-level, dynamic data masking, row-level security, object permissions, passwordless access, auditing, securing model and API endpoints, transaction isolation and concurrency, reading execution plans, dynamic management views and Query Store, resolving blocking and deadlocks, database projects with source control, reference data, drift detection and deployment, and integration through Data API builder, monitoring and change feeds.
36 questionsAI capabilities in the database
25 to 30%Evaluating and creating external models, choosing how embeddings are kept current, deciding which columns to embed and how to chunk them, generating embeddings, choosing between full-text, vector and hybrid search, the vector data type with its indexes and functions, approximate against exact nearest neighbour, reciprocal rank fusion, evaluating search quality, and retrieval augmented generation driven from T-SQL through external endpoint calls.
27 questionsMicrosoft last updated this exam on 19 October 2026. Our questions match that version.
How you will use it
Practise the way that suits you
- Learn as you go. Answer, read why straight away, then move on. No clock, no pressure.
- Or sit it timed. A clock, no answers until the end, and two minutes a question, so you learn to pace yourself.
- Score by topic. See which area let you down instead of one number out of a hundred.
- Go back over it. Read every question again afterwards, right and wrong, with the full explanation.
Is it for you
Who takes DP-800
Developers who write the schema and the queries rather than run the server
Over a third of it is designing objects and writing advanced T-SQL.
Teams putting AI features inside the database
A quarter is vectors, embeddings, hybrid search and retrieval from T-SQL.
Anybody moving a database into source control and a pipeline
Database projects, drift detection and deployment controls are examined directly.
Also worth doing
Other exams in the same area
See the questions before you pay
10 DP-800 questions with full explanations, so you can judge the quality yourself.
Start 10 free questions