Which of the following statements describe features of Snowflake data caching? (Choose two.)
Which of the following statements describe features of Snowflake data caching? (Choose two.)
Snowflake's data cache follows a least-recently used (LRU) eviction policy, meaning that when the cache is full, the least-recently used data will be cleared to make room for new data. The RESULT_SCAN table function allows users to access and filter the contents of the query result cache, making it useful for examining and manipulating cached query results.
Option A is incorrect because when a virtual warehouse is suspended, the data cache is not saved on the remote storage layer. The data cache is cleared when a virtual warehouse is suspended and any data that needs to be cached is reloaded from the remote storage layer when the virtual warehouse is resumed. Option C is incorrect because the query result cache is a shared cache and all users can access the data that has been cached. There are no restrictions based on user access. Option D is incorrect because the metadata cache is used by default in queries and there is no need for a user to explicitly set USE_METADATA_CACHE to TRUE. Option B is correct because Snowflake automatically manages its data cache and evicts the least-recently used data when the cache becomes full. Option E is correct because the RESULT_SCAN table function can be used to query and filter the data that has been cached in the query result cache.
Great explaination
result_scan: can return query results of past 24 hours: https://docs.snowflake.com/en/sql-reference/functions/result_scan.html
CE. From SF docs: C: Only the user who ran the original query can use the RESULT_SCAN function to post-process the results of that query. Even another user with ACCOUNTADMIN privilege cannot access the results of another user’s query by calling RESULT_SCAN. E: The query containing the RESULT_SCAN can include clauses, such as filters and ORDER BY clauses, that were not in the original query. This allows you to narrow down or modify the result set. https://docs.snowflake.com/en/sql-reference/functions/result_scan
B and E should be correct one.
Only the user who ran the original query can use the RESULT_SCAN function to post-process the results of that query. Even another user with ACCOUNTADMIN privilege cannot access the results of another user’s query by calling RESULT_SCAN. https://docs.snowflake.com/en/sql-reference/functions/result_scan#usage-notes
Your statement is correct and that is why E is correct. but C is not correct. Query Result cache is different. This cached data is pulled when the same query is ran by any User/Role. but running queries specifically on this Query Result cache is done thru RESULT_SCAN. And this is only by the particular user who ran the initial query. this is because the user is now able to see the data.
https://docs.snowflake.com/en/sql-reference/functions/result_scan
This is not right. The answer is B&E. The reasoning "Only the user who ran the original query can use the RESULT_SCAN function to post-process the results of that query." does not apply to using the cache in general. The role must have the same set of permissions to use the cache.
CE correct answer
"Only the user who ran the original query can use the RESULT_SCAN function to post-process the results of that query. Even another user with ACCOUNTADMIN privilege cannot access the results of another user’s query by calling RESULT_SCAN." - https://docs.snowflake.com/en/sql-reference/functions/result_scan
b,E RESULT_SCAN IS DIFFERENT FROM QUERY RESULT CACAHE
B and E are correct
Snowflake's data cache follows a least-recently used (LRU) eviction policy. When the cache is full, the least-recently used data will be removed to make space for new data. The RESULT_SCAN table function allows users to access and filter the contents of the query result cache. This function is useful for examining and manipulating cached query results.
Correct Answer: BE
Correct Answer: BE
C is NOT correct: any user can retrieve results from the query result cache as long as the query is exactly the same as another user's query, and the underlying data has not changed. https://community.snowflake.com/s/article/Caching-in-the-Snowflake-Cloud-Data-Platform#:~:text=Snowflake%20Cache%20Layers&text=Result%20Cache:%20Which%20holds%20the,underlying%20data%20has%20not%20changed.
CE are the right option.