SnowPro Core Certification — Question 230

When is the result set cache no longer available? (Choose two.)

Answer options

• A. When another warehouse is used to execute the query
• B. When another user executes the query
• C. When the underlying data has changed
• D. When the warehouse used to execute the query is suspended
• E. When it has been 24 hours since the last query

Correct answer: C

Explanation

The result set cache is no longer available when the underlying data has changed because the cached results may no longer be accurate. The other options do not invalidate the cache; using a different warehouse or user, pausing the warehouse, or the time elapsed since the last query does not affect the cached results as long as the data remains unchanged.