
Answer-first summary for fast verification
Answer: 1 Terabyte (TB)
According to Snowflake's official documentation on clustering keys, the recommendation is to consider adding a clustering key when a table reaches approximately 1 Terabyte (TB) in size. This is because clustering keys are primarily beneficial for large tables where query performance can be significantly improved by organizing data physically. For smaller tables (KB, MB, or GB sizes), the automatic micro-partitioning in Snowflake typically provides sufficient performance without the need for explicit clustering keys. The community discussion shows 100% consensus on option D, with references to Snowflake's official documentation confirming this recommendation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.