exam questions

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
[All SnowPro Core Questions]

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 Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
NabilR
Highly Voted 1 year, 11 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 1 month, 1 week ago
Correct answer C.
upvoted 1 times
...
pranalig
6 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
2 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
4 months, 3 weeks ago
you are crazy
upvoted 4 times
...
...
Chhatresh
8 months, 2 weeks 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
...
Correct Answer: B
upvoted 1 times
...
_yyukta
10 months ago
Selected Answer: C
C. Configure the warehouse to a multi-cluster warehouse
upvoted 2 times
...
Marge23
1 year, 3 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, 3 months ago
ohh no! its not B its C but that is to add clusters.
upvoted 2 times
...
...
Def21
1 year, 6 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, 6 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
d22770a
2 months, 2 weeks ago
Don't you think it is already a multi-cluster Maximized WH? It same value for min_cluster_count and max_cluster_count
upvoted 1 times
d22770a
2 months, 2 weeks ago
My. bad max_cluster_count = 1, so it is NOT a muli-cluster WH, Ans is C
upvoted 1 times
...
...
...
KarBiswa
1 year, 10 months ago
Selected Answer: C
If auto scaling is enabled then it will be more flattened because edition is not mentioned
upvoted 1 times
...
ajay_1233456
1 year, 11 months ago
Better solution C
upvoted 1 times
...
aalonso
2 years ago
Selected Answer: C
Better solution C
upvoted 3 times
...
baig123
2 years ago
correct answer C:
upvoted 1 times
...
db1290
2 years ago
should be C
upvoted 1 times
...
Sk1020
2 years, 1 month ago
Selected Answer: C
Answer should be C as files can be seen in queue awaiting to be processed.
upvoted 1 times
...
R12346
2 years, 2 months ago
Selected Answer: C
Should use multi-cluster and set the auto-scale parameter
upvoted 1 times
...
jveag
2 years, 3 months ago
Selected Answer: C
Think same
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago