Which query correctly retrieves clustering information for test2 when querying specific columns and there is no clustering key?

• A. select system$clustering_information('test2', '(col1, col3)');
• B. select system$clustering_information('test2');
• C. select system$clustering_information('test2', 'columns=col1, col3');
• D. select system$clustering_information('test2', 'col1, col3');

Answer: (A)

When you want clustering info for specific columns, you pass the table name and a column list as the second argument in a single string, with the columns inside parentheses. This tells Snowflake to return clustering details only for those columns on the given table. In the correct form, you’d see the second argument as '(col1, col3)'. If you omit the second argument, you get clustering info for the whole table. If you use a different syntax like 'columns=col1, col3' or omit the parentheses, Snowflake won’t interpret it as the per-column list, so you won’t get the targeted clustering details.