Question 290
The Generative AI team observes: An analyst must classify millions of rows overnight inside a governed Databricks SQL pipeline. Which implementation decision is MOST appropriate?
Explanation
Correct Answer
Correct. `ai_query()` invokes an available serving endpoint from SQL; suitability depends on supported runtimes, endpoint and workload. In the given situation — An analyst must classify millions of rows overnight inside a governed Databricks SQL pipeline. — the targeted implement action is: Use `ai_query()` against a supported endpoint in a controlled batch-inference query with result checks. This directly meets the stated workflow constraint instead of addressing an adjacent capability.
Incorrect Answers
Not the strongest implement choice for this specific question. Restrict endpoint CAN QUERY access to approved principals and test permission boundaries. This action primarily relates to Model Serving endpoint permissions and caller identity: Access to a serving endpoint is governed by workspace rights and identity; caller authorization is distinct from data-source permissions. However, the described case — An analyst must classify millions of rows overnight inside a governed Databricks SQL pipeline. — is testing SQL ai_query for governed batch inference. It does not directly establish the implement outcome or constraint that the question requires; it may still be useful in a different stage or incident.
Not the strongest implement choice for this specific question. Use an available Foundation Model API endpoint with compatible authentication, task API and quotas. This action primarily relates to Foundation Model API versus custom serving choices: Databricks Foundation Model APIs offer managed access to supported models; custom serving is suitable for specialized models or control needs. However, the described case — An analyst must classify millions of rows overnight inside a governed Databricks SQL pipeline. — is testing SQL ai_query for governed batch inference. It does not directly establish the implement outcome or constraint that the question requires; it may still be useful in a different stage or incident.
Not the strongest implement choice for this specific question. Combine semantic index search with model/tenant metadata filters and select source chunks for grounding. This action primarily relates to Vector Search retrieval workflow and query integration: Semantic retrieval uses an embedding model to query a compatible index, returns ranked passages and metadata for grounded generation. However, the described case — An analyst must classify millions of rows overnight inside a governed Databricks SQL pipeline. — is testing SQL ai_query for governed batch inference. It does not directly establish the implement outcome or constraint that the question requires; it may still be useful in a different stage or incident.