SnowPro Core Certification — Question 511

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?

Answer options

• 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.

Correct answer: A

Explanation

The correct answer is A because Snowflake utilizes a result cache for queries that have already been executed and whose underlying data hasn't changed. Options B, C, and D are incorrect as they either refer to incorrect caching mechanisms or imply unnecessary resource usage when the result is already cached.