Exam SnowPro Core topic 1 question 249 discussion

Actual exam question from Snowflake's SnowPro Core

Question #: 249
Topic #: 1

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 cache

Show Suggested Answer

Suggested Answer: D 🗳️

by SV1122 at Dec. 27, 2022, 5:12 a.m.

Comments

Submit Cancel

kolossal

7 months, 1 week ago

The COUNT(1) function is used to count all rows in the specified table. In Snowflake, using COUNT(1) is equivalent to using COUNT(*), as both provide a count of all rows without filtering based on any specific column. The number 1 is simply a placeholder; it does not affect the result. Snowflake optimizes this operation by using metadata statistics, allowing for quick retrieval of row counts without scanning every row.

upvoted 2 times

...