Question 550
An organization running Snowflake reports: A business user asks natural-language questions about revenue and the generated SQL chooses an unrelated numeric column. Which remediation resolves this specific issue most directly?
Explanation
Correct Answer
The root issue is that natural-language analytics needs business-aware semantic definitions and validation. The selected fix targets that condition: Configure a supported semantic model or semantic view and test representative questions. Validate it by checking this outcome: The generated SQL uses the approved revenue definition and returns expected totals.
Incorrect Answers
This action targets cortex invocation privileges, where ordinary table access does not automatically establish authorization for every AI function. In the given incident, the decisive issue is instead that natural-language analytics needs business-aware semantic definitions and validation.
This action targets unstructured document processing, where document content extraction needs a supported unstructured-data processing capability. The corrective response here is “Configure a supported semantic model or semantic view and test representative questions”; this alternative does not provide that response.
This action targets cortex text classification use, where semantic classification requires an appropriate AI capability rather than ordinary numeric aggregation. The stem reports a business user asks natural-language questions about revenue and the generated SQL chooses an unrelated numeric column; this control addresses a different failure condition.