Exit demo DP-800 Developing AI-Enabled Database Solutions PDF format · free preview

Microsoft DP-800 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/dp-800.html

Question 1
Single choice

You need to enable similarity search to provide the analysts with the ability to retrieve the most relevant health summary reports. The solution must minimize latency.

What should you include in the solution?

A.

a computed column that manually compares vector values

B.

a standard nonclustered index on the Fmbeddings (vector (1536)) column

C.

a full-text index on the Fmbeddings (vector (1536)) column

D.

a vector index on the Embedding* (vector (1536)) column

Question 2
Single choice

You need to recommend a solution to lesolve the slow dashboard query issue.

What should you recommend?

A.

Create a clustered index on Lastupdatedutc.

B.

On Fleetid, create a nonclustered index that includes Lastupdatedutc. inginestatus, and BatteryHealth.

C.

On Lastupdatedutc. create a nonclustered index that includes Fleetid.

D.

On Fleetid, create a filtered index where lastupdatedutc > DATEADD(DAV, -7,SYSuTCOATETIME()).

Question 3
Single choice

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.

Question 4
Multiple choice

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.

Question 5
Single choice

You need to generate embeddings to resolve the issues identified by the analysts.

Which column should you use?

A.

vehicleLocation

B.

incidentDescrlption

C.

incidentType

D.

SeverityScore

Question 6
Hotspot

HOTSPOT

You need to meet the development requirements for the FeedbackJson column

How should you complete the Transact SQL query? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question 7
Hotspot

HOTSPOT

You are creating a table that will store customer profiles.

You have the following Transact-SQL code.

For each of the following statements, select Yes if the statement is true.

Otherwise, select No. NOTE: Each correct selection Is worth one point.

Question 8
Hotspot

HOTSPOT

You need to create a table in the database to store the telemetry data.

You have the following Transact-SQL code.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Question 9
Drag & drop

DRAG DROP

You need to meet the database performance requirements for maintenance data.

How should you complete the Transact-SQL code?

To answer, drag the appropriate values to the correct targets.

Each value may be used once, more than once, or not at all.

You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Question 10
Single choice

You have an Azure SQL database that contains the following SQL graph tables:

- A NODE table named dbo.Person.
- An EDGE table named dbo.Knows.

Each row in dbo.Person contains the following columns:

- Personid (int)
- DisplayName (nvarchar(100))

You need to use a HATCH operator and exactly two directed Knows relationships to return the Personid and DisplayName of people that are reachable from the person identified by an input parameter named
@startPersonid.

Which Transact-SQL query should you use?

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Showing 10 of 87 questions · Unlock the full set