Microsoft DP-800 Online Practice Questions and Exam Preparation

Microsoft DP-800 Online Questions & Answers

• Question 71:

  You need to design a generative Al solution that uses a Microsoft SOL Server 2025 database named DB1 as a data source. The solution must generate responses that meet the following requirements:

  - Ait ' grounded In the latest transactional and reference data stored in D61.

  - Do NOT require retraining or fine-tuning the language model when the data changes.

  - Can include citations or references to the source data used in the response.

  Which scenario is the best use case for implementing a Retrieval Augmented Generation (RAG) pattern?

  More than one answer choice may achieve the goal. Select the BEST answer

  A. summarizing free-form user input text
  B. training a custom language model on historical database data
  C. answering user questions based on company-specific knowledge
  D. generating marketing slogans based on user sentiment analysis
  C. answering user questions based on company-specific knowledge

• Question 72:

  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
  D. a vector index on the Embedding* (vector (1536)) column

• Question 73:

  DRAG DROP

  You have an Azure SQL database named DB1 that contains two tables named knowledgebase and query_cache. knowledge_base contains support articles and embeddings. query_cache contains chat questions, responses, and embeddings DB1 supports an Al-enabled chat agent.

  You need to design a solution that meets the following requirements:

  - Serializes the retrieved rows from knowledee_base.

  - Extracts the answer field from the response.

  - Extracts the embeddings to store in query_cache.

  You will call the external large language model (LLM) by using the sp_irwoke_external_re standpoint stored procedure.

  Which Transact-SGL commands should you use for each requirement?

  To answer, drag the appropriate commands to the correct requirements.

  Each command may be used once, mote 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.

  Select and Place:

  

  

• Question 74:

  You have an Azure SQL database that stores order detail rows. A monthly aggregation query is executed thousands of times each day.

  You need to persist the aggregated results without changing the underlying table structures.

  Which solution should you implement?

  A. Create a view that uses ORDER BY and then create a nonclustered index on the view.
  B. Create a view with GROUP BY, add WITH SCHEMABINDING, include COUNT_BIG(*), and then create a unique clustered index on the view.
  C. Create a temporary table and repopulate it every hour.
  D. Create a standard view without SCHEMABINDING and then create a nonclustered index on the base table only.
  B. Create a view with GROUP BY, add WITH SCHEMABINDING, include COUNT_BIG(*), and then create a unique clustered index on the view.

• Question 75:

  You have an Azure SQL database that contains a table named Sales.Orders with a column named SalesRep.

  You need to restrict each user so that they can see only the rows assigned to that user. The solution must use Row-Level Security.

  What should you create?

  A. A DML trigger that deletes unauthorized result rows
  B. An inline table-valued function created WITH SCHEMABINDING, and a security policy that uses the function as a filter predicate
  C. A scalar function and a check constraint
  D. A stored procedure that all users must call instead of querying the table directly
  B. An inline table-valued function created WITH SCHEMABINDING, and a security policy that uses the function as a filter predicate

• Question 76:

  You have an Azure SQL database that contains a database-level DDL trigger named ddl_BlockChanges.

  You need to prevent ddl_BlockChanges from firing during a deployment window, but the trigger object must remain in the database.

  Which statement should you use?

  A. DROP TRIGGER ddl_BlockChanges ON DATABASE
  B. ALTER TRIGGER ddl_BlockChanges
  C. DISABLE TRIGGER ddl_BlockChanges ON DATABASE
  D. DENY EXECUTE ON ddl_BlockChanges TO public
  C. DISABLE TRIGGER ddl_BlockChanges ON DATABASE

• Question 77:

  HOTSPOT

  You have an Azure subscription. The subscription contains an Azure SQL database named SalesDB and an Azure App Service app named sales-api. sales-api uses virtual network integration to a subnet named vnet-prod/subnet-app and reads from SalesDB.

  You need to configure authentication and network access to meet the following requirements:

  - Ensure that sales-api connects to SalesDB by using passwordless authentication.

  - Ensure that all the database traffic remains within the subscription.

  The solution must minimize administrative effort.

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

  NOTE: Each correct selection is worth one point.

  

  

• Question 78:

  You have a Microsoft SQL Server 2025 instance that contains a database named SalesDB SalesDB supports a Retrieval Augmented Generation (RAG) pattern for internal support tickets. The SQL Server instance runs without any outbound network connectivity.

  You plan to generate embeddings inside the SQL Server instance and store them in a table for vector similarity queries.

  You need to ensure that only a database user account named AlApplicationUser can run embedding generation by using the model.

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

  NOTE: Each correct selection is worth one point.

  A. Grant the control permission on SalesDB to AlApplicationUser.
  B. Create a database audit specification on SalesDB owned by AlApplicationUser.
  C. Grant the execute permission on the external model project to AlApplicationUser.
  D. Create an external model project by using ONNX runtime and local paths.
  E. Create an external model project that points to a Microsoft Foundry REST endpoint.
  C. Grant the execute permission on the external model project to AlApplicationUser.
  D. Create an external model project by using ONNX runtime and local paths.

• Question 79:

  You have an Azure SQL database that stores order data. A reporting query aggregates monthly revenue per customer runs frequently.

  You need to reduce how long it takes to retrieve the calculated values. The solution must NOT alter any underlying table structure.

  What should you do?

  A. Create a view by using ORDER BY without TOP. and then create a unique clustered index on the view.
  B. Create a view without using with SCHEMABHIDING, and then create a nonclustered index on the view.
  C. Create a view by using GROUP BV. and then create a unique clustered index on the view.
  D. Create a view by using WITH SCHEHABINDING, include COUNT_BIG(*). and then create a unique clustered index on the view.
  D. Create a view by using WITH SCHEHABINDING, include COUNT_BIG(*). and then create a unique clustered index on the view.

• Question 80:

  DRAG DROP

  You have an Azure SQL database that contains a table named dbo.Orders. You have an application that calls a stored procedure named dbo.usp_tresteOrder to insert rows into dbo.Orders.

  When an insert fails, the application receives inconsistent error details.

  You need to implement error handling to ensure that any failures inside the procedure abort the transaction and return a consistent error to the caller.

  How should you complete the stored procedure? To answer, drag the appropriate values to the correct targets, tach 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.

  Select and Place: