If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

The correct answer is D. The columns most actively used in the select filters. When deciding on a clustering key for a table, Snowflake recommends using the columns that are most actively used in the select filters. This is because clustering by these columns can improve the performance of queries that filter on these values, leading to more efficient…

Performance Management

Question

Options

AThe columns that are queried in the select clause.
BThe columns with very high cardinality.
CThe columns with many different values.
DThe columns most actively used in the select filters.

How the community answered

(47 responses)

A
6% (3)
B
2% (1)
C
2% (1)
D
89% (42)

Explanation

When deciding on a clustering key for a table, Snowflake recommends using the columns that are most actively used in the select filters. This is because clustering by these columns can improve the performance of queries that filter on these values, leading to more efficient scans and better overall query performance.

Topics

#Clustering#Performance Optimization#Table Design

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice