
Answer-first summary for fast verification
Answer: Queries on the table are running slower than expected., The clustering depth for the table is large.
The question asks for two indicators that suggest it may be appropriate to use a clustering key for a table. According to Snowflake documentation and the community discussion (with 100% consensus on DE), the correct indicators are: D) Queries on the table are running slower than expected, and E) The clustering depth for the table is large. These align with Snowflake's guidance that clustering keys should be considered when query performance degrades or when clustering depth is high, indicating poor data organization. Option A is incorrect because very low cardinality columns are poor candidates for clustering keys as they provide minimal pruning benefits. Option B is unrelated to clustering key considerations, as DML blocking typically relates to concurrency or locking issues. Option C is incorrect because a small number of micro-partitions suggests the table is already well-organized or small, reducing the need for clustering.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which of the following scenarios indicate that it may be appropriate to use a clustering key for a table? (Choose two.)
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.