Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
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.
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.
rbeam
1 month agoapace92
2 months, 3 weeks agoBigDataBB
4 months, 2 weeks agoazure_bimonster
4 months, 3 weeks agoEshkin_Kot
5 months agostopthisnow
5 months, 1 week agoBigDataBB
5 months, 2 weeks agoBigDataBB
4 months, 2 weeks agostopthisnow
6 months agokevinstudyplan
6 months ago