ExamGecko
Question list
Search
Search

List of questions

Search

Question 34 - ARA-C01 discussion

Report
Export

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

A.
Answers
A.
B.
Answers
B.
C.
Answers
C.
D.
Answers
D.
Suggested answer: A

Explanation:

To maximize memory and compute resources for a Snowpark stored procedure, you need to set the MAX_CONCURRENCY_LEVEL parameter for the warehouse that executes the stored procedure. This parameter determines the maximum number of concurrent queries that can run on a single warehouse. By setting it to 16, you ensure that the warehouse can use all the available CPU cores and memory on a single node, which is the optimal configuration for Snowpark-optimized warehouses. This will improve the performance and efficiency of the stored procedure, as it will not have to share resources with other queries or nodes. The other options are incorrect because they either do not change the MAX_CONCURRENCY_LEVEL parameter, or they set it to a lower value than 16, which will reduce the memory and compute resources for the stored procedure.Reference:

[Snowpark-optimized Warehouses]1

[Training Machine Learning Models with Snowpark Python]2

[Snowflake Shorts: Snowpark Optimized Warehouses]3

asked 23/09/2024
Thomas Kringel
37 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first