Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 399

Which statement MOST accurately describes clustering in Snowflake?

The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.

Clustering is the way data is grouped together and stored within Snowflake micro-partitions.

The clustering key must be included in the COPY command when loading data into Snowflake.

Clustering can be disabled within a Snowflake account.

Correct Answer: B

Clustering in Snowflake refers to how data is grouped together and stored within micro-partitions. This process helps optimize query performance by sorting related records together, making data retrieval more efficient. This definition accurately captures the essence of clustering in Snowflake.

Discussion

NikoHacker1995Option: B

I guess it is B, but I am happy, if someone can confirm or deny! (P.S. sorry for my bad englisch!)

subbieOption: B

B is the most accurate statement about clustering.

_yyuktaOption: B

B is correct

MultiCloudIronManOption: B

B is correct

yfswangOption: D

Answer should be D Clustering can be disabled within a Snowflake account.

sakis213

Clustering can only be disabled on table level. I would go with B.