DP-800 Microsoft · Database

DP-800 practice test

Developing AI-Enabled Database Solutions. Practice exam aligned to the DP-800 skills measured (October 2026): database objects and advanced T-SQL, AI-assisted development, security, performance, CI/CD with SQL Database Projects, Data API builder, embeddings, vector and hybrid search, and RAG.

  • 6 practice tests + challenge test
  • 350 questions
  • 40 questions, 100 min per test
  • Pass at 70%

Take the free DP-800 diagnostic10 questions, no card needed

Free DP-800 sample questions

3 questions from the free diagnostic, with answers and explanations.

Question 1 · Design and implement database objects

An Email column in a Customers table must never contain the same value twice, but it isn't the primary key. Which constraint should you add?

  1. UNIQUE
  2. CHECK
  3. DEFAULT
  4. FOREIGN KEY
Show answer

Answer: A (UNIQUE)

A UNIQUE constraint enforces distinct values on columns other than the primary key.

Question 2 · Design and implement models and embeddings

Which data type stores embeddings natively in Azure SQL Database?

  1. VECTOR(n), with n dimensions
  2. VARBINARY(MAX) holding floats
  3. NVARCHAR(MAX) holding a JSON array
  4. GEOGRAPHY
Show answer

Answer: A (VECTOR(n), with n dimensions)

The VECTOR type stores embeddings in an optimized binary format and works with functions such as VECTOR_DISTANCE.

Question 3 · Write advanced T-SQL code

Refer to the code. What does column X return?

SELECT CustomerID, OrderDate, Amount,
       SUM(Amount) OVER (PARTITION BY CustomerID ORDER BY OrderDate
                         ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS X
FROM Sales.Orders;
  1. A running total of Amount for each customer, by OrderDate
  2. The total Amount of each customer's orders on every row
  3. A running total of Amount across all customers, by OrderDate
  4. The previous order's Amount for each customer, by OrderDate
Show answer

Answer: A (A running total of Amount for each customer, by OrderDate)

SUM with OVER (PARTITION BY ... ORDER BY ... ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) adds up the rows from the first order to the current one within each customer.

Try the full diagnostic free

What the DP-800 practice covers

Share of practice questions per skill area.

  • Write advanced T-SQL code14%
  • Design and implement intelligent search12%
  • Design and implement database objects10%
  • Implement data security and compliance10%
  • Implement CI/CD by using SQL Database Projects10%
  • Implement programmability objects8%
  • Optimize database performance8%
  • Integrate SQL solutions with Azure services8%
  • Design and implement models and embeddings8%
  • Design and implement SQL solutions by using AI-assisted tools6%
  • Design and implement retrieval-augmented generation (RAG)6%

Question formats

  • Single choice
  • Multiple select
  • Hotspot (drop-down and yes/no)
  • Drag-and-drop select and place
  • Case studies
  • Exhibits (screenshots, diagrams and code)

Career path: Database

Run Azure SQL in production, build AI-enabled SQL databases, or build AI apps on Azure Cosmos DB: security, performance, HA/DR, partitioning, vector search and RAG.

  1. DP-900
  2. DP-300
  3. DP-800
  4. DP-420

Guides

DP-800 practice test FAQ

Is there a free DP-800 practice test?

Yes. Create a free account and take the DP-800 free diagnostic: 10 questions across every skill area of the exam, with a study plan for the topics to work on. You can retake it as often as you like.

How many questions are in each ExamKite DP-800 practice test?

Each full practice test has 40 questions with a 100-minute timer, and you pass at 70%. There are 6 practice tests plus a harder challenge test, with 350 questions in total.

Which question formats does the DP-800 practice include?

Single choice, multiple select, hotspot (drop-down and yes/no), drag-and-drop select and place, case studies and exhibits (screenshots, diagrams and code), the same formats you meet on the real exam.

Are these real DP-800 exam questions?

No. They are original questions written for ExamKite and mapped to the Microsoft skills outline, never copied from the real exam. Using leaked exam questions breaks the certification provider's exam rules and can get your certification revoked.

More answers in the full FAQ.

Ready to practice for DP-800?

Start with the free diagnostic and get a study plan for the topics you miss.

Create a free account