SnowPro Core Certification — Question 626

Which SQL statement will require a virtual warehouse to run?

Answer options

• A. SELECT COUNT(*) FROM TBL_EMPLOYEE;
• B. ALTER TABLE TBL_EMPLOYEE ADD COLUMN EMP_REGION VARCHAR(20);
• C. INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1, 'Adam', 20000, 'Finance’);
• D. CREATE OR REPLACE TABLE TBL_EMPLOYEE ( EMP_ID NUMBER, EMP_NAME VARCHAR(30), EMP_SALARY NUMBER, DEPT VARCHAR(20) );

Correct answer: C

Explanation

The correct answer is C because executing an INSERT statement requires a compute resource, which is provided by a virtual warehouse. Options A, B, and D are either read operations or schema modifications that do not necessitate the immediate allocation of a virtual warehouse.