SOL-C01 · Question #16
SOL-C01 Question #16: Real Exam Question with Answer & Explanation
The correct answer is C: Clustering the table on the most frequently filtered columns.. Clustering is the most effective way to improve query performance for frequently queried tables, especially those with updates. Clustering organizes the physical storage of data based on the clustering keys, allowing Snowflake to efficiently prune data during queries. Views do no
Question
You are tasked with optimizing a frequently queried table 'SALES DATA' that experiences many updates. Which of the following Snowflake table features can significantly improve query performance in this scenario?
Options
- AUsing a Transient table instead of a Permanent table.
- BCreating a View on top of the table.
- CClustering the table on the most frequently filtered columns.
- DUsing a Temporary table instead of a Permanent table.
- EPartitioning the table on the date column.
Explanation
Clustering is the most effective way to improve query performance for frequently queried tables, especially those with updates. Clustering organizes the physical storage of data based on the clustering keys, allowing Snowflake to efficiently prune data during queries. Views do not affect the storage of the actual data, and transient/temporary tables are generally used for other purpose and will not improve the performence of the queries. Snowflake does not support Partitioning of the table by Users.
Topics
Community Discussion
No community discussion yet for this question.