What affects whether the query results cache can be used?
A.
If the query contains a deterministic function
B.
If the virtual warehouse has been suspended
C.
If the referenced data in the table has changed
D.
If multiple users are using the same virtual warehouse
The Answer Is:
C
This question includes an explanation.
Explanation:
The query results cache can be used as long as the data in the table has not changed since the last time the query was run. If the underlying data has changed, Snowflake will not use the cached results and will re-execute the query1.
COF-C03 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 65% Discount on All Products,
Use Coupon: "ac4s65"