What is the MINIMUM size of a table for which Snowflake recommends considering adding a clustering key?

The correct answer is D. 1 Terabyte (TB). Snowflake recommends considering a clustering key only for very large tables - specifically those in the multi-terabyte range, with 1 TB (D) being the cited minimum threshold in Snowflake's documentation. For smaller tables, Snowflake's automatic micro-partition pruning is…

Performance Management

Question

Options

A1 Kilobyte (KB)
B1 Megabyte (MB)
C1 Gigabyte (GB)
D1 Terabyte (TB)

How the community answered

(49 responses)

A
2% (1)
B
2% (1)
C
4% (2)
D
92% (45)

Explanation

Snowflake recommends considering a clustering key only for very large tables - specifically those in the multi-terabyte range, with 1 TB (D) being the cited minimum threshold in Snowflake's documentation. For smaller tables, Snowflake's automatic micro-partition pruning is sufficient, and adding a clustering key introduces maintenance overhead (via Automatic Clustering) that is not justified at smaller data volumes.

Topics

#Clustering Key#Performance Optimization#Table Size Recommendations

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice