Exam SnowPro Core topic 1 question 80 discussion

Only A and C is correct , B would also have been corrected if MAX_CONCURRENCY_LEVEL was given but here option is MAX_CONCURRENCY_LIMIT .

AB is the answer

I think it's A and B because "You can use the MAX_CONCURRENCY_LEVEL parameter to limit the number of concurrent queries running in a warehouse." and "The number of queries that a warehouse can concurrently process is determined by the size and complexity of each query. " here it seems the number of queries processed are determined by the query complexity and its size and not the data size.

AC is correct

https://docs.snowflake.com/en/user-guide/warehouses-overview.html#query-processing-and-concurrency AC are correct

AC are correct

Answer: AC MAX_CONCURRENCY_LEVEL is set to 8 by default at account level and can be changed. In reality, we can have more than 8 concurrent queries as well. But it depends on the factors such as the complexity of the queries, their resource consumptions etc.

What about parameter MAX_CONCURRENCY_LEVEL that defines the maximum number of parallel or concurrent statements a warehouse can execute? https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-Timeout-Parameters

Answer is correct. The number of queries that a warehouse can concurrently process is determined by the size and complexity of each query. As queries are submitted, the warehouse calculates and reserves the compute resources needed to process each query. If the warehouse does not have enough remaining resources to process a query, the query is queued, pending resources that become available as other running queries complete.