Snowflake SnowPro Certification Practice Test

Disable ads (and more) with a membership for a one time $4.99 payment

Prepare for the Snowflake SnowPro Certification exam with flashcards and multiple choice questions. Understand each question with detailed hints and explanations. Ace your test!

Practice this question and more.

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

Standard and Custom
Economy and High
Standard and Economy
Basic and Advanced

The correct answer is: 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.