Is reclustering automatic after you define a clustering key on a table?

• A. True
• B. False
• C. Depends on table size
• D. Only with manual triggers

Answer: (A)

Once you define a clustering key, the system can automatically maintain that clustering if you enable Automatic Clustering on the table. The clustering key tells Snowflake which columns to optimize for, and with automatic clustering turned on, Snowflake continuously monitors data changes and reclusters micro-partitions in the background to keep data well-clustered for faster queries. If automatic clustering isn’t enabled, reclustering won’t happen automatically and would require manual action. So the statement is true when Automatic Clustering is enabled, which is why that answer is the best choice.