Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 201

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Choose two.)

    Correct Answer: B, D

    To handle high concurrency workloads, Snowflake utilizes two key features. First is the use of warehouse auto scaling, which automatically adds or removes compute resources in response to varying workload demands. This allows on-demand scaling to accommodate spikes in concurrent query loads. Second, the use of multi-clustered warehouses enables Snowflake to dynamically allocate and scale resources across multiple clusters, providing elasticity and improved performance during high concurrency operations.

Discussion
JiaaOptions: BD

I think BD https://docs.snowflake.com/en/sql-reference/parameters.html#max-concurrency-level https://docs.snowflake.com/en/sql-reference/parameters.html#max-concurrency-level

dmitriypoOptions: BD

Definitely BD

shyemkoOptions: BD

Auto-scaling Multicluster warehouse

_yyuktaOptions: BD

B and D are correct

MultiCloudIronManOptions: BD

correct