ARA-C01 practice question 23 of 25

What Snowflake system functions are used to view and or monitor the clustering metadata for a table? (Select TWO).

Full set: 162 questions
Answer options
A: SYSTEMSCLUSTERING
B: SYSTEMSTABLE_CLUSTERING
C: SYSTEMSCLUSTERING_DEPTH
D: SYSTEMSCLUSTERING_RATIO
E: SYSTEMSCLUSTERING_INFORMATION
Correct Answer:
CE
Explanation

The Snowflake system functions used to view and monitor the clustering metadata for a table are: SYSTEM$CLUSTERING_INFORMATION SYSTEM$CLUSTERING_DEPTH Comprehensive But Short Explanation: The SYSTEM$CLUSTERING_INFORMATION function in Snowflake returns a variety of clustering information for a specified table. This information includes the average clustering depth, total number of micro-partitions, total constant partition count, average overlaps, average depth, and a partition depth histogram. This function allows you to specify either one or multiple columns for which the clustering information is returned, and it returns this data in JSON format. The SYSTEM$CLUSTERING_DEPTH function computes the average depth of a table based on specified columns or the clustering key defined for the table. A lower average depth indicates that the table is better clustered with respect to the specified columns. This function also allows specifying columns to calculate the depth, and the values need to be enclosed in single quotes.
Reference: SYSTEM$CLUSTERING_INFORMATION: Snowflake Documentation SYSTEM$CLUSTERING_DEPTH: Snowflake Documentation

Scroll to Top