SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ30

Data Storage and Processing

A table has 10 distinct values in one of its columns.

Assuming the table contains 10 micro-partitions and each of the 10 values is stored exclusively in a separate micro-partition, what is the clustering depth of the table for this column?

Explanation

For a populated Snowflake table, clustering depth is the average depth of overlapping micro-partitions for the specified column and is always at least 1. Storing each distinct value exclusively in a different micro-partition produces no overlap, so the table has the minimum clustering depth of 1.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!