Knowledge check

1.

What is the primary advantage of RAG over fine-tuning?

RAG produces faster Large Language Models (LLM) responses than fine-tuned models

RAG uses data retrieved at query time, so responses reflect current information without retraining

RAG requires less storage space than fine-tuned models

2.

Which T-SQL option removes the square brackets from JSON output when retrieving a single row for RAG context?

INCLUDE_NULL_VALUES

ROOT('name')

WITHOUT_ARRAY_WRAPPER

3.

What permission must be granted to a database user before they can call sp_invoke_external_rest_endpoint?

EXECUTE ANY EXTERNAL ENDPOINT

CONTROL SERVER

ALTER ANY DATABASE SCOPED CREDENTIAL

4.

When a query parses an Azure OpenAI chat completion response from sp_invoke_external_rest_endpoint, which JSON path extracts the assistant's message content?

$.response.message.content

$.result.choices[0].message.content

$.result.content

Check your knowledge

Feedback