When is the result set cache no longer available? (Select TWO)

When is the result set cache no longer available? (Select TWO)
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

View Answer

Answer: C, E

Explanation:

The result set cache in Snowflake is invalidated and no longer available when the underlying data of the query results has changed, ensuring that queries return the most current data. Additionally, the cache expires after 24 hours to maintain the efficiency and accuracy of data retrieval1.