SnowPro Core Certification — Question 599

How can a Snowflake user improve long-running query performance?

Answer options

• A. Reduce the virtual warehouse size.
• B. Cluster the underlying table being queried.
• C. Disable the result cache.
• D. Add ORDER BY to the query.

Correct answer: B

Explanation

The correct answer is B because clustering the underlying table helps optimize data retrieval, which can significantly reduce query execution time. Option A is incorrect as reducing the virtual warehouse size may lead to decreased performance due to less available compute resources. Option C is not advisable since disabling the result cache can lead to longer execution times for repeated queries. Option D, while potentially useful, does not directly address long-running query performance improvements.