SnowPro Advanced: Architect — Question 76

Which SQL ALTER command will MAXIMIZE memory and compute resources for a Snowpark stored procedure when executed on the snowpark_opt_wh warehouse?

Answer options

• A. alter warehouse snowpark_opt_wh set max_concurrency_level = 1;
• B. alter warehouse snowpark_opt_wh set max_concurrency_level = 2;
• C. alter warehouse snowpark_opt_wh set max_concurrency_level = 8;
• D. alter warehouse snowpark_opt_wh set max_concurrency_level = 16;

Correct answer: A

Explanation

The correct answer is A, as setting max_concurrency_level to 1 ensures that the warehouse allocates all its resources to a single process, maximizing memory and compute power for that stored procedure. Options B, C, and D would allow multiple processes to run concurrently, which could lead to resource contention and decreased performance for the stored procedure.