What type of columns does Snowflake recommend to be used as clustering keys? (Choose two.)
What type of columns does Snowflake recommend to be used as clustering keys? (Choose two.)
Snowflake recommends using columns with very high cardinality as clustering keys because they tend to provide better clustering properties and improve the efficiency of queries that filter or scan large tables. Additionally, columns that are most actively used in selective filters are recommended because they help optimize query performance by reducing the amount of data that needs to be scanned.
Cardinality should not be extremely high or low so C is not a best answer
correct
https://docs.snowflake.com/en/user-guide/tables-clustering-keys
https://docs.snowflake.com/en/user-guide/tables-clustering-keys