Question 160
What validation would most convincingly show the correction works? A legacy SQL Classic warehouse cannot run a new `ai_query()` workload and engineers assume bad model credentials.
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 — A legacy SQL Classic warehouse cannot run a new `ai_query()` workload and engineers assume bad model credentials. — the targeted verify action is: Execute a small sample query then validate throughput, cost, failed rows and result parsing. It tests an observable outcome using realistic inputs rather than relying on a working demo alone.
Incorrect Answers
Not the strongest verify choice for this specific question. Load-test representative search traffic and benchmark index freshness versus storage/serving cost. This action primarily relates to Standard versus storage-optimized Vector Search index: Index choice trades capacity, update speed, latency and storage economics; availability and feature support may vary by cloud/region. 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 verify outcome or constraint that the question requires; it may still be useful in a different stage or incident.
Not the strongest verify choice for this specific question. Exercise failed tests and confirm release is blocked, then deploy and verify a passing version. This action primarily relates to CI/CD pipelines for retrieval and agent components: Production promotions should test source index, prompt, model packaging and tool behavior independently before release. 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 verify outcome or constraint that the question requires; it may still be useful in a different stage or incident.
Not the strongest verify choice for this specific question. Load the logged pyfunc model in an isolated environment and test the declared signature on sample requests. This action primarily relates to MLflow pyfunc packaging for pre- and post-processing: A custom MLflow pyfunc model wraps request parsing, retriever/model invocation and output formatting inside a reproducible predict interface. 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 verify outcome or constraint that the question requires; it may still be useful in a different stage or incident.