If all virtual warehouse resources are maximized while processing a query workload, what will happen to new queries that are submitted to the warehouse?
If all virtual warehouse resources are maximized while processing a query workload, what will happen to new queries that are submitted to the warehouse?
When all virtual warehouse resources are maximized while processing a query workload, new queries will be queued and executed when capacity is available. This means that the system will not terminate existing queries or go into a suspended state, nor will it automatically scale out. Instead, it will hold new queries in a queue until the necessary resources become available to process them.
D is correct
D is correct
Correct
D is correct
SO the keyword here maximized means MIN_CLUSTER_COUNT =MAX_CLUSTER_COUNT do the correct ans is D
key word here is MAXIMIZED, means that we are here now in Multicluster warehouse with same value for parameters MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT
D. New queries will be queued and executed when capacity is available.