Final answer:
When a virtual warehouse is resized to a larger size, the already executing queries are moved to the new servers and resumed executing. The new servers will execute queries in the queue. So, the correct options are likely A and C.
Step-by-step explanation:
When a virtual warehouse is resized to a LARGER size, the following may apply:
A. the already executing queries are suspended, moved to the new servers, and then resume executing: This is a possible scenario. Some systems may have the capability to suspend ongoing queries during the resizing process, move them to the new servers, and then allow them to continue.
B. the already executing queries are not shifted to the new servers: This is not a typical behavior. Resizing a virtual warehouse often involves redistributing workload, and ongoing queries may be affected as they are moved to the new servers.
C. the new servers will execute queries that are in the queue: This is a possible scenario. Once the virtual warehouse is resized to a larger size, the additional resources (new servers) may start executing queries that are in the queue, helping to process more queries concurrently.
So, the correct options are likely A and C.