Azure Mastery Download
Azure Mastery

Microsoft Certification DP-800

Predict your score. Pass with proof.

On-device AI scores your readiness, builds an adaptive study plan, and flags topics fading from memory — before they cost you the exam.

364 practice questions AI score prediction 100% offline
Download free iPhone & iPad · Free to start

DP-800 Study App for iOS — Microsoft SQL AI Developer

Get exam-ready for DP-800 (Microsoft Certified: SQL AI Developer Associate) on iPhone or iPad. Azure Mastery uses on-device AI to predict your readiness score across all three DP-800 domains — Design & develop, Secure & optimize & deploy, and AI capabilities in SQL — builds a personalised study plan from your weak spots, and surfaces topics you're forgetting. All without sending a single byte off your device.

The exam

What is the DP-800 exam?

DP-800 is the exam that earns the Microsoft Certified: SQL AI Developer Associate credential (exam title: "Developing AI-Enabled Database Solutions") — the credential Microsoft introduced for the role hiring managers now post as "SQL AI Developer", "Database Developer (AI)", or "Fabric Data & AI Developer". It's the natural next step after DP-900 for SQL developers whose day job has expanded from classical schema work into shipping embeddings, vector search, and retrieval-augmented generation (RAG) directly inside SQL Server, Azure SQL, and SQL databases in Microsoft Fabric. DP-800 is the only Microsoft Associate cert dedicated to AI-enabled data-tier development.

DP-800 is code-first and developer-focused. It validates that you can design tables and indexes (including column store, in-memory, temporal, ledger, external, and graph) and choose the right constraints, sequences, and partitioning; write advanced T-SQL — CTEs, window functions, JSON shaping (JSON_OBJECT/OPENJSON/JSON_MODIFY), regex (REGEXP_LIKE/REPLACE/SUBSTR/INSTR), fuzzy matching (EDIT_DISTANCE, JARO_WINKLER_DISTANCE), graph MATCH queries, error handling; secure data with Always Encrypted, Dynamic Data Masking, Row-Level Security, Managed Identity passwordless access; tune workloads via Query Store and DMVs; deploy with SQL Database Projects and Data API Builder; and bring AI into SQL itself — generating embeddings, building vector indexes, designing RAG flows with sp_invoke_external_rest_endpoint, structuring outputs with JSON. Expect scenario questions that show a snippet of T-SQL or a chunking strategy and ask what's wrong, what's better, or what's required.

Microsoft published the DP-800 skills outline on 12 March 2026. Every question in Azure Mastery's DP-800 bank is mapped to the current outline — no questions on retired services or pre-AI SQL-only patterns. Read the official outline at learn.microsoft.com.

Skills measured · March 2026

DP-800 exam objectives

Three domains, with weights set by Microsoft's 12 March 2026 outline. Every domain summary below is paraphrased from the official skills outline; bullet-level objectives in Azure Mastery are tagged so you always know which domain you're being tested on and where your weak spots cluster.

Design and develop database solutions35–40%

The schema and code foundation. Tables and indexes — data types, sizing, column store, in-memory (memory-optimized), temporal, ledger, external (PolyBase / Azure SQL external), and graph (node/edge). JSON columns and indexes, computed JSON columns. Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, DEFAULT), SEQUENCES, partitioning. Programmability — views (regular and indexed), scalar and table-valued functions, stored procedures, triggers (INSTEAD OF vs AFTER, DML vs DDL). Advanced T-SQL — CTEs (recursive and non-recursive), window functions, JSON_OBJECT/OPENJSON/JSON_MODIFY, regex (REGEXP_LIKE/REPLACE/SUBSTR/INSTR), fuzzy matching (EDIT_DISTANCE, JARO_WINKLER_DISTANCE), graph MATCH queries, correlated queries, TRY/CATCH error handling. AI-assisted development — GitHub Copilot, Microsoft Copilot in Fabric, Model Context Protocol (MCP) tool configuration, Copilot instruction files, and the security impact of each. Around 14–20 questions per sitting.

Secure, optimize, and deploy database solutions35–40%

The production-readiness surface. Security — Always Encrypted with secure enclaves, column-level encryption, Dynamic Data Masking, Row-Level Security (RLS), object-level permissions, auditing, passwordless access via Managed Identity, key management with Azure Key Vault. Performance — DMVs, Query Store, Query Performance Insight, execution-plan analysis, isolation-level trade-offs for the workload. Deployment — SQL Database Projects for CI/CD on GitHub, schema-drift detection, secrets management, branching policies, reference/static data in source control. Integration — Data API Builder (DAB) REST/GraphQL endpoints, Application Insights, Log Analytics, change tracking, change data capture (CDC), change event streaming (CES), Azure Functions / Logic Apps. Around 14–20 questions.

Implement AI capabilities in database solutions25–30%

The AI-in-the-data-tier story. Register external AI models from SQL. Generate and maintain embeddings; design chunking strategies that preserve semantic boundaries. Build vector indexes for nearest-neighbour search, choose between full-text, semantic-vector, and hybrid search (including reciprocal rank fusion) for the workload. Build retrieval-augmented generation (RAG) flows using sp_invoke_external_rest_endpoint — JSON shaping for language-model input, structured-output parsing on the way back. Decide where the AI primitive belongs (SQL vs Azure AI Search vs application layer) given latency, governance, and cost. Around 10–18 questions.

Designed for DP-800

How Azure Mastery helps you pass DP-800

Azure Mastery ships with 364 DP-800 practice questions, every one written specifically against the current (March 2026) skills outline — not generic database trivia. Each question carries a domain tag mapped to the official three domains (Design & develop, Secure & optimize & deploy, AI capabilities in SQL), so you always know which area you're being tested on and where your weak spots are clustered. T-SQL snippets — CTEs, window functions, JSON shaping, regex, fuzzy matching, graph MATCH queries, vector index DDL, RAG flow stubs — appear throughout, matching the format of the live exam.

The on-device Exam IQ engine predicts your DP-800 score before you sit the exam. After roughly 30 questions it has enough signal to give a confidence-scored prediction (e.g. "786 ±37, 68% confidence") — and tells you the specific topics that are dragging your readiness down. No vague "study more" advice; just a ranked list of objectives where improvement would move your score the furthest.

The adaptive study plan rebuilds itself from your answer history. Get an Always Encrypted vs Dynamic Data Masking scenario wrong? You'll see another data-protection-choice question in the next session. Master "full-text vs vector vs hybrid search with reciprocal rank fusion" three sessions running and the engine backs off, surfacing fresh JSON_MODIFY or SQL Database Projects scenarios. The plan optimises for the gap between where you are and the 700 pass score, not for blind volume.

Knowledge decay tracking matters for DP-800 because the AI domain (25–30%) moves quickly — vector index types, embedding model trade-offs, and RAG patterns evolve faster than classical T-SQL knowledge. Azure Mastery tracks every topic's decay curve and flags topics approaching expiry. The padlock icon on the Today screen is your "revisit before you forget" cue, and weak-spot drills automatically pull from decayed topics first.

Real exam simulation mode runs at DP-800's actual length and time pressure: a randomised 40–60-question set drawn from the full 312-question bank, weighted by domain percentages from the March 2026 outline, with the 100-minute timer running and no jumping back to flag-and-review. It's the closest you can get to the live Pearson VUE / online-proctored experience without sitting the exam.

Everything runs on-device. Your answer history, your readiness gauge, your decay alerts — none of it leaves your iPhone or iPad. No account required to start, no tracking, no sync server. Privacy-first by design.

6-week study plan

Suggested DP-800 study plan

Most candidates pass DP-800 after six to ten weeks of focused study, depending on prior T-SQL fluency and exposure to embeddings / vector search. The six-week plan below maps onto the three DP-800 domains (the first two weight 35–40% each), Azure Mastery's adaptive sessions, and the in-app exam simulator. Adjust pace to taste — the readiness gauge tells you when you're done, not the calendar.

  1. Design and develop database solutions

    • Days 1–3: Tables and indexes — data types, sizing, column store, in-memory (memory-optimized), temporal, ledger, external (PolyBase / Azure SQL external), and graph (node/edge). JSON columns and indexes, ISJSON, JSON_PATH_EXISTS, computed JSON columns.
    • Days 4–6: Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, DEFAULT), SEQUENCES, partitioning (partition functions, schemes, sliding window). Programmability — views (regular and indexed), scalar / table-valued functions, stored procedures (parameter sniffing, recompilation), triggers (INSTEAD OF vs AFTER).
    • Days 7–10: Advanced T-SQL — CTEs (recursive and non-recursive), window functions (ROW_NUMBER, RANK, LAG/LEAD, SUM OVER, frame specifications), JSON_OBJECT/JSON_ARRAY/OPENJSON/JSON_MODIFY shaping.
    • Days 11–14: Regex functions (REGEXP_LIKE/REPLACE/SUBSTR/INSTR/COUNT/MATCHES), fuzzy matching (EDIT_DISTANCE, JARO_WINKLER_DISTANCE), graph MATCH queries, correlated queries, TRY/CATCH/THROW/RAISERROR. AI-assisted development — GitHub Copilot, Microsoft Copilot in Fabric, MCP tool configuration, Copilot instruction files, and the security impact of each.

  2. Secure, optimize, and deploy database solutions

    • Days 15–17: Security at rest and in motion — Always Encrypted (column-level, with and without secure enclaves), Dynamic Data Masking, Row-Level Security (RLS), object-level permissions, auditing.
    • Days 18–20: Passwordless access via Managed Identity, key management with Azure Key Vault, authentication patterns for SQL Server / Azure SQL / SQL in Fabric.
    • Days 21–23: Performance — DMVs, Query Store, Query Performance Insight, execution-plan analysis, isolation-level choice for the workload. Diagnose plan regressions and blocking.
    • Days 24–28: Deployment with SQL Database Projects for CI/CD on GitHub — branching, schema drift, secrets management, reference/static data in source control. Integration — Data API Builder (DAB) REST/GraphQL endpoints, Application Insights, Log Analytics, change tracking, CDC, change event streaming (CES), Azure Functions and Logic Apps.

  3. AI capabilities in SQL, sharpen, simulate

    • Days 29–32: Register external AI models from SQL. Generate and maintain embeddings. Design chunking strategies that preserve semantic boundaries (and don't.) Build vector indexes for nearest-neighbour search.
    • Days 33–36: Choose between full-text, semantic-vector, and hybrid search — including reciprocal rank fusion. Build RAG flows with sp_invoke_external_rest_endpoint, JSON shaping for language-model input, structured-output parsing on the return.
    • Days 37–40: Run Focus Weak Spots every morning. The two heaviest domains (Design & develop, Secure & optimize & deploy) weight 35–40% each — give them roughly equal time; do not let the smaller AI domain crowd them out.
    • Days 41–42: Two end-to-end Exam Simulator runs at full 100-minute length. Review carefully. If readiness gauge is 750+ with reasonable confidence, schedule the exam.

Inside the app

Every Microsoft question type, on iPhone

DP-800's question bank uses the same formats Microsoft puts on the live exam — not just multiple choice. Each visualisation below is a faithful mock of how the type renders inside Azure Mastery on iPhone and iPad. Exam-simulator mode runs all of them at full 100-minute length with no flag-and-review jumps, mirroring Pearson VUE.

Multiple choice

One correct answer from four to six options. The most common type on every Azure exam — practical recall of services, settings, and limits.

~50% of questions

Multi-select

Pick two or more correct answers from a list. Microsoft tells you exactly how many to choose. Partial credit not awarded — you need every selection right.

All-or-nothing

Drag-and-drop

Arrange items into the correct sequence — deployment steps, the order operations occur in a pipeline, troubleshooting flows. Long-press to drag on touch.

Order matters

Hotspot

Tap the correct area of an image — the right setting in a portal screenshot, the right resource in a topology diagram. Practical visual recall under time pressure.

Tap target

Case studies

A multi-paragraph scenario followed by 4–6 linked questions. Common on DP-800 — especially when a RAG architecture needs vector index design, embedding-model choice, and security all in one stack.

Multi-question

Why Wrong AI

An Azure Mastery exclusive. When you answer incorrectly, an on-device Apple Foundation Model writes a targeted explanation grounded in the correct rationale. Never leaves your device.

App exclusive

Frequently asked

DP-800 FAQs

How much does the DP-800 exam cost?

The DP-800 voucher is USD $165 in the United States. Pricing varies by region — in the UK it's typically around £128. Microsoft sometimes runs free-voucher promotions during events such as Microsoft Build or Microsoft Ignite, so check your Microsoft Learn profile for any active offers before booking. DP-800 is an Associate-tier credential and requires annual renewal (free, online), so factor that into long-term cost planning.

Does the DP-800 certification expire?

Yes. Microsoft Associate certifications including DP-800 expire annually. Renewal is free — a short online assessment on Microsoft Learn within the six-month window before your expiration date. The renewal targets recent skills outline updates, so staying current is straightforward if you remain broadly active building on SQL Server, Azure SQL, and SQL in Microsoft Fabric. (Fundamentals certifications such as DP-900 are different — those don't expire.)

What is the DP-800 retake policy if I fail?

The first retake is allowed after 24 hours. Second and third retakes each require a 14-day wait. Microsoft caps retakes at five attempts per 12-month rolling period. Each attempt requires a new voucher purchase. DP-800 retake failures usually come from underestimating the AI domain — most candidates over-study T-SQL and JSON shaping and under-study embeddings, vector indexes, and RAG flow design.

How long should I study for DP-800?

Most candidates pass DP-800 after six to ten weeks of focused study, assuming working T-SQL fluency and basic awareness of embeddings and vector search. If T-SQL is new to you, plan for three months — the exam expects you to write CTEs, window functions, JSON shaping queries, and regex/fuzzy-match patterns from memory, not just describe what they do. Azure Mastery's readiness gauge tells you when you're at exam-ready; don't book until it shows roughly 750 or higher with reasonable confidence.

DP-800 vs DP-300 — which should I take?

Different jobs. DP-300 (Microsoft Azure Database Administrator Associate) is for DBAs — running, securing, tuning, and recovering Azure SQL workloads (Azure SQL Database, Managed Instance, SQL on VM) including HA/DR, performance tuning, and automation. DP-800 is for SQL developers bringing AI primitives — embeddings, vector search, RAG, MCP endpoints — directly into the data tier through T-SQL. DP-300 administers; DP-800 develops. Many SQL pros take both because AI-enabled apps need both DBA discipline and developer fluency.

DP-800 vs AI-102 — what's the difference?

Different stacks. AI-102 (Azure AI Engineer Associate) is for application developers building solutions on Azure OpenAI Service, Azure AI Search, and the broader Azure AI services stack — Python/.NET code, model deployments, prompt engineering, AI Search indexing. DP-800 is for SQL developers bringing those same AI primitives — embeddings, vector indexes, RAG, structured outputs — directly into SQL Server, Azure SQL, and Microsoft Fabric using T-SQL. AI-102 is application-layer; DP-800 is data-layer. They complement each other on RAG architectures.

Where DP-800 fits

Certification paths that include DP-800

DP-800 is the SQL AI Developer Associate cert — the developer counterpart to DP-300's DBA track. It pairs with DP-900 as the recommended fundamentals, and bridges into application-layer AI work via AI-102. Tap any linked exam below to see its dedicated study app page.

Ready to pass DP-800?

Download Azure Mastery free. 364 DP-800 practice questions across all three domains, AI score prediction, full-length exam simulator, adaptive study plan. iPhone & iPad.

Download Azure Mastery — free iPhone & iPad · Free to start · No account required