COF-R02 practice question 16 of 35

A sales table FCT_SALES has 100 million records. The following Query was executed SELECT COUNT (1) FROM FCT__SALES; How did Snowflake fulfill this query?

Full set: 330 questions
Answer options
A: Query against the result set cache
B: Query against a virtual warehouse cache
C: Query against the most-recently created micro-partition
D: Query against the metadata excite Correct answer
Correct Answer:
D. Query against the metadata excite
Explanation

:

Scroll to Top