Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 647

Which SQL statement will require a virtual warehouse to run?

SELECT COUNT(*) FROM TBL_EMPLOYEE;

ALTER TABLE TBL_EMPLOYEE ADD COLUMN EMP_REGION VARCHAR(20);

INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1, 'Adam', 20000, 'Finance’);

CREATE OR REPLACE TABLE TBL_EMPLOYEE

(

EMP_ID NUMBER,

EMP_NAME VARCHAR(30),

EMP_SALARY NUMBER,

DEPT VARCHAR(20)

);

Correct Answer: C

A virtual warehouse in Snowflake is required to perform operations that involve processing and manipulating the actual data stored in tables. This includes DML (Data Manipulation Language) operations such as INSERT, UPDATE, DELETE, and SELECT statements that involve complex computations. The statement 'INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1, 'Adam', 20000, 'Finance’) introduces new data into the table and hence needs the computational resources provided by a virtual warehouse. Other statements such as SELECT COUNT(*) may retrieve metadata and hence may not always require a virtual warehouse.

Discussion

ukpinoOption: C

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>).

MultiCloudIronManOption: C

I think its C

RajivnbOption: C

This is correct. 'A' could be an answer because it has Count(*). This is a metadata value and will be picked from Cloud layer. It will not use Warehouse for this. The Answer is 'C'. Any DML operation required the Warehouse to take the data from Cloud layer to Storage layer.