Question 430
A supported Azure SQL deployment must invoke an external language model from a controlled stored procedure. The team is considering this step: Configure an approved endpoint and least-privilege procedure call with timeouts. What evidence should they review before proceeding?
Explanation
Correct Answer
Check target SQL service support, endpoint policy, auth, payload and rate limits. Sp_invoke_external_rest_endpoint can call permitted HTTPS endpoints with configured credentials where supported. A test prompt receives a validated response and audit identifies the invocation.
Incorrect Answers
Check SQL product feature, endpoint allowlists, managed credentials and procedure-level grants.
External model prompts need data minimization, authorization, timeouts and observability.
SQL execute grants and endpoint identity must be narrowly scoped and tested with unauthorized principals. The pertinent evidence includes: Check target SQL service support, endpoint policy, auth, payload and rate limits.