Which statement about system$clustering_information is true for a table with a clustering key when the second argument is omitted?

• A. Snowflake uses the defined clustering key by default.
• B. Snowflake returns an error.
• C. Snowflake returns information for all columns.
• D. Snowflake cannot be called.

Answer: (A)

When you call system$clustering_information with only the table name, Snowflake treats the request as asking for clustering metadata for the table’s defined clustering key. The second argument identifies a specific clustering key column, but if you omit it, the default is to use the table’s clustering key. So for a table that has a clustering key, the function returns information about that key by default, not an error and not information for every column. This is why using just the table name uses the defined clustering key by default.