Answer-first summary for fast verification
Answer: A column that appears most frequently in WHERE operations, A column that appears most frequently in JOIN operations
The question asks which scenarios benefit MOST from data clustering keys, requiring selection of two options. Based on Snowflake documentation, clustering keys primarily optimize queries with selective filters (WHERE clauses) and JOIN operations. WHERE clauses benefit because clustering physically organizes data to minimize micro-partition scanning when filtering. JOIN operations benefit because clustering matching columns improves join efficiency by co-locating related data. While ORDER BY and GROUP BY can see some benefits, they are secondary to WHERE and JOIN for clustering optimization. INSERT and UPDATE operations are DML operations that don't directly benefit from clustering keys for performance.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Based on a review of a Query Profile, which scenarios will benefit the MOST from the use of a data clustering key? (Choose two.)
A
A column that appears most frequently in ORDER BY operations
B
A column that appears most frequently in WHERE operations
C
A column that appears most frequently in GROUP BY operations
D
A column that appears most frequently in AGGREGATE operations
E
A column that appears most frequently in JOIN operations
