Which resource monitor setting will cancel all active queries in a virtual warehouse when the threshold is met?

• A.NOTIF
• B.SUSPEND_IMMEDIATE
• C.NOTIFY_USERS
• D.SUSPEND

Comment: *

Name: *

Email: *

Verification: *

Which SQL statement will require a virtual warehouse to run?

• A.SELECT COUNT{*) FROM TBL_EMPLOYEE;
• B.ALTER TABLE TBL_EMPLOYEE ADD COLUMN EMP_REGI0N 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));

Comment: *

Name: *

Email: *

Verification: *

Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

• A.ORC
• B.XML
• C.Avro
• D.Parquet
• E.JSON

Comment: *

Name: *

Email: *

Verification: *

What compute resource is used when loading data using Snowpipe?

• A.Snowpipe uses virtual warehouses provided by the user.
• B.Snowpipe uses an Apache Kafka server for its compute resources.
• C.Snowpipe uses compute resources provided by Snowflake.
• D.Snowpipe uses cloud platform compute resources provided by the user.

Comment: *

Name: *

Email: *

Verification: *

The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

• A.USERADMIN
• B.PUBLIC
• C.ORGADMIN
• D.SYSADMIN

Comment: *

Name: *

Email: *

Verification: *