Snow2

What is the MAXIMUM Time Travel retention period for a transient table?

• 0 days

• 1 day

• 7 days

• 90 days

What is the advantage of using a reader account?

• It can be used by a client that does not have a Snowflake account

• It is read-only and prevents the shared data from being updated by the provider.

• It can be connected to a Snowflake account in a different region.

• It provides limited access to the data share and is therefore cheaper for the data provider.

What command is used to export or unload data from Snowflake?

• PUT @mystage

• GET @mystage

• Copy INTO @mystage

• INSERT @mystage

Which user object property requires contacting Snowflake Support in order to set a value for it?

• DISABLED

• MINS_TO_BYPASS MFA

• MINS_TO_BYPASS_NETWORK_POLICY

• MINS_TO_UNLOCK

When unloading data, which file formats are supported by the COPY INTO command? (Choose two.)

• Avro

• JSON

• ORC

• Parquet

• XML

A custom role owns multiple tables. If this role is dropped from the system, who becomes the owner of these tables?

• ACCOUNTADMIN

• SYSADMIN

• Tables will be standalone or orphaned.

• The role that dropped the custom role.

Which role can execute the SHOW ORGANIZATION ACCOUNTS command successfully?

• ACCOUNTADMIN

• SECURITYADMIN

• ORGADMIN

• USERADMIN

What is the default period of time the Warehouse Activity section provides a graph of Snowsight activity?

• 2 hours

• 1 week

• 2 weeks

• 1 month

What role is required to use Partner Connect?

• ACCOUNTADMIN

• ORGADMIN

• SECURITYADMIN

• SYSADMIN

What is the MOST efficient way to load streaming data into Snowflake?

• Use the COPY command.

• Use Snowpipe.

• Use the Load Data Wizard.

• Use tasks and streams.