Snowpro Core · Free Practice Question Medium
Question 80
Which of the following will help reduce query queuing on a virtual warehouse?
Select two answers.
-
A
Suspend the warehouse often so that its memory is cleared.
-
B
If already using a multi-cluster virtual warehouse, increase the maximum number of clusters.
-
C
Enable Auto Resume.
-
D
Increase the size of the virtual warehouse.
-
E
Change the virtual warehouse to a multi-cluster virtual warehouse.
Reveal correct answers
Correct answers: B, E
Explanation
Queuing can be reduced in a variety of ways.
1) Consider creating additional virtual warehouses and distributing the query workload if using a standard virtual warehouse.
2) Convert a standard virtual warehouse to a multi-cluster virtual warehouse
3) If already using a multi-cluster virtual warehouse, increase the maximum cluster size.
https://docs.snowflake.com/en/user-guide/performance-query-warehouse-queue#options-for-reducing-queues
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
