Based on a review of a Query Profile, which scenarios will benefit the MOST from the use of a data clustering key? (Choose two.)
Based on a review of a Query Profile, which scenarios will benefit the MOST from the use of a data clustering key? (Choose two.)
The clustering key help filtering and grouping.
https://docs.snowflake.com/en/user-guide/tables-clustering-keys
While ORDER BY (A) and GROUP BY (C) operations can sometimes benefit from clustering, the most significant improvements are generally seen with WHERE and JOIN operations. AGGREGATE (D) operations are not as directly impacted by clustering as the other two.
From the documentation at ( 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.[...] 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”.