Topic 1: Exam pool A
A user has unloaded data from Snowflake to a stage. Which SQL command should be used to validate which data was loaded into the stage?
A.
list @file__stage
B.
show @file__stage
C.
view @file__stage
D.
verify @file__stage
list @file__stage
Query compilation occurs in which architecture layer of the Snowflake Cloud Data
Platform?
A.
Compute layer
B.
Storage layer
C.
Cloud infrastructure layer
D.
Cloud services layer
Compute layer
For query execution, Snowflake uses the Virtual Warehouse. The query
processing layer is separated from the disk storage layer in the Snowflake data
architecture. You can use the data from the storage layer to run queries in this layer: https://www.projectpro.io/article/snowflake-architecture-what-does-snowflakedo/556#:~:text=Query-Processing-Layer%2FCompute-Layer,run-queries-in-this-layer.
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
A.
ROLES
B.
POLICY_REFERENCES
C.
QUERY_HISTORY
D.
RESOURCE_MONIT ORS
E.
ACCESS_HISTORY
POLICY_REFERENCES
QUERY_HISTORY
https://docs.snowflake.com/en/user-guide/security-column-ddmintro.html#:~:text=DESCRIBE-MASKING-POLICY-,Auditing-Dynamic-Data-Masking,a-masking-policy-is-set.
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
A.
VARIANT
B.
ARRAY
C.
VARCHAR
D.
XML
E.
BLOB
VARIANT
ARRAY
Explanation: https://docs.snowflake.com/en/user-guide/semistructured-intro.html#labelloading-semi-structured-data
A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB. A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array.
What happens when an external or an internal stage is dropped? (Select TWO).
A.
When dropping an external stage, the files are not removed and only the stage is dropped
B.
When dropping an external stage, both the stage and the files within the stage are removed
C.
When dropping an internal stage, the files are deleted with the stage and the files are recoverable
D.
When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
E.
When dropping an internal stage, only selected files are deleted with the stage and are not recoverable
When dropping an external stage, the files are not removed and only the stage is dropped
When dropping an internal stage, the files are deleted with the stage and the files are recoverable
What is a limitation of a Materialized View?
A.
A Materialized View cannot support any aggregate functions
B.
A Materialized View can only reference up to two tables
C.
A Materialized View cannot be joined with other tables
D.
A Materialized View cannot be defined with a JOIN
A Materialized View cannot be defined with a JOIN
There are several limitations to using materialized views:
What Snowflake role must be granted for a user to create and manage accounts?
A.
ACCOUNTADMIN
B.
ORGADMIN
C.
SECURITYADMIN
D.
SYSADMIN
ACCOUNTADMIN
https://docs.snowflake.com/en/user-guide/security-access-controlconsiderations.
html
Which of the following describes how clustering keys work in Snowflake?
A.
Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.
B.
Clustering keys sort the designated columns over time, without blocking DML operations
C.
Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns
D.
Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time
Clustering keys sort the designated columns over time, without blocking DML operations
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
A.
Pipe
B.
External stage
C.
Task
D.
Stream
Pipe
Snowpipe enables loading data from files as soon as they’re available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches.
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
What features does Snowflake Time Travel enable?
A.
Querying data-related objects that were created within the past 365 days
B.
Restoring data-related objects that have been deleted within the past 90 days
C.
Conducting point-in-time analysis for Bl reporting
D.
Analyzing data usage/manipulation over all periods of time
Restoring data-related objects that have been deleted within the past 90 days
Snowflake Time Travel enables accessing historical data (i.e. data that has been changed or deleted) at any point within a defined period. It serves as a powerful tool for performing the following tasks:
https://docs.snowflake.com/en/user-guide/data-time-travel.html
| Page 7 out of 50 Pages |
| Previous |
Copyright © - All Rights Reserved