Snowflake SnowPro Core Recertification Exam COF-R02 Question # 42 Topic 5 Discussion

Snowflake SnowPro Core Recertification Exam COF-R02 Question # 42 Topic 5 Discussion

COF-R02 Exam Topic 5 Question 42 Discussion:
Question #: 42
Topic #: 5

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?


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


Get Premium COF-R02 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.