SnowPro Core Certification — Question 1262

Based on a review of a Query Profile, which scenarios will benefit the MOST from the use of a data clustering key? (Choose two.)

Answer options

• 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

Correct answer: B, E

Explanation

The correct answers are B and E because data clustering keys optimize data retrieval for columns that are heavily utilized in WHERE clauses and JOIN operations, which can significantly improve query performance. Options A, C, and D are less beneficial in this context as they do not influence data retrieval as directly as WHERE and JOIN operations do.