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.
The results must be reused within 72 hours.
B.
The query must be executed using the same virtual warehouse.
C.
The USED_CACHED_RESULT parameter must be included in the query.
D.
The table structure contributing to the query result cannot have changed.
E.
The new query must have the same syntax as the previously executed query.
F.
The micro-partitions cannot have changed due to changes to other data in the table.
"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 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.
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
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
aba2s
2 months, 3 weeks agorbeam
7 months, 4 weeks agoapace92
9 months, 3 weeks agoBigDataBB
11 months, 1 week agoazure_bimonster
11 months, 2 weeks agoEshkin_Kot
11 months, 3 weeks agostopthisnow
1 year agoBigDataBB
1 year agoBigDataBB
11 months, 1 week agostopthisnow
1 year agokevinstudyplan
1 year ago