Snowpro Advanced Architect · Free Practice Question Medium
Question 40
- A alter warehouse snowpark_opt_wh set max_concurrency_level = 8;
- B alter warehouse snowpark_opt_wh set max_concurrency_level = 1;
- C alter warehouse snowpark_opt_wh set max_concurrency_level = 4;
- D alter warehouse snowpark_opt_wh set max_concurrency_level = 16;
Reveal correct answer
Correct answer: B
Explanation
✅ ALTER WAREHOUSE snowpark_opt_wh SET MAX_CONCURRENCY_LEVEL = 1;
Explanation:
Snowpark-optimized warehouses allow configuring memory resources and CPU architecture for workloads requiring high compute power.
Setting MAX_CONCURRENCY_LEVEL = 1 ensures that all available memory and compute resources are dedicated to a single execution, maximizing performance for Snowpark stored procedures.
This is particularly useful for machine learning (ML) training or complex data transformations that require large memory allocations.
❌ Why the other options are incorrect?
MAX_CONCURRENCY_LEVEL = 4, 8, or 16 → These settings increase concurrency, meaning resources are split across multiple executions, reducing the memory and compute available for a single stored procedure.
You can find more details on Snowpark-optimized warehouses here and here. 🚀 Let me know if you need further clarification
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
