Snowflake

COF-R02 · Question #156

What feature can be used to reorganize a very large table on one or more columns?

The correct answer is B. Clustering keys. https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

Querying and Performance

Question

What feature can be used to reorganize a very large table on one or more columns?

Options

AMicro-partitions
BClustering keys
CKey partitions
DClustered partitions

How the community answered

(33 responses)

A
6% (2)
B
79% (26)
C
3% (1)
D
12% (4)

Explanation

https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

Topics

#clustering keys#table organization#micro-partitions#performance

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full COF-R02 Practice