SnowPro Specialty: Gen AI free question 5 / 10 · Domain 2: Snowflake Gen AI Functions
After several revenue questions in a Cortex Analyst chat, an executive asks "What trends do you observe?" and does not get a useful answer. Which explanation matches the documentation?
- Its answers are limited to what SQL can resolve
- The semantic view has no metric named "trends" to query
- The question needs a larger model, picked in the request
- The conversation passed the model's limit on turn count
Show the answer and explanation
Answer: A
Why this is correct
Under "Known limitations in multi-turn conversations", the page says Cortex Analyst is limited to answering questions that can be resolved with SQL. It does not generate insights for broader business-related queries, such as "What trends do you observe?" A question like "How did monthly revenue change in 2024?" can be turned into SQL; an open request for observations cannot.
Why the other options are wrong
"The semantic view has no metric named "trends" to query" … Adding a metric with that name would not change the kind of question. The page describes this as a limit on questions that are not resolved with SQL.
"The question needs a larger model, picked in the request" … The page says Cortex Analyst selects the combination of models at runtime. The limitation it names is the type of question, not the model size.
"The conversation passed the model's limit on turn count" … The page does not give a turn count limit. It uses this example to show a question type, not a conversation length.
Where broader questions go
For questions that need interpretation across results, the page points to Cortex Agents, which it recommends over Cortex Analyst and which can combine Cortex Analyst with other tools.
Go to the SnowPro Specialty: Gen AI practice app (10 free questions; purchase unlocks all questions)