Snowflake
COF-R02 · Question #161
When is the result set cache no longer available? (Select TWO)
The correct answer is C. When the underlying data has changed E. When it has been 24 hours since the last query. See the full explanation below for the reasoning.
Question
When is the result set cache no longer available? (Select TWO)
Options
- AWhen another warehouse is used to execute the query
- BWhen another user executes the query
- CWhen the underlying data has changed
- DWhen the warehouse used to execute the query is suspended
- EWhen it has been 24 hours since the last query
How the community answered
(54 responses)- A9% (5)
- B2% (1)
- C85% (46)
- D4% (2)
Community Discussion
No community discussion yet for this question.