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

• A.The validation_mode option is used when creating an Internal Stage
• B.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
• 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.validation_mode=return_all_errors is a parameter of the copy command

Comment: *

Name: *

Email: *

Verification: *

True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements would be used to export/unload data from Snowflake?

• A.COPY INTO @stage
• B.EXPORT TO @stage
• C.INSERT INTO @stage
• D.EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);

Comment: *

Name: *

Email: *

Verification: *

A user has unloaded data from a Snowflake table to an external stage.
Which command can be used to verify if data has been uploaded to the external stage named my_stage?

• A.show @my_stage
• B.display @my_stage
• C.view @my_stage
• D.list @my_stage

Comment: *

Name: *

Email: *

Verification: *

True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *