A Data Engineer executes a complex query and wants to make use of Snowflake’s query results caching capabilities to reuse the results.
Which conditions must be met? (Choose three.)
A Data Engineer executes a complex query and wants to make use of Snowflake’s query results caching capabilities to reuse the results.
Which conditions must be met? (Choose three.)
To take advantage of Snowflake's query results caching capabilities, the results must be reused within 72 hours. Additionally, the table structure contributing to the query result cannot have changed, and the new query must have the same syntax as the previously executed query. These conditions ensure that the cached results are valid and can be reused efficiently.
These are the right ones. B is wrong because here it is talking about Result cache not Warehouse cache.
micro partitions are immutable?
B is incorrect because of it is not rely on the same warehouse.
B is incorrect, results are available across virtual warehouses so it doesn't matter if you use the same warehouse or a different one
I change my previous answer to D,E,F https://community.snowflake.com/s/article/Caching-in-the-Snowflake-Cloud-Data-Platform
https://community.snowflake.com/s/article/Understanding-Result-Caching
B is correct: This cache is dropped when the warehouse is suspended, which may result in slower initial performance for some queries after the warehouse is resumed. As the resumed warehouse runs and processes more queries, the cache is rebuilt, and queries that are able to take advantage of the cache will experience improved performance.
https://community.snowflake.com/s/article/Caching-in-the-Snowflake-Cloud-Data-Platform Snowflake Cache Layers The diagram below illustrates the levels at which data and results are cached for subsequent use. These are:- Result Cache: Which holds the results of every query executed in the past 24 hours. These are available across virtual warehouses, so 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. Local Disk Cache: Which is used to cache data used by SQL queries. Whenever data is needed for a given query it's retrieved from the Remote Disk storage, and cached in SSD and memory. Remote Disk: Which holds the long term storage. This level is responsible for data resilience, which in the case of Amazon Web Services, means 99.999999999% durability. Even in the event of an entire data centre failure.
I correct my answer in D,E,F
USED_CACHED_RESULT is not the correct parameter. The correct parameter is "USE_CACHED_RESULT ". Snowflake will use the cache by default and does not require parameter