Snowflake

COF-R02 · Question #301

What is cached during a query on a virtual warehouse?

The correct answer is B. Any columns accessed during the query. See the full explanation below for the reasoning.

Question

What is cached during a query on a virtual warehouse?

Options

AAll columns in a micro-partition
BAny columns accessed during the query
CThe columns in the result set of the query
DAll rows accessed during the query

How the community answered

(22 responses)

A
5% (1)
B
77% (17)
C
14% (3)
D
5% (1)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full COF-R02 Practice