Two users share a virtual warehouse named WH_DEV_01. When one of the users loads data, the other one experiences performance issues while querying data.
How does Snowflake recommend resolving this issue?
A.
Scale up the existing warehouse
B.
Create separate warehouses for each user
C.
Create separate warehouses for each workload
D.
Stop loading and querying data at the same time
It's not waiting in queue, so additional warehouse is not required. It's facing performance issues , hence resizing the current warehouse " scaling up" should be right answer IMO. So , A is the answer.
When you notice that a query is running slowly, check whether an overloaded warehouse is causing the query to compete for resources or get queued:
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.
https://docs.snowflake.com/en/user-guide/warehouses-load-monitoring.html#slow-query-performance
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.
PrasantSadangi
1 month, 1 week agoMultiCloudIronMan
9 months, 2 weeks agoKarBiswa
1 year, 1 month agoEmiB
1 year, 1 month agoBigDataBB
1 year, 3 months agoAlexbDku
1 year, 4 months agoAndywu213
1 year, 4 months ago