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.

Options :

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 for the development team to retrieve the live metadata. The solution must meet the development requirements. What should you include in the recommendation?

Options :

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 3

You have a SQL database in Microsoft Fabric that contains a table named dbo.Orders, dbo.Orders has a clustered index, contains three years of data, and is partitioned by a column named OrderDate by month. You need to remove all the rows for the oldest month. The solution must minimize the impact on other queries that access the data in dbo.orders. Solution; Identify the partition scheme (or the oldest month, and then run the following Transact-SQL statement. ALTER TABLE dbo.Orders DROP PARTITION SCHEME (partition_scheme_name); Does this meet the goal?

Options :

A : Yes

B : No

Answer: B

Free DP-800 Mock Exam – Practice Online Confidently

Buying Options: