ARA-C01 · Question #132
ARA-C01 Question #132: Real Exam Question with Answer & Explanation
Sign in or unlock ARA-C01 to reveal the answer and full explanation for question #132. The question stem and answer options stay visible for context.
Question
A table contains five columns and it has millions of records. The cardinality distribution of the columns is shown below: Column C4 and C5 are mostly used by SELECT queries in the GROUP BY and ORDER BY clauses. Whereas columns C1, C2 and C3 are heavily used in filter and join conditions of SELECT queries. The Architect must design a clustering key for this table to improve the query performance. Based on Snowflake recommendations, how should the clustering key columns be ordered while defining the multi-column clustering key?
Options
- AC5, C4, C2
- BC3, C4, C5
- CC1, C3, C2
- DC2, C1, C3
Unlock ARA-C01 to see the answer
You've previewed enough free ARA-C01 questions. Unlock ARA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.