Topic 1: Exam pool A
What is a best practice after creating a custom role?
A.
Create the custom role using the SYSADMIN role.
B.
Assign the custom role to the SYSADMIN role
C.
Assign the custom role to the PUBLIC role
D.
Add__CUSTOM to all custom role names
Assign the custom role to the SYSADMIN role
When creating roles that will serve as the owners of securable objects in the system, Snowflake recommends creating a hierarchy of custom roles, with the top-most custom role assigned to the system role SYSADMIN. This role structure allows system administrators to manage all objects in the account, such as warehouses and database objects, while restricting management of users and roles to the USERADMIN role.
What is the MOST performant file format for loading data in Snowflake?
A.
CSV (Unzipped)
B.
Parquet
C.
CSV (Gzipped)
D.
ORC
CSV (Unzipped)
Which feature is only available in the Enterprise or higher editions of Snowflake?
A.
Column-level security
B.
SOC 2 type II certification
C.
Multi-factor Authentication (MFA)
D.
Object-level access control
Column-level security
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
A.
A single join node uses more than 50% of the query time
B.
Partitions scanned is equal to partitions total
C.
An AggregateOperacor node is present
D.
The query is spilling to remote storage
The query is spilling to remote storage
How long is Snowpipe data load history retained?
A.
As configured in the create pipe settings
B.
Until the pipe is dropped
C.
64 days
D.
14 days
64 days
Bulk data load
Stored in the metadata of the target table for 64 days. Available upon completion of the COPY statement as the statement output.
https://docs.snowflake.com/en/user-guide/data-load-snowpipeintro.html#:~:text=Load-History,-Bulk-data-load&text=Stored-in-the-metadata-of,statement-as-the-statement-output.&text=Stored-in-the-metadata-of-the-pipe-for-14-days.
User-level network policies can be created by which of the following roles? (Select TWO).
A.
ROLEADMIN
B.
ACCOUNTADMIN
C.
SYSADMIN
D.
SECURITYADMIN
E.
USERADMIN
SECURITYADMIN
USERADMIN
By default, Snowflake allows users to connect to the service from any computer or device IP address. A security administrator (or higher) can create a network policy to allow or deny access to a single IP address or a list of addresses. Network policies currently support only Internet Protocol version 4 (i.e. IPv4) addresses. An administrator with sufficient permissions can create any number of network policies.
https://docs.snowflake.com/en/user-guide/networkpolicies.html#:~:text=A-security-administrator-(or-higher,any-number-of-network-policies.
What are value types that a VARIANT column can store? (Select TWO)
A.
STRUCT
B.
OBJECT
C.
BINARY
D.
ARRAY
E.
CLOB
OBJECT
ARRAY
Characteristics of a VARIANT
A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.
https://docs.snowflake.com/en/sql-reference/data-typessemistructured.html#:~:text=VARIANT-,Characteristics-of-a-VARIANT,a-VARIANT-is-16-MB.
What is a responsibility of Snowflake's virtual warehouses?
A.
Infrastructure management
B.
Metadata management
C.
Query execution
D.
Query parsing and optimization
E.
Management of the storage layer
Query execution
Which Snowflake partner specializes in data catalog solutions?
A.
Alation
B.
DataRobot
C.
dbt
D.
Tableau
Alation
Alation provides Data Cataloging functionality. They state they are the 'One Place to Find, Understand, & Govern Data Across an Enterprise.
https://docs.snowflake.com/en/user-guide/ecosystem-all.html
A user has an application that writes a new Tile to a cloud storage location every 5 minutes. What would be the MOST efficient way to get the files into Snowflake?
A.
Create a task that runs a copy into operation from an external stage every 5 minutes
B.
Create a task that puts the files in an internal stage and automate the data loading wizard
C.
Create a task that runs a GET operation to intermittently check for new files
D.
Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest
Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html