SnowPro Advanced: Architect — Question 5

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

Answer options

• A. Time Travel queries can be executed against the result set cache.
• B. Snowflake persists the data results for 24 hours.
• C. Each time persisted results for a query are used, a 24-hour retention period is reset.
• D. The data stored in the result cache will contribute to storage costs.
• E. The retention period can be reset for a maximum of 31 days.
• F. The result set cache is not shared between warehouses.

Correct answer: B, C, E

Explanation

Option B is correct as Snowflake indeed maintains the results for 24 hours. Option C is also right because using the persisted results resets the retention period. Option E is valid since the retention period can be prolonged to a maximum of 31 days. Options A, D, and F are inaccurate; Time Travel does not apply to result set caches, the cache does not incur additional storage costs, and the cache is shared between warehouses.