Answer: When loading data into a table, When unloading data from a table

According to Snowflake documentation and the community discussion with upvoted comments, a virtual warehouse is required for operations that need compute resources. Loading data into a table (B) using COPY INTO commands and unloading data from a table (C) using COPY INTO location commands both require compute resources and therefore need a running virtual warehouse. Creating a table (A) is a metadata operation that doesn't require a warehouse. SHOW (D) and LIST (E) commands are also metadata operations that don't require compute resources from a virtual warehouse.

Author: LeetQuiz Editorial Team