Which statement describes the purpose of the system$clustering_depth function?

• A. To retrieve the depth of clustering for a table.
• B. To compute the clustering ratio.
• C. To obtain clustering information.
• D. To modify clustering depth.

Answer: (A)

The function is used to retrieve the clustering depth for a table, a numeric measure of how well the table’s data aligns with its clustering keys. Clustering depth reflects how deeply data has been reorganized into clustered micro-partitions—the higher the depth, the more effective the clustering is for pruning data during queries. This helps you assess whether the clustering key is providing benefits and when you might consider reclustering. It does not compute a clustering ratio, nor does it provide a broad set of clustering metadata (that would be system$clustering_information), and it does not modify clustering depth.