snow4

In which Snowsight section can a user switch roles, modify their profile, and access documentation?

• The user menu

• The activity page

• The content pane

• The worksheets page

What is the recommended way to change the existing file format type in my_format from CSV to JSON?

• ALTER FILE FORMAT my_format SET TYPE=JSON;

• ALTER FILE FORMAT my_format SWAP TYPE WITH JSON;

• CREATE OR REPLACE FILE FORMAT my_format TYPE=JSON;

• REPLACE FILE FORMAT my_format TYPE=JSON;

What mechanisms can be used to inform Snowpipe that there are staged files available to load into a Snowflake table? (Choose two.)

• Cloud messaging

• Email integrations

• Error notifications

• REST endpoints

• Snowsight interactions

The MAXIMUM size for a serverless task run is equivalent to what size virtual warehouse?

• Medium

• Large

• 2X-Large

• 4X-Large

What storage cost is completely eliminated when a Snowflake table is defined as transient?

• Active

• Fail-safe

• Staged

• Time Travel

Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should be assigned to which role?

• ACCOUNTADMIN

• SECURITYADMIN

• SYSADMIN

• USERADMIN

What happens to the privileges granted to Snowflake system-defined roles?

• The privileges cannot be revoked.

• The privileges can be revoked by an ACCOUNTADMIN.

• The privileges can be revoked by an ORGADMIN.

• The privileges can be revoked by any user-defined role with appropriate privileges.

How does Snowflake improve the performance of queries that are designed to filter out a significant amount of data?

• The use of indexing

• The use of pruning

• The use of TableScan

• By increasing the number of partitions scanned

Which function should be used to insert JSON formatted string data into a VARIANT field?

• FLATTEN

• CHECK_JSON

• PARSE_JSON

• TO_VARIANT

Which permission on a Snowflake virtual warehouse allows the role to resize the warehouse?

• ALTER

• MODIFY

• MONITOR

• USAGE