SnowPro Advanced: Architect — Question 14

Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)

Answer options

• A. Choose columns that are frequently used in join predicates.
• B. Choose lower cardinality columns to support clustering keys and cost effectiveness.
• C. Choose TIMESTAMP columns with nanoseconds for the highest number of unique rows.
• D. Choose cluster columns that are most actively used in selective filters.
• E. Choose cluster columns that are actively used in the GROUP BY clauses.

Correct answer: A, D

Explanation

The correct options, A and D, focus on using columns that enhance query performance through joins and filters, which are critical for efficient data retrieval. Option B is incorrect because lower cardinality might not always lead to optimal clustering, while C is misleading since TIMESTAMP columns with high uniqueness do not necessarily contribute to effective clustering. Option E is also incorrect as GROUP BY usage is not as critical for clustering as selective filters.