SnowPro Core Certification — Question 607

How can a Snowflake user optimize query performance in Snowflake? (Choose two.)

Answer options

• A. Create a view.
• B. Cluster a table.
• C. Enable the search optimization service.
• D. Enable Time Travel.
• E. Index a table.

Correct answer: B, C

Explanation

Clustering a table (B) helps improve query performance by organizing data in a way that reduces the amount of data scanned during queries. Enabling the search optimization service (C) further enhances performance by optimizing how data is accessed. The other options either do not directly affect query performance or are not supported features in Snowflake.