ExamGecko
Question list
Search
Search

List of questions

Search

Question 94 - ARA-C01 discussion

Report
Export

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

A.
SYSTEMSCLUSTERING
Answers
A.
SYSTEMSCLUSTERING
B.
SYSTEMSTABLE_CLUSTERING
Answers
B.
SYSTEMSTABLE_CLUSTERING
C.
SYSTEMSCLUSTERING_DEPTH
Answers
C.
SYSTEMSCLUSTERING_DEPTH
D.
SYSTEMSCLUSTERING_RATIO
Answers
D.
SYSTEMSCLUSTERING_RATIO
E.
SYSTEMSCLUSTERING_INFORMATION
Answers
E.
SYSTEMSCLUSTERING_INFORMATION
Suggested answer: C, E

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.

SYSTEM$CLUSTERING_INFORMATION: Snowflake Documentation

SYSTEM$CLUSTERING_DEPTH: Snowflake Documentation

asked 23/09/2024
franz yap
38 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first