Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no queries have been executed previously? (Choose three.)
Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no queries have been executed previously? (Choose three.)
Operations such as COPY, SUM, and UPDATE generally require a Virtual Warehouse because they involve actual computational work on the data. COPY is a data loading operation, SUM involves calculating the total of a column which is a computational task, and UPDATE modifies existing data. MIN might not require a Virtual Warehouse if the necessary data is available in the service layer cache.
B,C,D are the answers. Min uses the Global cache / Service layer cache, hence it does not require the WH to execute query. So, A can be eliminated from answers.
Was on exam Dec 31st 2022
correct answer
min is in the cache
Correct
BCD are correct
B,C,D are options