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

Question

Options

• AWhen another warehouse is used to execute the query
• BWhen another user executes the query
• CWhen the underlying data has changed
• DWhen the warehouse used to execute the query is suspended
• EWhen it has been 24 hours since the last query

• A
  6% (1)
• C
  88% (14)
• D
  6% (1)

Explanation

Snowflake's result set cache stores query results for 24 hours and serves them to any user who runs the same query with the same permissions - without using a virtual warehouse. The cache is invalidated in two key scenarios: (C) when the underlying data has changed - if any of the micro-partitions that contributed to the query result are modified (by DML or data loading), the cached result is immediately invalidated; and (E) after 24 hours since the last time the result was accessed - the cache has a 24-hour rolling TTL that resets each time the cached result is used. Option A is wrong: the result cache is shared across all warehouses. Option B is wrong: the cache is shared across all users who have the same access privileges. Option D is wrong: suspending a warehouse does not affect the result cache, which is managed separately by Snowflake's cloud services layer.

No community discussion yet for this question.