Answer-first summary for fast verification
Answer: A Snowflake determination that the table will benefit from maintenance.
The correct answer is D because Snowflake's Automatic Clustering service operates based on internal system determinations rather than fixed schedules or user interventions. According to the community discussion and Snowflake documentation, automatic clustering maintenance is triggered when Snowflake determines that a table will benefit from reclustering based on factors like data distribution and query performance, not on a fixed schedule (A), user-defined time-based schedules (B), or simple table size metrics (C). The community comments with upvotes consistently support answer D, emphasizing that Snowflake continuously monitors clustered tables and automatically triggers maintenance only when beneficial.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What causes the automatic maintenance of a table's clustering key to occur after it has been defined?
A
A scheduled task established by the ORGADMIN.
B
A time-based schedule set by the user.
C
A Snowflake determination based on the table size.
D
A Snowflake determination that the table will benefit from maintenance.
No comments yet.