Microsoft DP-800 Online Practice Questions and Exam Preparation

Microsoft DP-800 Online Questions & Answers

• Question 81:

  You store article embeddings in a SQL Server 2025 table and need approximate nearest neighbor search for semantic retrieval.

  Which function should you use when a compatible ANN index exists?

  A. VECTOR_DISTANCE
  B. VECTORPROPERTY
  C. VECTOR_SEARCH
  D. VECTOR_NORMALIZE
  C. VECTOR_SEARCH

• Question 82:

  You have a CI/CD pipeline that builds and deploys a SQL database project.

  You need to generate a report that shows whether the production database schema has diverged from the registered baseline since the last registration.

  Which SqlPackage action should you use?

  A. /Action:Publish
  B. /Action:DeployReport
  C. /Action:DriftReport
  D. /Action:Extract
  C. /Action:DriftReport

• Question 83:

  You have an Azure SQL database that supports the OLTP workload of an order-processing application. During a 10-minute incident window, you run a dynamic management view query and discover the following: Session 72 is sleeping with open_transaction_count = 1.

  Multiple other sessions show blocking_session_id = 72 in sys.dm_exec_requests. sys.dm_exec_input_buffer(72, NULL) returns only BEGIN TRANSACTION UPDATE Sales.Orders.

  Users report that updates to Sales.Orders intermittently time out during the incident window. The timeouts stop only after you manually terminate session 72.

  What is a possible cause of the blocking?

  A. A long-running SELECT statement is blocking writers.
  B. Session 72 caused a deadlock.
  C. An explicit transaction was started but not committed or rolled back.
  D. A lock escalation occurred.
  C. An explicit transaction was started but not committed or rolled back.

• Question 84:

  HOTSPOT

  You have an Azure SQL database that contains a table named knowledgebase, knowledgebase stores human resources (HR) policy documents and contains columns named title, content, category, and embedding.

  You have an application named App1. App1 queries two relational tables named employee_pnofiles and benefits_enrollnent that contain HR data. App1 hosts a chatbot that calls a large language model (LLM) directly.

  Users report that the chatbot answers general HR questions correctly but provides outdated or incorrect answers when policies change.

  The chatbot also fails to answer questions that reference internal policy documents by title or category.

  You need to recommend a Retrieval Augmented Generation (RAG) solution to resolve the chatbot issues.

  What should you recommend? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 85:

  You have an Azure SQL database named AdventureWorksDB that contains a table named dbo.Employee.

  You have a C# Azure Functions app that uses an HTTP-triggered function with an Azure SQL input binding to query dbo.Employee.

  You are adding a second function that will react to row changes in dbo.Employee and write structured logs.

  You need to configure AdventureWorksDB and the app to meet the following requirements:

  - Changes to dbo.Employee must trigger the new function within five seconds.

  - Each invocation must processes no more than 100 changes.

  Which two database configurations should you perform? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Create an AFTER trigger on dbo.Employee for Data Manipulation Language (DML).
  B. SetSql Trigger MaxBatchSize to 100.
  C. Enable change tracking on the dbo. Employee table.
  D. Enable change tracking at the database level.
  E. Set Sql_Trigger_PollingIntervalMs to 5000.
  F. Enable change data capture (CDC) for dbo.Employee table changes
  C. Enable change tracking on the dbo. Employee table.
  E. Set Sql_Trigger_PollingIntervalMs to 5000.

• Question 86:

  You have text embeddings stored in a VECTOR(1536) column.

  You need to choose the distance metric for semantic search over text-derived embeddings while minimizing the effect of vector magnitude differences.

  Which metric should you use?

  A. cosine
  B. euclidean
  C. Manhattan
  D. Hamming
  A. cosine

• Question 87:

  You have a GitHub Actions workflow that builds and deploys an Azure SQL database.

  The schema is stored in a GitHub repository as an SDK-style SQL database project.

  Following a code review, you discover that you need to generate a report that shows whether the production schema has diverged from the model in source control.

  Which action should you add to the pipeline?

  A. SqlPackage.exe /Action:DriftReport
  B. SqlPackage.exe /Action:DeployReport
  C. SqlPackage.exe /Action:Extract
  D. SqlPackage.exe /Action:Script
  A. SqlPackage.exe /Action:DriftReport