Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)
Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)
When prioritizing cluster keys in Snowflake, it is best practice to choose columns that are frequently used in join predicates. This helps in optimizing the performance of join operations. Additionally, selecting cluster columns that are most actively used in selective filters is crucial as it enhances query performance by reducing the amount of data scanned during these queries.
https://docs.snowflake.com/en/user-guide/tables-clustering-keys 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”.
Answer is A,D and is validated