Exam SnowPro Core topic 1 question 172 discussion

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.

result_scan: can return query results of past 24 hours: https://docs.snowflake.com/en/sql-reference/functions/result_scan.html

CE are the right option.

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.

Correct Answer: BE

Correct Answer: BE

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.

B and E are correct

b,E RESULT_SCAN IS DIFFERENT FROM QUERY RESULT CACAHE

"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

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

CE correct answer

https://docs.snowflake.com/en/sql-reference/functions/result_scan

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.