SnowPro Core Certification — Question 149

Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no queries have been executed previously? (Choose three.)

Answer options

• A. MIN(<< column value >>)
• B. COPY
• C. SUM(<< column value >>)
• D. UPDATE

Correct answer: B, C, D

Explanation

The COPY, SUM, and UPDATE operations all require a Virtual Warehouse to process data and make modifications. In contrast, the MIN function simply retrieves a value from the existing data without needing computational resources from a Virtual Warehouse.