Where can a user find and review the failed logins of a specific user for the past 30 days?

• A.The LOGIN_HISTORY view in ACCOUNT_USAGE
• B.The USERS view in ACCOUNT_USAGE
• C.The ACCESS_HISTORY view in ACCOUNT_USAGE
• D.The SESSIONS view in ACCOUNT_USAGE

Comment: *

Name: *

Email: *

Verification: *

What is the purpose of the STRIP NULL_VALUES file format option when loading semi-structured data files into Snowflake?

• A.It removes null values from all columns in the data.
• B.It converts null values to empty strings during loading.
• C.It skips rows with null values during the loading process.
• D.It removes object or array elements containing null values.

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: *

What affects whether the query results cache can be used?

• A.If multiple users are using the same virtual warehouse
• B.If the referenced data in the table has changed
• C.If the query contains a deterministic function
• D.If the virtual warehouse has been suspended

Comment: *

Name: *

Email: *

Verification: *

If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

• A.16
• B.4
• C.8
• D.32

Comment: *

Name: *

Email: *

Verification: *