Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 167 discussion

Actual exam question from Snowflake's SnowPro Core

Question #: 167
Topic #: 1

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?

A. Increase the warehouse size from Medium to 2XL.
B. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
C. Configure the warehouse to a multi-cluster warehouse.
D. Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Show Suggested Answer

Suggested Answer: C 🗳️

by William_20 at Aug. 30, 2022, 8:49 a.m.

Comments

Submit Cancel

NabilR

Highly Voted 2 years, 4 months ago

Selected Answer: 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)

upvoted 5 times

...

Shipra123

Most Recent 6 months, 1 week ago

Correct answer C.

upvoted 1 times

...

pranalig

11 months, 1 week ago

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

upvoted 2 times

d22770a

7 months, 2 weeks ago

no, for WH to be multi cluster WH, max_cluster_count should be > 1 https://docs.snowflake.com/en/user-guide/warehouses-multicluster

upvoted 1 times

...

sam_art

9 months, 3 weeks ago

you are crazy

upvoted 4 times

...

Chhatresh

1 year, 1 month ago

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

upvoted 1 times

...

AnireddySaikiranReddy

1 year, 2 months ago

Correct Answer: B

upvoted 1 times

...

_yyukta

1 year, 2 months ago

Selected Answer: C

C. Configure the warehouse to a multi-cluster warehouse

upvoted 2 times

...

Marge23

1 year, 8 months ago

Selected Answer: 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;

upvoted 2 times

Marge23

1 year, 8 months ago

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

upvoted 2 times

...

Def21

1 year, 11 months ago

Selected Answer: 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

upvoted 4 times

...

Leinho

1 year, 11 months ago

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.

upvoted 2 times