Snowflake
COF-R02 · Question #318
A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed. What will occur?
The correct answer is A. No virtual warehouse will be used, data will be read from the result cache. See the full explanation below for the reasoning.
Question
A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed. What will occur?
Options
- ANo virtual warehouse will be used, data will be read from the result cache.
- BNo virtual warehouse will be used, data will be read from the local disk cache.
- CThe default virtual warehouse will be used to read all data.
- DThe virtual warehouse that is defined at the session level will be used to read all data.
How the community answered
(32 responses)- A81% (26)
- B3% (1)
- C3% (1)
- D13% (4)
Community Discussion
No community discussion yet for this question.