Answer-first summary for fast verification
Answer: No virtual warehouse will be used, data will be read from the result cache.
The correct answer is A because Snowflake's result cache stores query results for 24 hours when the underlying data hasn't changed. When a second user executes the identical query within this timeframe, Snowflake retrieves the results directly from the result cache without using a virtual warehouse, providing immediate results with no compute costs. This is a key Snowflake optimization feature. Option B is incorrect because local disk cache is per virtual warehouse and user-specific, not shared across users. Options C and D are incorrect because no virtual warehouse is needed when results are served from the result cache, regardless of default or session-level warehouse settings.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A user executes a query in Snowflake and receives a result. A second user executes the identical query four hours later, but the underlying data has not been modified.
What is the expected outcome?
A
No virtual warehouse will be used, data will be read from the result cache.
B
No virtual warehouse will be used, data will be read from the local disk cache.
C
The default virtual warehouse will be used to read all data.
D
The virtual warehouse that is defined at the session level will be used to read all data.
No comments yet.