Question 1 (Select TWO)
Select TWO: the immediate change and one ongoing control for this Databricks GenAI case. A legacy SQL Classic warehouse cannot run a new `ai_query()` workload and engineers assume bad model credentials.
Explanation
Correct Answers
Correct (immediate corrective action). Move to a supported SQL warehouse/runtime and verify endpoint region/permission prerequisites. In this scenario, A legacy SQL Classic warehouse cannot run a new `ai_query()` workload and engineers assume bad model credentials. The governing mechanism is: `ai_query()` invokes an available serving endpoint from SQL; suitability depends on supported runtimes, endpoint and workload. One selected option addresses the immediate workflow, while the other guards the same failure mode after deployment. Both satisfy the TWO-part requirement.
Correct (continuing risk control). Use budget limits and retry semantics when applying per-row model calls to large tables. In this scenario, A legacy SQL Classic warehouse cannot run a new `ai_query()` workload and engineers assume bad model credentials. The governing mechanism is: `ai_query()` invokes an available serving endpoint from SQL; suitability depends on supported runtimes, endpoint and workload. One selected option addresses the immediate workflow, while the other guards the same failure mode after deployment. Both satisfy the TWO-part requirement.
Incorrect Answers
Not the strongest safeguard choice for this specific question. Keep long-lived credentials out of clients and distinguish shared app authorization from user impersonation. This action primarily relates to Databricks Apps user-facing agent interface and OAuth identities: Databricks Apps supports authenticated interactive frontends; app credentials and user credentials have different scopes. However, the described case — A legacy SQL Classic warehouse cannot run a new `ai_query()` workload and engineers assume bad model credentials. — is testing SQL ai_query for governed batch inference. It does not directly establish the safeguard outcome or constraint that the question requires; it may still be useful in a different stage or incident.
Not the strongest safeguard choice for this specific question. Pin compatible dependencies and rebuild/evaluate the serving artifact before promoting a new environment. This action primarily relates to Deployed model dependency drift and environment compatibility: Models logged in experiments can fail in serving if Python dependencies or inference signatures differ between build and target. However, the described case — A legacy SQL Classic warehouse cannot run a new `ai_query()` workload and engineers assume bad model credentials. — is testing SQL ai_query for governed batch inference. It does not directly establish the safeguard outcome or constraint that the question requires; it may still be useful in a different stage or incident.