ExamTopics Logo
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam
Go to Exam

Exam SnowPro Core topic 1 question 237 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 237
Topic #: 1
[All SnowPro Core Questions]

When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of queries is always queuing in the warehouse.

According to recommended best practice, what should be done to reduce the queue volume? (Choose two.)

  • A. Use multi-clustered warehousing to scale out warehouse capacity.
  • B. Scale up the warehouse size to allow queries to execute faster.
  • C. Stop and start the warehouse to clear the queued queries.
  • D. Migrate some queries to a new warehouse to reduce load.
  • E. Limit user access to the warehouse so fewer queries are run against it.
Show Suggested Answer Hide Answer
Suggested Answer: AD 🗳️
by Tapasgup007 at Nov. 30, 2022, 11:46 a.m.

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
Submit Cancel
danilchezz
Highly Voted 2 years, 7 months ago
Selected Answer: AD
This is per Snowflake documentation: https://docs.snowflake.com/en/user-guide/warehouses-load-monitoring.html#slow-query-performance
upvoted 12 times
EmiB
2 years, 3 months ago
If the running query load is high or there’s queuing, consider - starting a separate warehouse and moving queued queries to that warehouse. - Alternatively, if you are using multi-cluster warehouses, you could change your multi-cluster settings to add additional clusters to handle higher concurrency going forward.
upvoted 3 times
...
...
PrasantSadangi
Most Recent 3 months, 1 week ago
Selected Answer: AD
consider starting a separate warehouse and moving queued queries to that warehouse.
upvoted 1 times
...
vivekmani2021
11 months, 1 week ago
You are trying to solve for concurrency, so either scale out or add new warehouses
upvoted 1 times
...
pranalig
1 year ago
Correct answer:AB
upvoted 1 times
...
nexerSnow
1 year, 1 month ago
Selected Answer: AB
A&B r correct
upvoted 1 times
...
MultiCloudIronMan
1 year, 11 months ago
Selected Answer: AD
Correct
upvoted 1 times
...
Needium
2 years, 2 months ago
Selected Answer: AB
if queries execute faster, there will be lesser queries in the queue. moving to another virtual warehouse may be a temporary fix, but when it's a persistent problem then you should first scale out your virtual warehouse. If scaling out does not fully address the issue, you should consider scaling up as well
upvoted 2 times
...
Raju039
2 years, 3 months ago
Selected Answer: AD
If the running query load is high or there’s queuing, consider starting a separate warehouse and moving queued queries to that warehouse. Alternatively, if you are using multi-cluster warehouses, you could change your multi-cluster settings to add additional clusters to handle higher concurrency going forward.
upvoted 3 times
...
OTE
2 years, 3 months ago
Selected Answer: AD
Tricky question as scaling up (B) could potentially also help. However, I think it's A/D because the question is about loading data and, thus, concurrency, not complex queries.
upvoted 4 times
...
girgir
2 years, 4 months ago
AB, not AD, the key word here is 'always' which indicates the action needed is for following computes but not necessarily current running queries. moving queued queries to new warehouse is temp solution. scale up and scale out is the permanent solution. https://docs.snowflake.com/en/user-guide/warehouses-load-monitoring.html#slow-query-performance
upvoted 3 times
Raju039
2 years, 3 months ago
It's AD. Scaling up(B) is needed only when Query performance is slow.
upvoted 2 times
...
...
n21007
2 years, 4 months ago
Selected Answer: AD
https://docs.snowflake.com/en/user-guide/warehouses-load-monitoring.html#slow-query-performance
upvoted 2 times
...
fahfouhi94
2 years, 5 months ago
Selected Answer: AD
correct answer
upvoted 1 times
...
sailoo
2 years, 5 months ago
AD for sure
upvoted 1 times
...
nintendogamer64
2 years, 6 months ago
Selected Answer: AD
https://docs.snowflake.com/en/user-guide/warehouses-load-monitoring.html#slow-query-performance
upvoted 1 times
...
nintendogamer64
2 years, 6 months ago
AB: If the running query load is high or there’s queuing, consider starting a separate warehouse and moving queued queries to that warehouse. Alternatively, if you are using multi-cluster warehouses, you could change your multi-cluster settings to add additional clusters to handle higher concurrency going forward.
upvoted 2 times
nintendogamer64
2 years, 6 months ago
source: https://docs.snowflake.com/en/user-guide/warehouses-load-monitoring.html#slow-query-performance
upvoted 2 times
...
...
SV1122
2 years, 6 months ago
This is interesting. A,B,D all 3 are correct according to https://docs.snowflake.com/en/user-guide/warehouses-load-monitoring.html#slow-query-performance
upvoted 1 times
Needium
2 years, 2 months ago
if queries execute faster, there will be lesser queries in the queue. moving to another virtual warehouse may be a temporary fix, but when it's a persistent problem then you should first scale out your virtual warehouse. If scaling out does not fully address the issue, you should consider scaling up as well
upvoted 1 times
...
...
halol
2 years, 7 months ago
Selected Answer: AB
https://docs.snowflake.com/en/user-guide/warehouses-load-monitoring.html#slow-query-performance
upvoted 2 times
...
Load full discussion...
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