Question 200
For this Snowflake situation — A company needs semantic search over approved helpdesk documents rather than numeric aggregation over relational tables. — the team adopts: Evaluate Cortex Search with governed indexed text sources for the retrieval use case. Which ongoing practice BEST limits the same problem recurring?
Explanation
Correct Answer
The relevant ongoing safeguard is: Audit index freshness and source access controls before expanding retrieval coverage. It controls the recurring exposure associated with this mechanism: Cortex Search supports retrieval over unstructured or text-rich content distinct from relational metric SQL generation. The original action, evaluate Cortex Search with governed indexed text sources for the retrieval use case., still needs operational checks when the environment or workload changes.
Incorrect Answers
That safeguard is relevant to: Cortex AI functions bring supported model inference into the Snowflake processing environment. The current failure instead follows from: Cortex Search supports retrieval over unstructured or text-rich content distinct from relational metric SQL generation. Its prevention measure is “Audit index freshness and source access controls before expanding retrieval coverage”.
This routine guards against another mechanism: The VPS offering concerns isolation of platform services and environment resources, unlike a warehouse compute size. The recurring exposure in the current case is: Cortex Search supports retrieval over unstructured or text-rich content distinct from relational metric SQL generation. The matching preventive check is “Audit index freshness and source access controls before expanding retrieval coverage”.
The suggested review tracks a different technical risk: IDE tooling can make Snowflake development available within familiar local editing workflows. Here the sustained control must address: Cortex Search supports retrieval over unstructured or text-rich content distinct from relational metric SQL generation. Choose “Audit index freshness and source access controls before expanding retrieval coverage”.