SnowPro Core Certification — Question 433

What is cached during a query on a virtual warehouse?

Answer options

• 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

Correct answer: B

Explanation

The correct answer is B because caching is designed to store any columns that are accessed during the query execution, allowing for faster retrieval. Options A and D are incorrect because they refer to all columns or rows rather than just those accessed, while option C incorrectly states that only the result set columns are cached.