SnowPro Advanced: Architect — Question 35

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

Answer options

• A. SYSTEM$CLUSTERING_INFORMATION
• B. SYSTEM$CLUSTERING_USAGE
• C. SYSTEM$CLUSTERING_DEPTH
• D. SYSTEM$CLUSTERING_KEYS
• E. SYSTEM$CLUSTERING_PERCENT

Correct answer: A, C

Explanation

The correct answers, SYSTEM$CLUSTERING_INFORMATION and SYSTEM$CLUSTERING_DEPTH, are specifically designed to provide insights into clustering in Snowflake tables. The other options, while related, do not serve the same function in monitoring clustering information.