SnowPro Core Certification — Question 1139

What triggers the automated maintenance of a table's clustering key after it has been defined?

Answer options

• 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.

Correct answer: D

Explanation

The correct answer is D, as Snowflake automatically determines when a table requires maintenance based on its clustering key's effectiveness. Options A and B suggest user-defined schedules, which do not apply to Snowflake's automated process. Option C incorrectly implies that maintenance is dependent solely on table size, overlooking the broader criteria that Snowflake uses.