Which of the following indicates that it may be appropriate to use a clustering key for a table? (Choose two.)
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Choose two.)
Using a clustering key for a table can be appropriate if queries on the table are running slower than expected or if the clustering depth for the table is large. These indicators suggest that the data distribution may benefit from better organization, which clustering can provide, thereby improving query performance.
D&E https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html#:~:text=for%20a%20Table-,What,-is%20a%20Clustering
DE I think
Answer is D and E https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html#what-is-a-clustering-key
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
I think D E
DE are correct
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.
correct ans
Why not A?
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).
Correct