Exam SnowPro Advanced Architect All QuestionsBrowse all questions from this exam
Question 43

Which system functions does Snowflake provide to monitor clustering information within a table (Choose two.)

    Correct Answer: A, C

    Snowflake provides the system functions SYSTEM$CLUSTERING_INFORMATION and SYSTEM$CLUSTERING_DEPTH to monitor clustering information within a table. SYSTEM$CLUSTERING_INFORMATION provides detailed clustering metadata about a specified table or clustering key, while SYSTEM$CLUSTERING_DEPTH measures the clustering depth, giving insights into the distribution of data and effectiveness of the clustering in the table.

Discussion
hillcat111

Answer is A,C and is validated

HighBMIOptions: AC

https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions