SnowPro Core Certification — Question 235

Which of the following operations require the use of a running virtual warehouse? (Choose two.)

Answer options

• A. Downloading data from an internal stage
• B. Listing files in a stage
• C. Executing a stored procedure
• D. Altering a table
• E. Querying data from a materialized view

Correct answer: C, E

Explanation

The correct answers, C and E, require a running virtual warehouse because executing a stored procedure and querying data from a materialized view both involve compute resources. The other options can be performed without an active warehouse, as they do not require processing resources.