Design and Implement Retrieval-Augmented Generation (RAG) DP-800 Practice Questions (Page 1)

Questions 1–5

1. 1application · medium

   A healthcare organization has a database of clinical trial results. They want to allow researchers to ask natural-language questions and get answers grounded in the latest trial data. The data is updated frequently and must not be used to train the language model. What is the best approach?

   • AExport the entire database to a static file and use it as the model's training corpus.
   • BUse RAG to retrieve relevant trial records and include them in the prompt to the language model.
   • CFine-tune the language model on the trial data so it can answer from memory.
   • DUse a pre-trained model without any additional data and rely on its general knowledge.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   You have a table named Products with columns ProductID, Name, and Price. You want to convert a single row into a JSON object to include in a prompt for a language model. Which Transact-SQL function or clause is designed for this purpose?

   • AOPENJSON
   • BJSON_VALUE
   • CFOR JSON PATH
   • DSTRING_AGG
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   After calling sp_invoke_external_rest_endpoint to send a prompt to a language model, the response is returned as a JSON string. Which Transact-SQL function can you use to extract a specific property, such as the generated text, from that JSON response?

   • AISJSON
   • BJSON_VALUE
   • CSTRING_SPLIT
   • DFOR JSON PATH
   Reveal Solution Discussion Select an answer first
5. 4expert · hard

   You are implementing a T-SQL solution that calls an Azure OpenAI model to classify customer feedback. The model sometimes returns a response that is not valid JSON, causing the JSON parsing to fail. You need to ensure the solution handles this gracefully. What should you do?

   • AUse TRY...CATCH to catch the JSON parsing error and log the failure for manual review.
   • BUse a regular expression to extract the JSON from the response before parsing.
   • CUse a different model that is guaranteed to return valid JSON.
   • DAssume the model always returns valid JSON and do not handle errors.
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   You are writing a T-SQL stored procedure that sends a prompt to an Azure OpenAI model and captures the response. The procedure must be resilient to transient network errors. What should you implement?

   • AUse a WHILE loop that retries the call indefinitely until it succeeds.
   • BUse a cursor to iterate over the response and retry if needed.
   • CWrap the sp_invoke_external_rest_endpoint call in a TRY...CATCH block and retry the call a limited number of times.
   • DUse a transaction to ensure the call is atomic.
   Reveal Solution Discussion Select an answer first