Microsoft · DP-800
RAG in SQL
DP-800 · Lesson 20 of 20 · 2:33:59
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the DP-800 exam (Microsoft Certified: SQL AI Developer Associate). In this lesson: RAG use cases and architecture, retrieval context as JSON, building grounded prompts with JSON_OBJECT and JSON_ARRAY, calling a model with sp_invoke_external_rest_endpoint, and extracting the answer. Includes three original practice questions.
Preview the topics
- A procedure retrieves one order, and the prompt needs a single JSON object, not an array, with nested field names that the team chooses. Which clause fits?
- The assistant sometimes describes product features that are not in the catalog. What should the team change first?
- During peaks, sp_invoke_external_rest_endpoint returns 429 several times an hour. What should the team do?