ARA-C01 · Question #66
What Snowflake system functions are used to view and or monitor the clustering metadata for a table? (Select TWO).
The correct answer is C. SYSTEMSCLUSTERING_DEPTH E. SYSTEMSCLUSTERING_INFORMATION. Snowflake provides two system functions specifically for inspecting table clustering metadata. SYSTEM$CLUSTERING_DEPTH (C) returns a single numeric value representing the average depth of the overlapping micro-partitions for a table's clustering key - a lower depth means better…
Question
What Snowflake system functions are used to view and or monitor the clustering metadata for a table? (Select TWO).
Options
- ASYSTEMSCLUSTERING
- BSYSTEMSTABLE_CLUSTERING
- CSYSTEMSCLUSTERING_DEPTH
- DSYSTEMSCLUSTERING_RATIO
- ESYSTEMSCLUSTERING_INFORMATION
How the community answered
(28 responses)- B4% (1)
- C93% (26)
- D4% (1)
Explanation
Snowflake provides two system functions specifically for inspecting table clustering metadata. SYSTEM$CLUSTERING_DEPTH (C) returns a single numeric value representing the average depth of the overlapping micro-partitions for a table's clustering key - a lower depth means better clustering. SYSTEM$CLUSTERING_INFORMATION (E) returns a more detailed JSON object containing comprehensive clustering statistics, including the total number of micro-partitions, how many are overlapping, the clustering depth distribution, and the clustering ratio. The other options (A, B, D) are not valid Snowflake system functions - they do not exist in the Snowflake function catalog.
Topics
Community Discussion
No community discussion yet for this question.