ARA-C01 practice question 21 of 25
Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)
Full set: 162 questionsAccording to the Snowflake documentation, the best practices for choosing clustering keys are: Choose columns that are frequently used in join predicates. This can improve the join performance by reducing the number of micro-partitions that need to be scanned and joined. Choose columns that are most actively used in selective filters. This can improve the scan efficiency by skipping micro-partitions that do not match the filter predicates. Avoid using low cardinality columns, such as gender or country, as clustering keys. This can result in poor clustering and high maintenance costs. Avoid using TIMESTAMP columns with nanoseconds, as they tend to have very high cardinality and low correlation with other columns. This can also result in poor clustering and high maintenance costs. Avoid using columns with duplicate values or NULLs, as they can cause skew in the clustering and reduce the benefits of pruning. Cluster on multiple columns if the queries use multiple filters or join predicates. This can increase the chances of pruning more micro-partitions and improve the compression ratio. Clustering is not always useful, especially for small or medium-sized tables, or tables that are not frequently queried or updated. Clustering can incur additional costs for initially clustering the data and maintaining the clustering over time.
Reference: Clustering Keys & Clustered Tables | Snowflake Documentation [Considerations for Choosing Clustering for a Table | Snowflake Documentation]
Keep practicing
Take the free ARA-C01 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other ARA-C01 practice questions
- Question 1An Architect needs to improve the performance of reports that pull data from multiple Sno…
- Question 2What is a characteristic of event notifications in Snowpipe?
- Question 3Based on the Snowflake object hierarchy, what securable objects belong directly to a Snow…
- Question 4An Architect has designed a data pipeline that Is receiving small CSV files from multiple…
- Question 5Which data models can be used when modeling tables in a Snowflake environment? (Select TH…
- Question 6A user has the appropriate privilege to see unmasked data in a column. If the user loads …
