Font size
WorksheetsExam Prep 1
Total questions: 40
Worksheet time: 3hrs 20mins
Which commands can only be executed using SnowSQL? (Choose two.)
COPY INTO
GET
LIST
PUT
REMOVE
A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table.
What will the query from the view return?
The data from the permanent table.
The data from the temporary table.
An error stating that the view would not be compiled.
An error stating that the referenced object could not be uniquely identified.
Which Snowsight feature can be used to perform data manipulations and transformations using a programming language?
SnowSQL
Dashboards
Python worksheets
Provider Studio
Use of which Snowflake function is recommended when unloading data from a relational table into a JSON file?
TO_JSON
TO_VARIANT
OBJECT_INSERT
OBJECT_CONSTRUCT
What user setting can be configured to disable Multi-Factor Authentication (MFA) for a Snowflake user? (Choose two.)
DISABLE_MFA
MINS_TO_BYPASS_MFA
PASSWORD
MINS_TO_UNLOCK
MUST_CHANGE_PASSWORD
Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?
parse_json()
json_extract_path_text()
object_construct()
flatten
What computer language can be selected when creating User-Defined Functions (UDF) using the Snowpark API?
Swift
JavaScript
Python
SQL
How does a scoped URL expire?
When the data cache clears.
When the persisted query result period ends.
The encoded URL access is permanent.
The length of time is specified in the expiration_time argument.
When unloading data, which combination of parameters should be used to differentiate between empty strings and NULL values? (Choose two.)
ESCAPE_UNENCLOSED_FIELD
REPLACE_INVALID_CHARACTERS
FIELD_OPTIONALLY_ENCLOSED_BY
EMPTY_FIELD_AS_NULL
SKIP_BLANK_LINES
How does Snowflake enable OAuth?
By creating an external integration.
By configuring a security integration.
By establishing IP allowed lists and IP blocked lists.
By using SnowSQL to enable an external OAuth using the Snowflake protocol.
A JSON document is stored in the source_column of type VARIANT. The document has an array called elements. The array contains the name key that has a string value.
How can a Snowflake user extract the name from the first element?
source_column.elements[1]:name
source_column.elements[0]:name
source_column:elements[1].name
source_column:elements[0].name
The effects of query pruning can be observed by evaluating which statistics? (Choose two.)
Partitions scanned
Partitions total
Bytes scanned
Bytes read from result
Bytes written
Which statistics can be used to identify queries that have inefficient pruning? (Choose two.)
Bytes scanned
Bytes written to result
Partitions scanned
Partitions total
Percentage scanned from cache
Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?
OAuth
Network policies
Single Sign-On (SSO)
Multi-Factor Authentication (MFA)
What persistent data structures are used by the search optimization service to improve the performance of point lookups?
Micro-partitions
Clustering keys
Equality searches
Search access paths
What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?
Standard Edition
Enterprise Edition
Business Critical Edition
Virtual Private Snowflake Edition
A user has created a dashboard in Snowflake and wants to share it with colleagues.
How can the dashboard be shared?
By creating a private Data Exchange
By using the share option within Snowsight
By using a Direct Share with another account
By creating a listing on Snowflake Marketplace
Which ACCOUNT_USAGE schema database role provides visibility into policy-related information?
USAGE_VIEWER
GOVERNANCE_VIEWER
OBJECT_VIEWER
SECURITY_VIEWER
What is a directory table in Snowflake?
A separate database object that is used to store file-level metadata
An object layered on a stage that is used to store file-level metadata
A database object with grantable privileges for unstructured data tasks
A snowflake specifically designed for storing unstructured files
Which role has the ability to create and manage users and roles?
ORGADMIN
USERADMIN
SYSADMIN
SECURITYADMIN
What commands can be used to see what files are stored in a stage? (Choose two.)
LIST
SELECT
LS
GET
DESCRIBE
The MAXIMUM size for a serverless task run is equivalent to what size virtual warehouse?
Medium
Large
2X-Large
4X-Large
What does the client redirect feature in Snowflake enable?
A redirect of client connections to Snowflake accounts in the same regions for business continuity
A redirect of client connections to Snowflake accounts in different regions for business continuity
A redirect of client connections to Snowflake accounts in different regions for data replication
A redirect of client connections to Snowflake accounts in the same regions for data replication
What are the native data types that Snowflake provide to store semi-structured data? (Choose two.)
ARRAY
JSON
ORC
Parquet
VARIANT
Which statements describe benefits of Snowflake's separation of compute and storage? (Choose two.)
The separation allows independent scaling of computing resources
The separation ensures consistent data encryption across all virtual data warehouses
The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis
Storage volume growth and compute usage growth can be tightly coupled
Compute can be scaled up or down without the requirement to add more storage
Which URL provide access to files in Snowflake without authorization?
File URL
Scoped URL
Pre-signed URL
Scoped file URL
Which data types can be used in Snowflake to store semi-structured data? (Choose two.)
ARRAY
BLOB
CLOB
JSON
VARIANT
Which type of Snowflake virtual warehouse provides 16 times the memory for each node, and is recommended for larger workloads like Machine Learning (ML) training?
A size 6XL warehouse
A standard warehouse
A multi-cluster warehouse
A Snowpark-optimized warehouse
What is an advantage of using database roles instead of granting privileges on objects directly to a share in Snowflake?
Easier management of cross-region data sharing
Greater flexibility in including objects from multiple databases
More control over object-level access for different user groups
Reduction in the number of shares required for different objects in the same database
What transformations are supported when loading data into a table using the COPY INTO [table] command? (Choose two.)
Column reordering
Column omission
JOIN function
FLATTEN function
GROUP BY function
What function, combined with copy command, should be used to unload data from a relational table into a JSON file?
LATERAL
CAST
FLATTEN
OBJECT_CONSTRUCT
A JSON file that contains lots of dates and arrays needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data.
How can this be achieved?
Flatten the data and store it in structured data types in a flattened table. Query the table.
Store the data in a table with a VARIANT data type. Query the table.
Store the data in a table with a VARIANT data type and include STRIP_NULL_VALUES while loading the table. Query the table.
Store the data in an external stage and create views on top of it. Query the views.
Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?
Automatic clustering
Materialized views
Query acceleration service
Search optimization service
Which Snowflake feature supports continuous, serverless data loading into tables as soon as new data arrives?
Snowpark
SnowSQL
SnowCD
Snowpipe
Which URL type should be used to get a permanent URL to a file in a stage?
File URL
Pre-signed URL
Saved URL
Scoped URL
What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtual warehouse?
1
5
10
100
Which Snowflake feature or tool helps troubleshoot issues in SQL query expressions that commonly cause performance bottlenecks?
Persisted query results
QUERY_HISTORY view
Query acceleration service
Query Profile
The Snowflake Search Optimization Services supports improved performance of which kind of query?
Queries against large tables where frequent DML occurs
Queries against tables larger than 1 TB
Selective point lookup queries
Queries against a subset of columns in a table
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
Pipe
External stage
Task
Stream
Which command is used to remove files from either external cloud storage or an internal stage?
DELETE
REMOVE
TRUNCATE
DROP
