Snowflake
COF-R02 · Question #89
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
The correct answer is A. The table contains a column that has very low cardinality E. The clustering depth for the table is large. See the full explanation below for the reasoning.
Question
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
Options
- AThe table contains a column that has very low cardinality
- BDML statements that are being issued against the table are blocked
- CThe table has a small number of micro-partitions
- DQueries on the table are running slower than expected
- EThe clustering depth for the table is large
How the community answered
(48 responses)- A83% (40)
- B4% (2)
- C2% (1)
- D10% (5)
Community Discussion
No community discussion yet for this question.