SnowPro Core Certification — Question 277

Which Snowflake technique can be used to improve the performance of a query?

Answer options

• A. Clustering
• B. Indexing
• C. Fragmenting
• D. Using INDEX_HINTS

Correct answer: A

Explanation

Clustering in Snowflake helps organize data in a way that optimizes query performance by reducing the amount of data scanned. The other options, such as Indexing and Using INDEX_HINTS, do not apply to Snowflake as it does not use traditional indexing methods. Fragmenting is not a recognized technique for performance enhancement in Snowflake.