SnowPro Core Certification — Question 752

How can a user improve the performance of a single large complex query in Snowflake?

Answer options

• A. Scale up the virtual warehouse.
• B. Scale out the virtual warehouse.
• C. Enable standard warehouse scaling.
• D. Enable economy warehouse scaling.

Correct answer: A

Explanation

Scaling up the virtual warehouse increases the compute resources available for the query, allowing it to run more efficiently. Scaling out would involve adding more virtual warehouses, which is beneficial for concurrent workloads but not specifically for improving a single query's performance. Enabling standard or economy warehouse scaling does not directly enhance performance as effectively as scaling up.