Answer-first summary for fast verification
Answer: The complexity of each query, The size of the data required for each query
The correct answers are A and C. According to Snowflake documentation and the community discussion, the number of queries a virtual warehouse can process concurrently is determined by the complexity of each query (A) and the size of the data required for each query (C). These factors directly impact resource allocation and consumption. Option B (CONCURRENT_QUERY_LIMIT) is incorrect because this parameter does not exist in Snowflake; the relevant parameter is MAX_CONCURRENCY_LEVEL, which is not listed. Option D (the tool executing the query) is irrelevant to warehouse concurrency limits. The community consensus strongly supports AC (73% of votes), with detailed reasoning that complexity and data size are the key determinants, while clarifying that B is incorrect due to the parameter name mismatch.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which two factors determine the number of queries a virtual warehouse can process concurrently?
A
The complexity of each query
B
The CONCURRENT_QUERY_LIMIT parameter set on the Snowflake account
C
The size of the data required for each query
D
The tool that is executing the query
No comments yet.