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?

Question

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.

• A
  88% (35)
• B
  3% (1)
• C
  8% (3)
• D
  3% (1)

Explanation

Snowflake maintains a result cache that stores the results of every executed query for 24 hours. If the exact same query is re-executed within that 24-hour window and the underlying data has not changed, Snowflake returns the cached result directly-no virtual warehouse compute is consumed and no data is scanned from storage. Since the second user ran the same query only 4 hours later and the data had not changed, Snowflake serves the result from the result cache without starting or using any virtual warehouse.

No community discussion yet for this question.