
Answer-first summary for fast verification
Answer: COPY, SUM(<< column value >>), UPDATE
The question asks which operations require a Virtual Warehouse (VW) to be running, assuming no prior queries have been executed. Option B (COPY) requires a VW because it involves data loading operations that need compute resources. Option C (SUM(<< column value >>)) requires a VW as it performs aggregation on column data, which needs computational processing. Option D (UPDATE) requires a VW because it modifies data in tables, necessitating compute resources for execution. Option A (MIN(<< column value >>)) does not require a VW if the result can be served from the Global/Service layer cache, as noted in the community discussion (e.g., comment ID 706963 with 7 upvotes), which explains that MIN uses cache and thus eliminates A. The community consensus (100% for BCD) and multiple confirmations (e.g., comments from Sk1020, _yyukta) support B, C, and D as the correct answers, aligning with Snowflake best practices where compute-intensive operations rely on VWs.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.