SnowPro Core Certification — Question 425

What technique does Snowflake recommend for determining which virtual warehouse size to select?

Answer options

• A. Always start with an X-Small and increase the size if the query does not complete in 2 minutes
• B. Experiment by running the same queries against warehouses of different sizes
• C. Use the default size Snowflake chooses
• D. Use X-Large or above for tables larger than 1 GB

Correct answer: B

Explanation

The correct answer is B because experimenting with different sizes allows you to find the most efficient configuration for your specific workload. Option A is not recommended as starting with a small size may not be effective for all queries. Option C is not ideal since relying solely on the default size might not suit all performance needs. Option D is overly specific and may not always be necessary.