Font size
WorksheetsExam Prep 2
Total questions: 20
Worksheet time: 2hrs 40mins
What is the MINIMUM Snowflake edition required to use the column-level security feature?
Standard
Enterprise
Business Critical
Virtual Private Snowflake (VPS)
What objects can be cloned within Snowflake? (Choose two.)
Schemas
Users
External tables
Internal named stages
External named stages
Which command should be used to generate a single file when unloading data from a Snowflake table into a file?
PARTITION BY
MAX_FILE_SIZE = 0
SINGLE = TRUE
OVERWRITE = TRUE
If a virtual warehouse runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, for how many seconds is it billed?
60
91
120
121
How can a data provider share their Snowflake data? (Choose two.)
External table
Snowpark API
Direct share
External function
Snowflake Marketplace listing
A Snowflake account has activated federated authentication.
What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?
The user will be unable to enter a password.
The user will encounter an error, and will not be able to log in.
The user will be able to log into Snowflake successfully.
After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.
What is the MINIMUM Snowflake edition that supports database replication?
Standard
Enterprise
Business Critical
Virtual Private Snowflake (VPS)
What are the possible values within a METADATA$ACTION column in a Snowflake stream? (Choose two.)
INSERT
UPDATE
DELETE
TRUNCATE
UPSERT
Which operation can be performed on Snowflake external tables?
INSERT
JOIN
RENAME
ALTER
Which Snowflake native tool can be used to diagnose and troubleshoot network connections?
SnowSQL
Snowflake Python connector
Snowsight
SnowCD
How does conditional data masking work in Snowflake?
It selectively masks plain text data.
It selectively masks multiple columns.
It masks all values in a given column.
It selectively masks a column value based on another column.
Which query types will have significant performance improvement when run using the search optimization service? (Choose two.)
Range searches
Equality searches
Substring searches
Queries with IN predicates
Queries with aggregation
A user wants to create objects within a schema but wants to restrict other users’ ability to grant privileges on these objects.
What configuration should be used to create the schema?
Use a regular (non-managed) schema.
Use a managed access schema.
Use a transient schema.
Set the Default_DDL_Collation parameter.
A user creates a stage using the following command:
CREATE STAGE mystage
DIRECTORY = (ENABLE = TRUE)
FILE_FORMAT = myformat;
What will be the outcome?
A stage with a directory table set to automatically refresh will be created.
A stage with a directory table that has metadata that must be manually refreshed will be created.
An error will be received stating that the storage location for the stage must be identified when creating a stage with a directory table.
The command will fail to run because the name of the directory table is not specified.
Which function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs, with a file URL that does not expire?
BUILD_SCOPED_FILE_URL
BUILD_STAGE_FILE_URL
GET_ABSOLUTE_PATH
GET_PRESIGNED_URL
What is the PRIMARY factor that determines the cost of using a virtual warehouse in Snowflake?
The type of SQL statements executed
The number of tables or databases queried
The amount of data stored in the warehouse
The length of time the compute resources in each cluster run
What is the purpose of the use of the VALIDATE command?
To view any queries that encountered an error
To verify that a SELECT query will run without error
To prevent a PUT statement from running if an error occurs
To see all errors from a previously run COPY INTO statement
Which security models are used in Snowflake to manage access control? (Choose two.)
Discretionary Access Control (DAC)
Identity Access Management (IAM)
Mandatory Access Control (MAC)
Role-Based Access Control (RBAC)
Security Assertion Markup Language (SAML)
Masking policies are created at what level in Snowflake?
Table
Column
Schema
Database
A column named “Data” contains VARIANT data and stores values as shown:
How will Snowflake extract the employee’s name from the column data?
