Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 351

Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

    Correct Answer: D, E

    In the Snowflake environment, virtual warehouse credits are consumed during activities that require compute resources. Running a custom query (such as SQL SELECT statements) involves performing operations that use CPU, memory, and temporary storage resources provided by the virtual warehouse, hence it consumes credits. Similarly, running COPY commands for loading data into tables or unloading data to a location also involves using these resources, thus consuming warehouse credits. Caching query results, running EXPLAIN and SHOW commands, and cloning databases do not consume virtual warehouse credits.

Discussion
SnowProCertDec22Options: DE

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

SV1122Options: DE

A warehouse provides the required resources, such as CPU, memory, and temporary storage, to perform the following operations in a Snowflake session: 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>). Note - To perform these operations, a warehouse must be running and in use for the session. While a warehouse is running, it consumes Snowflake credits. https://docs.snowflake.com/en/user-guide/warehouses.html

MultiCloudIronManOptions: DE

correct

fahfouhi94Options: DE

correct answer ===> DE