Which permission on a Snowflake virtual warehouse allows the role to resize the warehouse?
A. ALTER
B. MODIFY
C. MONITOR
D. USAGE
Which Snowflake edition supports Protected Health Information (PHI) data (in accordance with HIPAA and HITRUST CSF regulations), and has a dedicated metadata store and pool of compute resources?
A. Standard
B. Enterprise
C. Business Critical
D. Virtual Private Snowflake (VPS)
When does Snowflake automatically encrypt data that is loaded into Snowflake? (Choose two.)
A. After the data is micro-partitioned.
B. After loading the data into a table.
C. After loading the data into an internal stage.
D. After loading data into an external stage.
E. Only when using an encrypted stage.
What columns are returned when performing a FLATTEN command on semi-structured data? (Choose two.)
A. KEY
B. NODE
C. VALUE
D. LEVEL
E. ROOT
Snowflake's approach to the management of system access combines which of the following models? (Choose two.)
A. Security Assertion Markup Language (SAML)
B. Role-Based Access Control (RBAC)
C. Identity Access Management (AM)
D. Create, Read, Update, and Delete (CRUD)
E. Discretionary Access Control (DAC)
F. Mandatory Access Control (MAC)
What role has the privileges to create and manage data shares by default?
A. ACCOUNTADMIN
B. SECURITYADMIN
C. SYSADMIN
D. USERADMIN
Which URL type should be used to get a permanent URL to a file in a stage?
A. File URL
B. Pre-signed URL
C. Saved URL
D. Scoped URL
Which of the following are best practices for loading data into Snowflake? (Choose three.)
A. Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
B. Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.
C. Enclose fields that contain delimiter characters in single or double quotes.
D. Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
E. When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
F. Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.
If a Snowflake user decides a table should be clustered, what should be used as the cluster key?
A. The columns that are queried in the select clause.
B. The columns with very high cardinality.
C. The columns with many different values.
D. The columns most actively used in the select filters.
Which of the following objects can be directly restored using the UNDROP command? (Choose two.)
A. Schema
B. View
C. Internal stage
D. Table
E. User
F. Role