Snow16

The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

• Users

• Tables

• Databases

• Internal Stages

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

• parse_json()

• json_extract_path_text()

• object_construct()

• flatten

What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

• Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 30 days. Fail Safe retention time is 1 day.

• Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 365 days. Fail Safe retention time is 7 days.

• Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.

• Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.

• Default Time Travel Retention is set to 7 days. Maximum Time Travel Retention is 1 day. Fail Safe retention time is 90 days.

Which Snowflake feature is used for both querying and restoring data?

• Cluster keys

• Time Travel

• Fail-safe

• Cloning

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

• Configure the Maximum Clusters setting to ‘Auto-Scale’

• Set the Warehouse type to ‘Auto’

• Set the Minimum Clusters and Maximum Clusters settings to the same value

• Set the Minimum Clusters and Maximum Clusters settings to the different values

Which of the following roles is recommended to be used to create and manage users and roles?

• SYSADMIN

• SECURITYADMIN

• PUBLIC

• ACCOUNTADMIN

Which Snowflake table supports unstructured data?

• Directory

• Transient

• Temporary

• Permanent

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

• The tables are now orphaned

• The user that deleted the role

• SYSADMIN

• The assumed role that dropped the role

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

• Named File Formats

• Schemas

• Shares

• Databases

• Users

As a best practice, clustering keys should only be defined on tables of which minimum size?

• Multi-Kilobyte (KB) Range

• Multi-Megabyte (MB) Range

• Multi-Gigabyte (GB) Range

• Multi-Terabyte (TB) Range