DP-800

DP-800 AI-Enabled Database Solutions practice exams

240 questions in 5 timed practice tests. Each test has about 50 questions and a 100-minute limit. The pass mark is 70%. Results are split across the 3 exam domains.

Exam at a glance

DP-800 practice exam settings
Practice tests 5
Questions in total 240
Questions per test About 50
Time limit per test 100 minutes
Pass mark 70%
Question types Single answer and multiple answer (18 multiple-answer questions)
Level Associate
Category AI & Machine Learning

These are the settings of our practice tests. Check the official Microsoft exam page for the current exam format before you book.

Domains and weights

DP-800 exam domains, weights and question counts
Domain Weight Weight bar Questions in our bank
Design and develop database solutions 37% 89
Secure, optimize, and deploy database solutions 36% 87
Implement AI capabilities in database solutions 27% 64

Sample questions

Question 1 of 3

An auditing firm requires cryptographic proof that rows in a Transactions table were never modified or deleted after they were inserted. The application only ever inserts rows into this table. Which design meets the requirement with the least overhead?

  1. A A table protected by an INSTEAD OF UPDATE, DELETE trigger that raises an error
  2. B An updatable ledger table with a history table and periodic digest uploads
  3. C An append-only ledger table, with database digests stored in immutable storage (correct answer)
  4. D A system-versioned temporal table with a 10-year history retention period
Why: An append-only ledger table blocks updates and deletes and chains rows into cryptographic hashes, and storing digests in immutable storage lets auditors verify that nothing was altered. An updatable ledger table also gives tamper-evidence but adds a history table that this insert-only workload does not need. A temporal table records history but offers no cryptographic proof against an administrator altering history. A trigger can be disabled or dropped by a privileged user, so it is not tamper-evident.

Question 2 of 3

An insurance company must be able to answer the question "What did this policy row look like on 1 March last year?" for regulatory reviews, without writing any audit triggers. Which feature should the developer implement on the Policies table?

  1. A An updatable ledger table verified with sys.sp_verify_database_ledger
  2. B Change Tracking with CHANGE_RETENTION set to 400 days on the database
  3. C A system-versioned temporal table queried with FOR SYSTEM_TIME AS OF (correct answer)
  4. D Change Data Capture with a cleanup job retaining one year of changes
Why: A system-versioned temporal table keeps every prior row version in a history table automatically, and FOR SYSTEM_TIME AS OF returns the row as it was at any point in time. CDC records changes but answering an as-of question requires reconstructing state from change rows and relies on capture jobs. An updatable ledger table proves tamper-evidence; it is not designed for simple point-in-time queries. Change Tracking records only that a row changed, not its previous values.

Question 3 of 3

An order-entry system on SQL Server 2025 runs heavy OLTP inserts and updates on dbo.Orders. Management now wants live dashboards that aggregate the same table without an ETL delay, and the OLTP workload must keep its existing clustered primary key. What should the developer add?

  1. A A nightly CREATE TABLE AS SELECT copy of Orders into a separate reporting schema
  2. B An indexed view with SCHEMABINDING that pre-aggregates every dashboard metric
  3. C A nonclustered columnstore index on the columns used by the dashboard queries (correct answer)
  4. D A clustered columnstore index that replaces the existing clustered primary key
Why: A nonclustered columnstore index on a rowstore table enables real-time operational analytics: the OLTP path keeps its clustered key while analytic queries use batch-mode columnstore scans. Replacing the clustered key with a clustered columnstore index violates the requirement. An indexed view only serves the exact aggregations it defines and adds maintenance cost to every write. A nightly copy introduces the ETL delay that management wants to avoid.

What your score report looks like

Example attempt, DP-800 practice test 3

82%

Passed
Pass mark 70%

Score by exam domain
DomainWeightYour score%
Design and develop database solutions 37%
88
Secure, optimize, and deploy database solutions 36%
81
Implement AI capabilities in database solutions 27%
76

Study next: Implement AI capabilities in database solutions. It is below the pass mark and carries 27% of the exam.

Domains and pass mark from our DP-800 practice tests. Scores are an example attempt.

Study plans

Two weeks

  1. Day 1: take practice test 1 in exam mode to get a baseline.
  2. Days 2 to 5: domain mode on Design and develop database solutions and Secure, optimize, and deploy database solutions, the two most heavily weighted domains.
  3. Day 6: practice test 2 in exam mode, then the mistakes quiz.
  4. Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
  5. Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.

Four weeks

  1. Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
  2. Week 2: domain mode on those two domains, then a second practice test in exam mode.
  3. Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
  4. Week 4: practice test 5 and final mode until your readiness holds above the pass mark.

Questions about the DP-800 practice exams

Are these real DP-800 exam questions?
No. We write every question ourselves and map it to the published DP-800 exam objectives. We do not use leaked or recalled questions.
Do the time limit and pass mark match the official exam?
They match the settings of our practice tests. Exam providers change their format from time to time, so check the official exam page before you book.
Can I try it before I pay?
Yes. The free mini exam has 15 questions with full explanations and needs no account.
How long do I keep access?
A single-exam purchase gives you 12 months of access. All-Access includes this exam for as long as your subscription runs.
What happens after I finish a test?
You get a score, a pass or fail against the pass mark, a score per domain and every answer with its explanation.

Last updated November 2026. Written and reviewed by the DevOpsCode Lab team.

DevOpsCode Lab is not affiliated with Microsoft. DP-800 and related names are trademarks of their owners.

Related exams
Exam Vendor Level Questions Minutes Price
AB-100AB-100 Agentic AI Business Solutions Architect Microsoft Professional 250 100 $14.99
AB-730AI Business Professional AB-730 Microsoft Professional 250 100 $14.99
AZ-305Azure Solutions Architect AZ-305 Microsoft Professional 250 100 $14.99
SC-100Cybersecurity Architect SC-100 Microsoft Professional 250 120 $14.99
AZ-140Azure Virtual Desktop AZ-140 Microsoft Specialty 251 100 $14.99
DP-420Microsoft DP-420 Microsoft Specialty 250 100 $14.99