SnowPro Core Certification — Question 351

Which clustering indicator will show if a large table in Snowflake will benefit from explicitly defining a clustering key?

Answer options

• A. Percentage
• B. Depth
• C. Ratio
• D. Total partition count

Correct answer: B

Explanation

The correct answer is B, Depth, as it measures how well the data is organized in the table, indicating the potential benefits of a clustering key. The other options, while relevant to data organization, do not specifically assess the clustering efficiency as Depth does.