ExamGecko
Question list
Search
Search

Question 197 - COF-C02 discussion

Report
Export

Which statement MOST accurately describes clustering in Snowflake?

A.
The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.
Answers
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.
Answers
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.
Answers
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.
Answers
D.
Clustering can be disabled within a Snowflake account.
Suggested answer: B

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

asked 23/09/2024
Felipe Huichacura
31 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first