Snowpro Associate Platform · Free Practice Question Medium
Question 1
- A It automatically adjusts the number of clusters based on query demand
- B It requires manual intervention to add or remove clusters
- C It helps optimize resource utilization during variable workloads
- D It is only available for standard warehouses
Reveal correct answers
Correct answers: A, C
Explanation
✅ It automatically adjusts the number of clusters based on query demand
✅ It helps optimize resource utilization during variable workloads
Explanation:
Snowflake's auto-scale feature for multi-clustered warehouses dynamically adjusts the number of clusters based on workload demand.
Automatic scaling: Snowflake starts or shuts down clusters as needed, ensuring efficient resource allocation.
Optimized utilization: Helps balance performance and cost by scaling up during peak times and scaling down when demand decreases.
❌ It requires manual intervention to add or remove clusters (Auto-scale operates without manual adjustments)
❌ It is only available for standard warehouses (Multi-cluster warehouses are available in Enterprise Edition and higher)
More details in Snowflake’s documentation.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
