When is the result set cache no longer available? (Select TWO)
A.
When another warehouse is used to execute the query
B.
When another user executes the query
C.
When the underlying data has changed
D.
When the warehouse used to execute the query is suspended
E.
When it has been 24 hours since the last query
The Answer Is:
C, E
This question includes an explanation.
Explanation:
The result set cache in Snowflake is invalidated and no longer available when the underlying data of the query results has changed, ensuring that queries return the most current data. Additionally, the cache expires after 24 hours to maintain the efficiency and accuracy of data retrieval1.
SnowPro-Core PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 60% Discount on All Products,
Use Coupon: "8w52ceb345"