What are some of the characteristics of result set caches? (Choose three.)
What are some of the characteristics of result set caches? (Choose three.)
Result set caches have several important characteristics. Snowflake persists the data results for 24 hours. Each time persisted results for a query are used, a 24-hour retention period is reset. Additionally, the result set cache is not shared between warehouses. These characteristics ensure efficient query performance and storage management while maintaining data isolation for different warehouses.
B,C,E, validated
Chosen answer BCE is correct
How is F not a correct answer? It is more correct than B, since a result cache be kicked out of memory before 24 hours if there are newer results coming in.
F, E, C, B, A is valid. I have a doubt with A, but the rest is fine. Are these questions well posed? Or does it refer only to the features that are explicitly in the documentation? B, C, E 100%, since it is in the documentation explicitly, but F AND B are fine implicitly.
Answer is B,C,E and is validated
https://docs.snowflake.com/en/user-guide/querying-persisted-results