Answer: When the underlying data has changed, When it has been 24 hours since the last query

The question asks when the result set cache becomes unavailable, requiring selection of two correct options. Based on Snowflake documentation and community consensus, the correct answers are C and E. Option C ('When the underlying data has changed') is correct because Snowflake's result cache is invalidated when the underlying data in the source tables is modified, ensuring query results reflect current data. Option E ('When it has been 24 hours since the last query') is correct because Snowflake automatically expires persisted query results after 24 hours, regardless of other factors. The community discussion strongly supports C and E, with multiple comments (e.g., from Kate0204 with 24 upvotes) and references to Snowflake documentation confirming these points. Other options are incorrect: A and B do not affect cache availability (cache is shared across warehouses and users), and D is incorrect because suspending a warehouse does not invalidate the cache (as noted in Bala1802's comment with 5 upvotes).

Author: LeetQuiz Editorial Team