If a table has no clustering key and you call system$clustering_information with only the table name omitted, what happens?

• A. It returns information for all columns.
• B. It results in an error.
• C. It uses the clustering key.
• D. It returns an empty result.

Answer: (B)

system$clustering_information needs a specific table to inspect. It returns clustering details for that table, so a table identifier (like schema.table or just table) must be provided. If you call the function without supplying a table name, the call is invalid because Snowflake has nothing to query, and it will raise an error. The situation where a table has no clustering key is only relevant when a valid table name is given—the function would then show that there is no clustering key for that table. So omitting the table name leads to an error rather than returning information or an empty result.