SnowPro Advanced: Data Engineer — Question 20

Which output is provided by both the SYSTEM$CLUSTERING_DEPTH function and the SYSTEM$CLUSTERING_INFORMATION function?

Answer options

• A. average_depth
• B. notes
• C. average_overlaps
• D. total_partition_count

Correct answer: A

Explanation

The correct answer is A, as both functions return the average depth of clustering. The other options are not returned by both functions: 'notes' (B) and 'total_partition_count' (D) are specific to certain contexts, while 'average_overlaps' (C) is not related to the outputs of these functions.