Which metric is included in the SYSTEM$CLUSTERING_INFORMATION output?

• A. The total number of micro-partitions that comprise the table.
• B. The count of stored procedures in the database.
• C. The last query execution time.
• D. The size of the largest partition.

Answer: (A)

The metric being tested is about understanding what SYSTEM$CLUSTERING_INFORMATION reveals to help assess how data is laid out for clustering. This view shows clustering-related metrics for a table, including a count that directly reflects how many micro-partitions the table spans. Micro-partitions are Snowflake’s storage blocks, and knowing their total number gives insight into data fragmentation and the potential impact of clustering on pruning. The other items listed don’t pertain to clustering information: the total number of stored procedures is metadata about objects in the database, last query execution time is a runtime performance metric, and the size of the largest partition isn’t a standard part of the clustering information output.