Free Microsoft DP-800 Exam Dumps Questions & Answers

You have an SDK-style SQL database project stored in a Git repository. The project targets an Azure SQL database.
The CI build fails with unresolved reference errors when the project ieferences system objects.
You need to update the SQL database project to ensure that dotnet build validates successfully by including the correct system objects in the database model for Azure SQL Database.
Solution: Add the Microsoft.SqlServer.Dacpacs.Mastet NuGet package to the project.
Does this meet the goal?

• A.  Yes
• B.  No

You have an Azure SQL database that contains a table named stores, stores contains a column named description and a vector column named embedding.
You need to implement a hybrid search query that meets the following requirements:
* Uses full-text search on description for the keyword portion
* Returns the top 20 results based on a combined score that uses a weighted formula of 60% vector distance and 40% full-text rank How should you configure the query components? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

For the vector portion, the correct choice is VECTOR_DISTANCE and order by distance ascending . The requirement is to build a combined weighted formula using the actual vector distance. Microsoft documents that VECTOR_DISTANCE returns the exact distance between two vectors. Since lower distance means greater similarity, ascending distance is the right direction for ranking. VECTOR_SEARCH is for ANN retrieval, but this hotspot specifically asks for a weighted formula based on distance , so VECTOR_DISTANCE is the appropriate operator.
For the keyword portion, the correct choice is CONTAINSTABLE on description and return ranked matches . Microsoft documents that CONTAINSTABLE returns a RANK column from 0 through 1000 , which is exactly what is needed for weighted scoring in a hybrid formula.
For the final ranking expression, the best choice is order by (distance * 0.6) + ((1.0 - RANK/1000.0) * 0.4) .
This works because vector distance is a lower-is-better metric, while full-text RANK is a higher-is-better metric. Dividing RANK by 1000 normalizes it to the documented range, and subtracting from 1.0 converts it into a lower-is-better term so both components can be combined consistently in one ascending score. This final step is a sound inference based on Microsoft's documented distance semantics and full-text rank range.

You have a Microsoft SQL Server 2025 instance that has a managed identity enabled.
You have a database that contains a table named dbo.ManualChunks. dbo.ManualChunks contains product manuals.
A retrieval query already returns the top five matching chunks as nvarchar(max) text.
You need to call an Azure OpenAI REST endpoint for chat completions. The solution must provide the highest level of security.
You write the following Transact-SG1 code.

What should you insert at line 02?

• A. 
• B. 
• C. 
• D. 
• E. 

You have an Azure SQL database named SalesDB on a logical server named sales-sql01.
You have an Azure App Service web app named OrderApi that connects to SalesDB by using SQL authentication.
You enable a user-assigned managed identity named OrderApi-Id for OrderApi.
You need to configure OrderApi to connect to SalesDB by using Microsoft Entra authentication. The managed identity must have read and write permissions to SalesDB.
Which Transact-SQL statements should you run in SalesDB?

• A.  CREATE LOGIN [OrderApi-Id] WITH PASSWORD = ' P@ssw0rd! ' ;
  ALTER SERVER ROLE sysadmin ADD MEMBER [OrderApi-Id];
• B.  CREATE USER [OrderApi-Id] WITH PASSWORD = ' P@ssw0rd! ' ;
  ALTER ROLE db_datareader ADD MEMBER [OrderApi-Id];
  ALTER ROLE db_datawriter ADD MEMBER [OrderApi-Id];
• C.  CREATE USER [OrderApi-Id] FROM EXTERNAL PROVIDER;
  ALTER ROLE db_datareader ADD MEMBER [OrderApi-Id];
  ALTER ROLE db_datawriter ADD MEMBER [OrderApi-Id];
• D.  CREATE LOGIN [OrderApi-Id] FROM EXTERNAL PROVIDER;
  ALTER ROLE db_datareader ADD MEMBER [OrderApi-Id];
  ALTER ROLE db_datawriter ADD MEMBER [OrderApi-Id];

You are developing an Azure SQL database solution from a locally cloned GitHub repository by using Microsoft Visual Studio Code and GitHub Copilot Chat.
You need to ensure that GitHub Copilot Chat can call the hosted GitHub MCP Server tools by using OAuth.
The MCP server configuration must be scoped to the repository.
What should you do in Visual Studio Code?

• A.  Create a personal access token (PAT) that has the repo scope and store the PAT in the .vscode\mcp.json file as the Authorization header.
• B.  Create a personal access token (PAT) that has the repo scope and store the PAT in the .github\mcp.json file as the Authorization header.
• C.  From the Command Palette, enter MCP: add server, select HTTP (HTTP or Server-Sent Events), enter
  [https://api.githubcopilot.com/mcp/](https://api.githubcopilot.com/mcp/), and then save the configuration to the user settings.
• D.  From the Command Palette, enter MCP: add server, select HTTP (HTTP or Server-Sent Events), enter
  [https://api.githubcopilot.com/mcp/](https://api.githubcopilot.com/mcp/), and then save the configuration to the workspace settings.