When using SnowSQL, which configuration options are required when unloading data from a SQL query run on a local machine? {Select TWO).

• A.output_format
• B.echo
• C.quiet
• D.output_file
• E.force_put_overwrite

Comment: *

Name: *

Email: *

Verification: *

What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

• A.ACCESS_HISTORY
• B.OBJECT_HISTORY
• C.VIEWS_HISTORY
• D.LOGIN_HISTORY

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.8
• B.16
• C.4
• D.32

Comment: *

Name: *

Email: *

Verification: *

Which of the following can be used when unloading data from Snowflake? (Choose two.)

• A.By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.
• B.Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.
• C.Use the ENCODING file format option to change the encoding from the default UTF-8.
• D.The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.
• E.When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

Comment: *

Name: *

Email: *

Verification: *

Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

• A.grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;
• B.grant SELECT on future tables in database DB1 to role MYROLE;
• C.grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;
• D.grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;
• E.grant SELECT on all tables in database DB1 to role MYROLE;
• F.grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

Comment: *

Name: *

Email: *

Verification: *