What is the default clustering state for a Snowflake table with no clustering key defined?

• A. It is automatically clustered by most recently used column.
• B. It uses automatic micro-partitioning with random clustering.
• C. It has no clustering key defined by default.
• D. It uses a hidden primary key for clustering.

Answer: (C)

In Snowflake, clustering keys are optional. If you don’t define a clustering key for a table, there is no clustering key associated with that table by default. Snowflake still stores data in automatic micro-partitions, but without a defined clustering key there’s no explicit guidance for how data is grouped for clustering. The other options misrepresent how Snowflake handles partitioning: it doesn’t cluster by the most recently used column, it doesn’t use random clustering, and there’s no hidden primary key used for clustering.