Worksheetssnow4
Total questions: 13
Worksheet time: 10mins
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
What is it called when a customer managed key is combined with a Snowflake managed key to create a composite key for encryption?
Hierarchical key model
Client-side encryption
Tri-secret secure encryption
Key pair authentication
What is the COPY INTO command option default for unloading data into multiple files?
SINGLE = 0
SINGLE = NULL
SINGLE = TRUE
SINGLE = FALSE
What is the impact of increasing the number of concurrent users on a Snowflake virtual warehouse?
Improved performance for small, simple queries
Improved performance for large, complex queries
Decreased performance for large, complex queries
Decreased consumption of Snowflake credits
