Snowflake SnowPro Core
Get started today
Ultimate access to all questions.
What is the minimum recommended table size for defining clustering keys as a best practice?
Exam-Like
A
Multi-Kilobyte (KB) Range
B
Multi-Megabyte (MB) Range
C
Multi-Gigabyte (GB) Range
D
Multi-Terabyte (TB) Range
Explanation:
According to Snowflake documentation and the community consensus, clustering keys are recommended for tables that contain a large number of micro-partitions, which typically means the table contains multiple terabytes (TB) of data. The community discussion shows 100% agreement on option D, with multiple comments citing Snowflake's official documentation stating that clustering is best for tables containing multiple terabytes of data. Options A (KB), B (MB), and C (GB) represent much smaller table sizes where clustering would not provide meaningful benefits and could actually introduce unnecessary overhead.
Comments
Loading comments...