Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

• A.The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
• B.validation_mode=return_all_errors is a parameter of the copy command
• C.The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
• D.The validation_mode option is used when creating an Internal Stage

Comment: *

Name: *

Email: *

Verification: *

Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):

• A.SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
• B.ACCOUNTADMIN
• C.SECURITYADMIN ACCOUNTADMIN, SYSADMIN
• D.SECURITYADMIN, ACCOUNTADMIN

Comment: *

Name: *

Email: *

Verification: *

Which formats are supported for unloading data from Snowflake? Choose 2 answers

• A.ORC
• B.JSON
• C.Delimited (CSV, TSV, etc.)
• D.Avro

Comment: *

Name: *

Email: *

Verification: *

Which of the following objects can be cloned? (Choose four.)

• A.Users
• B.Shares
• C.Databases
• D.Schemas
• E.Named File Formats
• F.Tables

Comment: *

Name: *

Email: *

Verification: *

Which of the following DML commands isn't supported by Snowflake?

• A.TRUNCATE TABLE
• B.UPDATE
• C.UPSERT
• D.MERGE

Comment: *

Name: *

Email: *

Verification: *