Free Microsoft DP-800 Exam Questions

Question 1

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 2

You have a SQL database in Microsoft Fabric that contains the following functions: • A multi-statement table-valued function (TVF) named sales.mstvf_orderStatus() that returns order status information • A scalar user-defined function (UOF) named dbo.ufn_GetlaxMultiplier(^rax/Wt money, gStateCode char (2)) that returns a numeric multiplier used in tax calculations Reporting queries frequently join Sales.«istvf_OrderStatus() to a table named Sales.SalesOrderHeader and return large result sets. A performance review shows that the queries produce inconsistent execution plans. During a code review, a developer discovers that the following Transact-SQL statement produced an error.

A : You can use GETDATE() in dbo.ufn_GetTaxMultiplier to produce nondeterministic results

B : Rewriting Sales.mtfv_OrderStatus() as an inline table TVF will reduce the number of inconsistent execution plans

C : Replacing ufn_GetTaxMultiplier with dbo.ufn_GetTaxMultiplier in the EXEC function statement will resolve the error

Answer: B,C

Question 3

You have a database named db1. The schema is stored in a Git repository as an SDK-style SQL database project The repository Contains the following GitHub Action workflow.For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

A : Unit tests run automatically whenever changes are pushed to main

B : Schema validation occurs during the build step

C : Schema validation occurs during the deploy step

Answer: A,B

Question 4

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 5