Exam DP-800 Topic 2 Question 38 Discussion

Actual exam question for Microsoft's DP-800 exam
Question #: 38
Topic #: 2
Drag and Drop Question
You have an Azure SQL database named DB1 that contains two tables named knowledge_base and query_cache. knowledge_base contains support articles and embeddings. query_cache contains chat questions, responses, and embeddings. DB1 supports an AI-enabled chat agent.
You need to design a solution that meets the following requirements:
- Serializes the retrieved rows from knowledge_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_invoke_external_rest_endpoint stored procedure.
Which Transact-SQL commands should you use for each requirement? To answer, drag the appropriate commands to the correct requirements. Each command 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.

Suggested Answer:

by Leonard at Jul 04, 2026, 04:48 PM

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

0
0
0
10