SnowPro Core Certification — Question 233

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Choose two.)

Answer options

• A. The table contains a column that has very low cardinality.
• B. DML statements that are being issued against the table are blocked.
• C. The table has a small number of micro-partitions.
• D. Queries on the table are running slower than expected.
• E. The clustering depth for the table is large.

Correct answer: D, E

Explanation

The correct answers, D and E, indicate performance issues that can be alleviated by implementing a clustering key. D points to slow query performance, while E suggests a large clustering depth, both of which can benefit from better data organization. The other options do not directly indicate that clustering would improve performance.