What are some of the characteristics of result set caches? (Choose three.)

Question

Options

• ATime Travel queries can be executed against the result set cache.
• BSnowflake persists the data results for 24 hours.
• CEach time persisted results for a query are used, a 24-hour retention period is reset.
• DThe data stored in the result cache will contribute to storage costs.
• EThe retention period can be reset for a maximum of 31 days.
• FThe result set cache is not shared between warehouses.

• A
  4% (2)
• B
  92% (47)
• D
  2% (1)
• E
  2% (1)

Explanation

Snowflake's result set cache has three key characteristics aligned with options B, C, and F. (B) Query results are cached and persisted for 24 hours after they are generated. (C) Each time a cached result is reused, the 24-hour retention clock resets, effectively extending the cache lifetime for frequently repeated queries. (F) The result set cache is not shared across virtual warehouses - each warehouse's cached results are scoped to that warehouse context. Option A is incorrect because Time Travel queries bypass the cache. Option D is incorrect - cached results are stored in Snowflake's cloud services layer at no extra storage cost to the customer. Option E is incorrect - there is no documented 31-day maximum cap on resets.

No community discussion yet for this question.