Free Snowflake DEA-C01 Exam Dumps

A table with no micro-partitions (i.e. an unpopulated/empty table) has a clustering depth of 0.

SYSTEM$CLUSTERING_DEPTH:

Computes the average depth of the table according to the specified columns (or the clustering key defined for the table). The average depth of a populated table (i.e. a table containing data) is always 1 or more. The smaller the average depth, the better clustered the table is with regards to the speci-fied columns.

Calculate the clustering depth for a table using two columns in the table:

SELECT SYSTEM$CLUSTERING_DEPTH('TPCH_PRODUCT', '(C2, C9)');

SYSTEM$CLUSTERING_INFORMATION:

Returns clustering information, including average clustering depth, for a table based on one or more columns in the table.

SELECT SYSTEM$CLUSTERING_INFORMATION('SAMPLE_TABLE', '(col1, col3)');