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

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