Free Microsoft DP-800 Practice Test Questions

Question 1

You need to recommend a solution that will resolve the ingestion pipeline failure issues. Which two actions should you recommend? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A : Enable snapshot isolation on the database.

B : Use a trigger to automatically rewrite malformed JSON.

C : Add foreign key constraints on the table.

D : Create a unique index on a hash of the payload.

E : Add a check constraint that validates the JSON structure.

Answer: D,E

Question 2

You need to recommend a solution that will resolve the ingestion pipeline failure issues. Which two actions should you recommend? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A : Enable snapshot isolation on the database.

B : Use a trigger to automatically rewrite malformed JSON.

C : Add foreign key constraints on the table.

D : Create a unique index on a hash of the payload.

E : Add a check constraint that validates the JSON structure.

Answer: D,E

Question 3

You need to recommend a solution for the development team to retrieve the live metadata. The solution must meet the development requirements. What should you include in the recommendation?

A : Export the database schema as a .dacpac file and load the schema into a GitHub Copilot context window.

B : Add the schema to a GitHub Copilot instruction file.

C : Use an MCP server

D : Include the database project in the code repository.

Answer: C

Question 4

You need to recommend a solution for the development team to retrieve the live metadata. The solution must meet the development requirements. What should you include in the recommendation?

A : Export the database schema as a .dacpac file and load the schema into a GitHub Copilot context window.

B : Add the schema to a GitHub Copilot instruction file.

C : Use an MCP server

D : Include the database project in the code repository.

Answer: C

Question 5

You need to recommend a solution for the development team to retrieve the live metadata. The solution must meet the development requirements. What should you include in the recommendation?

A : Export the database schema as a .dacpac file and load the schema into a GitHub Copilot context window.

B : Add the schema to a GitHub Copilot instruction file.

C : Use an MCP server

D : Include the database project in the code repository.

Answer: C

Free Microsoft DP-800 Exam Practice Questions 2026