COF-C02 Question 313

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• 2

  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.

• 1

  D.Query against the metadata cache

• Chose D1

  D is correct