Which statement MOST accurately describes clustering in Snowflake?
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.
The Answer Is:
B
This question includes an explanation.
Explanation:
Clustering in Snowflake refers to the organization of data within micro-partitions, which are contiguous units of storage within Snowflake tables. Clustering keys can be defined to co-locate similar rows in the same micro-partitions, improving scan efficiency and query performance12.
[References: [COF-C02] SnowPro Core Certification Exam Study Guide, ]
COF-C02 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"