Which statement MOST accurately describes clustering in Snowflake?

Question

Options

• AThe database ACCOUNTADMIN must define the clustering methodology for each Snowflake
• BClustering is the way data is grouped together and stored within Snowflake micro-partitions.
• CThe clustering key must be included in the COPY command when loading data into Snowflake.
• DClustering can be disabled within a Snowflake account.

• A
  8% (4)
• B
  86% (43)
• C
  2% (1)
• D
  4% (2)

Explanation

Clustering in Snowflake describes how data is physically organized within its micro-partition storage layer. By default, data is clustered in insertion order. Clustering keys can optionally be defined to colocate related data in the same or adjacent micro-partitions, improving query pruning. Option A is incorrect because defining clustering methodology is not an ACCOUNTADMIN responsibility per table. Option C is incorrect because clustering keys are not part of the COPY INTO command. Option D is incorrect because clustering is a fundamental aspect of Snowflake's architecture and cannot be fully disabled.

No community discussion yet for this question.