Impact of reclustering
During peak ski season, Snowy Peak's avalanche_events table receives heavy inserts as sensor reports and patrol updates arrive continuously. Over time, the clustering depth degrades as new rows land out of order relative to the event_date clustering key. Snowflake's automatic reclustering triggers in the background.
What correctly describes what happens when automatic reclustering triggers on this table?
This exercise is part of the course
Snowflake Architecture
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise