Which SQL ALTER command will MAXIMIZE memory and compute resources for a Snowpark stored procedure when executed on the snowpark_opt_wh warehouse?
Which SQL ALTER command will MAXIMIZE memory and compute resources for a Snowpark stored procedure when executed on the snowpark_opt_wh warehouse?
To maximize memory and compute resources for a Snowpark stored procedure, you should set the warehouse's MAX_CONCURRENCY_LEVEL parameter to 1. This setting ensures that all available resources are dedicated to a single task, thereby maximizing performance for that particular procedure.
A is right Set the warehouse MAX_CONCURRENCY_LEVEL parameter to 1 to maximize memory and compute resources for a given Snowpark stored procedure. https://docs.snowflake.com/en/developer-guide/snowpark/python/python-snowpark-training-ml