When querying system$clustering_information for a table with a clustering key, what is returned if the second argument is omitted?

• A. Information for all columns.
• B. Information for the defined clustering key.
• C. An error.
• D. No information.

Answer: (B)

system$clustering_information shows details about how a table is clustered. The second argument lets you pick which clustering key to inspect. If you omit it and there is a defined clustering key (usually the case when there’s a single key), Snowflake returns information for that key—the clustering metadata for the defined clustering key. It’s not information for all columns, not an error, and not no information. (If there are multiple clustering keys, omitting the second argument would be ambiguous and you’d typically need to specify which key to examine.)