SnowPro Core Certification — Question 692

The use of which technique or tool will improve Snowflake query performance on very large tables?

Answer options

• A. Indexing
• B. Clustering keys
• C. Multi-clustering
• D. Materialized views

Correct answer: B

Explanation

Clustering keys help organize the data in a way that optimizes query performance on large tables by reducing the amount of data scanned. While indexing, multi-clustering, and materialized views are useful techniques in different contexts, they do not specifically address the performance improvements for large table queries in Snowflake as effectively as clustering keys do.