What is the default warehouse size when executing CREATE WAREHOUSE?

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

What is the default warehouse size when executing CREATE WAREHOUSE?

Explanation:
When you create a warehouse without specifying a size, Snowflake uses the smallest compute capacity by default. That default is Extra Small (X-SMALL). This keeps initial costs low and gives you a baseline you can scale from if your workload grows. If you need more power later, you can alter the warehouse to a larger size (Small, Medium, Large, etc.) or enable more clusters as needed.

When you create a warehouse without specifying a size, Snowflake uses the smallest compute capacity by default. That default is Extra Small (X-SMALL). This keeps initial costs low and gives you a baseline you can scale from if your workload grows. If you need more power later, you can alter the warehouse to a larger size (Small, Medium, Large, etc.) or enable more clusters as needed.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy