Which one of the below is true about clustering depth?

Which one of the below is true about clustering depth?
A . The smaller the average depth, the better clustered the table is with respect to the specified columns
B. The larger the average depth, the better clustered the table is with respect to the specified columns
C. The smaller the maximum depth, the better clustered the table is with respect to the specified columns

View Answer

Answer: A

Explanation

Clustering Depth

The clustering depth for a populated table measures the average depth (1 or greater) of the overlapping micro-partitions for specified columns in a table. The smaller the average depth, the better clustered the table is with regards to the specified columns.

Clustering depth can be used for a variety of purposes, including:

Monitoring the clustering “health” of a large table, particularly over time as DML is performed on the table.

Determining whether a large table would benefit from explicitly defining a clustering key.