Exam SnowPro Core All QuestionsBrowse all questions from this exam
Go to Exam
Question 167

A virtual warehouse is created using the following command:

Create warehouse my_WH with -

warehouse_size = MEDIUM

min_cluster_count = 1

max_cluster_count = 1

auto_suspend = 60

auto_resume = true;

The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

    Correct Answer: C

    The current configuration of the virtual warehouse has a fixed number of clusters (min_cluster_count = 1 and max_cluster_count = 1). This means it cannot scale out to handle the increased workload dynamically, leading to query queuing. The graphical representation shows times when queries are queued while others are running, implying that the capacity of the warehouse is insufficient to handle the workload. Configuring the warehouse to a multi-cluster configuration would allow it to scale out by adding more clusters as the demand increases, thus alleviating the queuing issue and efficiently handling the workload.

Discussion
Def21Option: C

Nowadays default MAX_CONCURRENCY_LEVEL is 8 (previously 6?). Thus, concurrency is not an issue. We need multi-cluster https://docs.snowflake.com/en/sql-reference/parameters#max-concurrency-level

NabilROption: C

We can see that queries are queued starting from 4 queries running. Later 6 queries are running in concurrency. So queries are queued not for reaching the max possible number of queries, but for reaching the max Cluster utilization. Therefor, the best solution is to scale out (Answer C)

aalonsoOption: C

Better solution C

pranaligOption: B

Correct Answer: B since it is already a multi cluster but having same min and max cluser size

_yyuktaOption: C

C. Configure the warehouse to a multi-cluster warehouse

Marge23Option: B

Ans is B - MAX_CONCURRENCY_LEVEL The given is already a multicluster warehouse but only 1 cluster. so no need to configure the warehouse to a MC but to add cluster. Create warehouse my_WH with - warehouse_size = MEDIUM min_cluster_count = 1 max_cluster_count = 1 auto_suspend = 60 auto_resume = true;

Marge23

ohh no! its not B its C but that is to add clusters.

Leinho

I think is a very open question, what do you want to address? the performance or the queuing? If you want better performance in fewer queries so you should go for the MAX_CONCURRENCY_LEVEL, but if you want reduce the queuing you should look to the multi-clustering solution.

ChhatreshOption: C

If Queuing is the main concern here and if we set MAX_CONCURRENCY_LEVEL parameter to 8 or more, it can solve the Queuing problem but may lead to performance issue. queries will take longer time to complete as these share available compute resources. better solution is to scale out

AnireddySaikiranReddyOption: B

Correct Answer: B

KarBiswaOption: C

If auto scaling is enabled then it will be more flattened because edition is not mentioned

ajay_1233456Option: C

Better solution C

baig123Option: C

correct answer C:

db1290Option: C

should be C

Sk1020Option: C

Answer should be C as files can be seen in queue awaiting to be processed.

R12346Option: C

Should use multi-cluster and set the auto-scale parameter

jveagOption: C

Think same

William_20Option: C

Multi-cluster is the solution for concurrency