Question 270
At fictional Copperfield Research Partners, a Snowflake data and AI engineering team is conducting a restricted enterprise language-model deployment with regional service policies and accountable stakeholders. The separately composed technical incident is: A user asks for regional revenue, but the semantic view has two similarly named geographic dimensions and the assistant silently chooses one without clarifying the business meaning. Assume only these documented facts and use safe, authorized production-change procedures; exact current Snowflake feature syntax and region or account availability require current review. Which repeatable assurance or control is most relevant to preventing this situation?
Explanation
Writer-proposed answer: B (UNVERIFIED)
Preliminary individual option explanations — NOT expert validated
Correct Answer
Maintain business-owned semantic definitions, ambiguity examples and release tests for renamed or newly introduced dimensions. A text-to-SQL interface needs explicit semantic mappings and ambiguity handling to produce reproducible aggregate answers.
Incorrect Answers
This response concerns RAG chunk boundaries break policy answers, which is different from the stated failure. A user asks for regional revenue, but the semantic view has two similarly named geographic dimensions and the assistant silently chooses one without clarifying the business meaning.
Ambiguous product review classification is not the cause of the reported failure: A user asks for regional revenue, but the semantic view has two similarly named geographic dimensions and the assistant silently chooses one without clarifying the business meaning.
Similarity threshold excludes rare queries alone does not establish the needed evidence: Tests with ambiguous and explicit regional language show consistent dimension choice or a clear clarification request, never unexplained switching.