Some general indicators that can help determine whether to define a clustering key for a table include:
Queries on the table are running slower than expected or have noticeably degraded over time.
The clustering depth for the table is large.
https://docs.snowflake.com/en/user-guide/tables-clustering-keys
A column with very low cardinality might yield only minimal pruning, such as a column named IS_NEW_CUSTOMER that contains only Boolean values.
In other words, very low cardinality columns may not be worth clustering (the way I read it).
DE
Queries on the table are running slower than expected or have noticeably degraded over time.
The clustering depth for the table is large.
https://docs.snowflake.com/en/user-guide/tables-clustering-keys#label-considerations-for-choosing-clustering
Answer is D and E
https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html#what-is-a-clustering-key
upvoted 5 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
halol
Highly Voted 1 year, 11 months agoKate0204
Highly Voted 1 year, 11 months agoMallikharjuna452
Most Recent 3 months, 4 weeks ago_yyukta
8 months, 3 weeks agoe_l_i_a_s
9 months, 4 weeks agoMarge23
1 year, 2 months agov1tjkee
1 year, 2 months ago0e504b5
9 months, 3 weeks agoMultiCloudIronMan
1 year, 4 months agogirgir
1 year, 8 months agofahfouhi94
1 year, 9 months agoAlexbDku
1 year, 10 months ago