Test your data engineering knowledge with free Microsoft DP-800 (Developing AI-Enabled Database Solutions) practice questions. Verified by certified experts, this question set covers major DP-800 domains including data storage, data processing, and enterprise analytics scenarios. Each question includes a technical breakdown explaining both correct and incorrect choices, referencing official Microsoft documentation to solidify your understanding of modern data engineering concepts. By analyzing these rationales, you can build the analytical skills necessary to tackle the real exam, manage complex analytics workloads, and pass with confidence.
You need to generate embeddings to resolve the issues identified by the analysts. Which column should you use?
What should you insert at line 02?
A)
B)
C)
D)
E)
B)
C)
D)
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. 
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. 
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. 
HOTSPOT 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. 
HOTSPOT You have an Azure SQL database that has Query Store enabled Query Performance Insight shows that one stored procedure has the longest runtime. The procedure runs the following parameterized query. 
The dbo.orders table has approximately 120 million rows. Customer-id is highly selective, and orderOate is used for range filtering and sorting. Vou have the following indexes: • Clustered index: PK_Orders on (Orderld) • Nonclustered index: lx_0rders_order-Date on (OrderDate) with no included columns An actual execution plan captured from Query Store for slow runs shows the following: • An index seek on ixordersorderDate followed by a Key Lookup (Clustered) on PKOrders for customerid, status, and TotalAnount • A sort operator before top (50), because the results are ordered by orderDate DESC For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. 
DRAG DROP You have a Microsoft SQL Servei 2025 database that contains a table named dbo.Customer- Messages, dbo. Customer-Messages contains two columns named HessagelD (int) and MessageRaw (nvarchar(iux)). MessageRaw can contain a phone number in multiple formats. and some rows do NOT contain a phone number. You need to write a single SELECT query that meets the following requirements: • The query must return Message ID, RawNumber. DigitsOnly, and PhoneStatus. • RawNumber must contain the first substring that matches a phone-number pattern, or NULL if no match exists. • DigitsOnly must remove all non-digit characters from RawNumber. or return NULL. • PhoneStatus must return Valid when a phone number exists in MessageRaw. otherwise return Missing. How should you complete the Transact-SQL query? lo 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. 
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. 
DRAG DROP You have a database named DB1. The schema is stored in a GitHub repository as an SDK style SQL database project. You use a feature branch workflow to deploy changes to DB1 You need to update the local feature branch with the latest changes to main, and then create a pull request to merge the feature branch into main for review. How should you complete the GitHub CLI script? 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. 
DRAG DROP You have an Azure SQL database named SalesDB that contains tables named Sales.Orders and Sales.OrderLines. Both tables contain sales data You have a Retrieval Augmented Generation (RAG) service that queries SalesDB to retrieve order details and passes the results to a large language model (ILM) as JSON text. The following is a sample of the JSON. 
You need to return one 1SON document per order that includes the order header fields and an array of related order lines. The LIM must receive a single JSON array of orders, where each order contains a lines property that is a JSON array of line Items. Which transact-SQL commands should you use to produce the required JSON shape from the relational tables? To answer, drag the appropriate commands to the correct operations. Each command may be used once, more than once, or not at all. Vou may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. 
DRAG DROP You have a SQL database in Microsoft Fabric that contains a table named WebSite. Logs. WebSite.Logs stores application telemetry data. Website.Logs contains a nvarehar(iMx) column named log that stores JSON documents You have a daily report that filters by the $.severity JSON property and returns Logld. LogDateTime, and log. The report frequently causes full table scans. You need to modify Website. Logs to support efficient filtering by $. severity and avoid key lookups for the columns returned by the report. How should you complete the Transact-SQL code to avoid full table scans? 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. 
