Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 981

For which use cases is running a virtual warehouse required? (Choose two.)

When creating a table

When loading data into a table

When unloading data from a table

When executing a SHOW command

When executing a LIST command

Correct Answer: B, C

Running a virtual warehouse is required when loading data into a table and when unloading data from a table. These operations involve significant compute resources, which necessitate the use of a virtual warehouse to handle the processing workload.

Discussion

Jordi204Options: BC

Executing SQL SELECT statements that require compute resources (e.g. retrieving rows from tables and views). Performing DML operations, such as: Updating rows in tables (DELETE , INSERT , UPDATE). Loading data into tables (COPY INTO <table>). Unloading data from tables (COPY INTO <location>).

tidzOptions: BC

https://docs.snowflake.com/en/user-guide/warehouses