Microsoft DP-800: Developing AI-Enabled Database Solutions

Last checked October 22, 2026 against the official Microsoft exam page.

1. Question 1Secure, optimize, and deploy database solutions

   A column holds national identification numbers that must stay encrypted in the database, even from administrators, and the application needs equality searches on them. Which feature fits best?

   1. ATransparent Data Encryption of data files
   2. BDynamic Data Masking on result columns
   3. CKeeping the numbers as plain text in a view
   4. DAlways Encrypted with deterministic encryption
   Show answer and explanationHide answer

   Correct answer: D

   Always Encrypted keeps data encrypted from the client to storage, and deterministic encryption allows equality comparisons. Dynamic Data Masking only obscures output, TDE protects files, and plain text with a view exposes the data.

2. Question 2Design and develop database solutions

   A table stores orders, and queries mostly aggregate a few columns across millions of rows. Which index type best fits this workload?

   1. AA unique index on the order ID only
   2. BNo index, relying on table scans
   3. CA clustered columnstore index
   4. DA nonclustered index on every column
   Show answer and explanationHide answer

   Correct answer: C

   Columnstore indexes store data by column and compress it well, which speeds analytical aggregations over large tables. Per-column nonclustered indexes and unique IDs do not serve large aggregations, and scans without indexes are slow.

3. Question 3Implement AI capabilities in database solutions

   A product description column changes often, and the application needs its embeddings kept current automatically. Which approach is most appropriate?

   1. AA trigger or change-tracking process that regenerates the embedding when the source text changes
   2. BStore the description as a scanned image instead of plain text, which keeps formatting
   3. CCompute embeddings in the client on every query, with no vectors saved in the table
   4. DGenerate embeddings once at load and leave stored vectors unchanged after edits
   Show answer and explanationHide answer

   Correct answer: A

   Triggering regeneration when text changes keeps the stored vectors aligned with the source. One-time generation leaves stale vectors, per-query computation adds latency, and images lose the text meaning.

4. Question 4Secure, optimize, and deploy database solutions

   Support staff must see only the last four digits of a credit card number, while the full value stays stored. Which feature should be used?

   1. ARow-Level Security on the card table
   2. BAlways Encrypted with randomized encryption
   3. CA CHECK constraint on the card number
   4. DDynamic Data Masking
   Show answer and explanationHide answer

   Correct answer: D

   Dynamic Data Masking obscures returned values for users without the unmask permission while leaving the stored data unchanged. Encryption, CHECK constraints, and row filtering solve different problems.

5. Question 5Design and develop database solutions

   A table must keep a full history of every change to each row, with the ability to query the state at a past time. Which table type should be used?

   1. AA table variable
   2. BSystem-versioned temporal table
   3. CA heap with no history
   4. DA view over the current table
   Show answer and explanationHide answer

   Correct answer: B

   System-versioned temporal tables keep history automatically in a history table and support point-in-time queries with FOR SYSTEM_TIME. A heap, a plain view, or a table variable does not preserve the history automatically.