SnowPro Core Certification — Question 347

Which statement MOST accurately describes clustering in Snowflake?

Answer options

• A. The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.
• B. Clustering is the way data is grouped together and stored within Snowflake micro-partitions.
• C. The clustering key must be included in the COPY command when loading data into Snowflake.
• D. Clustering can be disabled within a Snowflake account.

Correct answer: B

Explanation

Option B is correct because clustering in Snowflake pertains to how data is organized within micro-partitions, which optimizes data retrieval. Option A is incorrect because while the ACCOUNTADMIN has many privileges, they do not need to define clustering for each table. Option C is wrong as the clustering key does not have to be included in the COPY command for loading data. Option D is false since clustering cannot be entirely disabled at the account level.