What is cached during a query on a virtual warehouse?
A.
All columns in a micro-partition
B.
Any columns accessed during the query
C.
The columns in the result set of the query
D.
All rows accessed during the query
The Answer Is:
C
This question includes an explanation.
Explanation:
During a query on a virtual warehouse, the columns in the result set of the query are cached. This allows for faster retrieval of data if the same or a similar query is run again, as the system can retrieve the data from the cache rather than reprocessing the entire query. References: [COF-C02] SnowPro Core Certification Exam Study Guide
COF-C02 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"