What is the default warehouse size in the Snowflake Web UI?

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 in the Snowflake Web UI?

Explanation:
The thing being tested is what the Snowflake Web UI pre-fills as the warehouse size when you create a new virtual warehouse. In the Web UI, the default choice shown for size is Extra Large. This means new warehouses start with a substantial amount of compute power by default, which helps ensure good performance and concurrency for typical exploratory queries without needing immediate resizing. You can always change the size later if you want to save costs or scale down, but the UI’s preset aims to avoid under-provisioning and keep queries responsive out of the box. Smaller sizes would save money but could lead to longer wait times or throttling for common workloads, which is why they aren’t the default.

The thing being tested is what the Snowflake Web UI pre-fills as the warehouse size when you create a new virtual warehouse. In the Web UI, the default choice shown for size is Extra Large. This means new warehouses start with a substantial amount of compute power by default, which helps ensure good performance and concurrency for typical exploratory queries without needing immediate resizing. You can always change the size later if you want to save costs or scale down, but the UI’s preset aims to avoid under-provisioning and keep queries responsive out of the box. Smaller sizes would save money but could lead to longer wait times or throttling for common workloads, which is why they aren’t the default.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy