SnowPro Core Certification — Question 392

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?

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 cache

Correct answer: D

Explanation

The correct answer is D because Snowflake can efficiently return the count of rows by accessing information stored in the metadata cache, which holds the number of rows in each micro-partition. The other options, such as querying result set or virtual warehouse caches, are not applicable for a COUNT operation that needs precise row counts.