Snowflake SnowPro Certification Practice Test 2026 – All-in-One Guide to Master Your Certification!

Question: 1 / 400

What are the two values for SCALING_POLICY when creating a virtual warehouse?

Standard and Custom

Economy and High

Standard and Economy

The two values for SCALING_POLICY when creating a virtual warehouse in Snowflake are "Standard" and "Economy."

When you set the SCALING_POLICY to Standard, the virtual warehouse automatically scales resources based on the workload demand, ensuring optimal performance during heavy usage. This scaling can provide more concurrency and increased compute power when needed without requiring manual adjustments.

On the other hand, choosing the Economy scaling policy allows the warehouse to also scale, but it does so with a focus on cost-effectiveness. This means that while it still manages demand through scaling, it does so in a way that minimizes the overall compute costs, making it suitable for workloads where cost is a significant concern.

This distinction between "Standard" and "Economy" supports users in selecting the best option for their specific workload requirements, efficiently balancing performance and cost based on their operational needs.

Get further explanation with Examzify DeepDiveBeta

Basic and Advanced

Next Question

Report this question

Download Snowflake SnowPro Certification Practice Test PDF Study Guide
Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy