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

Questions 21–25

1. 21foundation · easy

   In Azure SQL Database, which stored procedure is used to call an external REST endpoint, such as an Azure OpenAI service, to generate a prompt response?

   • Asp_send_dbmail
   • Bsp_configure
   • Csp_invoke_external_rest_endpoint
   • Dsp_execute_external_script
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   You have a stored procedure that calls an Azure OpenAI model and receives a JSON response. The response contains a 'choices' array, and each choice has a 'message' object with a 'content' field. You need to store the content of the first choice in a variable. Which T-SQL statement should you use?

   • ASET @content = OPENJSON(@response, '$.choices[0].message.content');
   • BSET @content = @response.choices[0].message.content;
   • CSET @content = JSON_VALUE(@response, '$.choices[0].message.content');
   • DSET @content = JSON_QUERY(@response, '$.choices[0].message.content');
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   You receive a response from a language model that contains a JSON object with a property 'results' that is an array of objects, each with 'id' and 'summary'. You need to store each summary in a table with columns ID and Summary. What should you do?

   • AUse OPENJSON with the path '$.results' and insert the rows into the table.
   • BUse JSON_QUERY to extract the array and then manually split it.
   • CUse JSON_VALUE to extract the entire array and insert it as a single row.
   • DUse STRING_AGG to combine the summaries and insert them as one row.
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   You use sp_invoke_external_rest_endpoint to send a prompt to a language model. The response is returned as a JSON document. You need to store only the generated text in a column of type NVARCHAR(MAX). What should you do?

   • AUse the STRING_AGG function to concatenate the response fields.
   • BUse OPENJSON to parse the response and return the text as a row.
   • CCast the entire response to NVARCHAR(MAX) and store it.
   • DUse JSON_VALUE on the response to extract the text field and insert it into the column.
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   A database application stores customer support tickets. The team wants to build a feature that generates draft replies to new tickets by retrieving similar past resolutions and passing them to a language model. Which scenario does this best describe?

   • AUsing a language model to generate a summary of a single ticket without referencing other tickets
   • BUsing retrieval-augmented generation to ground the model's response in relevant historical data
   • CUsing a language model to classify tickets into predefined categories without any external data
   • DUsing a full-text search index to find similar tickets and displaying them to the user without a language model
   Reveal Solution Discussion Select an answer first