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

What are some of the characteristics of result set caches? (Choose three.)
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.

View Answer

Answer: B, C, F

Explanation:

In Snowflake, the characteristics of result set caches include persistence of data results for 24 hours (B), each use of persisted results resets the 24-hour retention period (C), and result set caches are not shared between different warehouses (F). The result set cache is specifically designed to avoid repeated execution of the same query within this timeframe, reducing computational overhead and speeding up query responses. These caches do not contribute to storage costs, and their retention period cannot be extended beyond the default duration nor up to 31 days, as might be misconstrued.

Reference: Snowflake Documentation on Result Set Caching.