Exam SnowPro Core topic 1 question 1095 discussion

D is correct

its D select clause is the column you choose to select. We dont care about that. We care about the columns being filtered in the WHERE clause.

selective filters is different than select clause

"Snowflake recommends prioritizing keys in the order below: Cluster columns that are most actively used in selective filters."

It's C : https://docs.snowflake.com/en/user-guide/tables-clustering-keys#strategies-for-selecting-clustering-keys "Selecting the right columns/expressions for a clustering key can dramatically impact query performance. Analysis of your workload will usually yield good clustering key candidates. Snowflake recommends prioritizing keys in the order below: Cluster columns that are most actively used in selective filters"

C Snowflake recommends prioritizing keys in the order below: Cluster columns that are most actively used in selective filters. For many fact tables involved in date-based queries (for example “WHERE invoice_date > x AND invoice date <= y”), choosing the date column is a good idea. For event tables, event type might be a good choice, if there are a large number of different event types. (If your table has only a small number of different event types, then see the comments on cardinality below before choosing an event column as a clustering key.) If there is room for additional cluster keys, then consider columns frequently used in join predicates, for example “FROM table1 JOIN table2 ON table2.column_A = table1.column_B”.

C https://docs.snowflake.com/en/user-guide/tables-clustering-keys#:~:text=Cluster%20columns%20that%20are%20most%20actively%20used%20in%20selective%20filters

it s D