Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 3 of 38
Free Preview · 38 of 126 · questions 1–38 of 126 are free. Sign up free to sync your progress across devices.
Select 3 answers.
This question asks for 3 answers, but our data marks only 1. Compare with the community discussion below for the full answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Not sure about D, as inderlying data must not be changed, while changing table structure is rather metadata change action
"A" is False because Result Cache Layer holds the results of every query executed in the past 24 hours. "B" is False because results of every executed query are available across virtual warehouses "D" is True because query results returned to one user is available to any other user on the system who executes the same query, provided the UNDERLYING DATA HAS NOT CHANGED. "E" is True because query results returned to one user is available to any other user on the system who executes THE SAME QUERY, provided the underlying data has not changed. "F" is True because as a series of additional tests demonstrated inserts, updates and deletes which don't affect the underlying data are ignored, and the result cache is used, provided data in the micro-partitions remains unchanged So, I will select DEF. All these explanations are availables here https://community.snowflake.com/s/article/Caching-in-the-Snowflake-Cloud-Data-Platform
B is incorrect because of it is not rely on the same warehouse.