Question 1

What metadata does Snowflake store concerning all rows stored in a micro-partition? (Select TWO).

• A. A count of the number of total values in the micro-partition
• B. The range of values for each partition in the micro-partition
• C. The range of values for each of the rows in the micro-partition
• D. The range of values for each of the columns in the micro-partition
• E. The number of distinct values for each column in the micro-partition

Question 2

Using which object-level parameters will help limit query processing and concurrency slowdowns?
(Select TWO).
A.

B.

C.

D.

E.

Question 3

Which statement will trigger a stream to advance its offset?

• A. DESCRIBE STREAM
• B. ALTER STREAM
• C. DROP STREM
• D. CREATE OR REPLACE STREAM

Question 4

What kind of value does a User-Defined Function (UDF) return? (Select TWO).

• A. Dictionary
• B. List
• C. Object
• D. Scalar
• E. Tabular

Question 5

What virtual warehouse feature or setting will reduce the performance impact when running larger-
than-average queries by offloading portions of the query processing work to shared compute
resources?

• A. Using a multi-cluster virtual warehouse
• B. Using the query acceleration service
• C. Using the search optimization service
• D. Disabling auto-suspend

Question 6

Which Snowflake feature enables loading data from cloud storage as soon as files ate available in a
stage?

• A. COPY_INTO <location> command
• B. Data replication
• C. Snowpipe
• D. Direct share

Question 7

What is the expiration period tor a file URL used to access unstructured data in cloud storage?

• A. The remainder of the session
• B. An unlimited amount of time
• C. The length of time specified in the expiration_time argument
• D. The same length of time as the expiration period for the query results cache

Question 8

Which Snowflake data governance feature supports resource usage monitoring?

• A. Data classification
• B. Column lineage
• C. Access history
• D. Object tagging

Question 9

When cloning a schema, which Snowflake object will not be included in the clone?

• A. An external stage
• B. A named internal stage
• C. A task
• D. A User-Defined Function (UDF)

Question 10

Which features can be used with the Snowflake Standard edition? (Select TWO).

• A. Materialized views
• B. External functions
• C. Multi-cluster virtual warehouses
• D. Fail-safe
• E. Row-level security

Question 11

Which privilege is required for a user to be able to view a resource monitor?

• A. USAGE
• B. SELECT
• C. MONITOR
• D. OPERATE

Question 12

A user creates a stage using the following command:

What will be the outcome?

• A. A stage with a directory table set to automatically refresh will be created.
• B. A stage with a directory table that has metadata that must be manually refreshed will be created.
• C. An error will be received stating that the storage location for the stage must be identified when creating a stage with a directory table.
• D. The command will fail to run because the name of the directory table is not specified.

Question 13

Why is a federated environment used for user authentication in Snowflake?

• A. To enhance data security and privacy
• B. To provide real-lime monitoring of user activities
• C. To separate user authentication from user access
• D. To enable direct integration with external databases

Question 14

What are valid values for the FIELD_OPTIONALLY_ENCLOSED_BY option in the copy into <location>
command used during data unloading? (Select TWO).

• A. Single quote character (')
• B. NULL
• C. 'NULL'
• D. NONE
• E. 'NONE'

Question 15

When will Snowflake charge credits for the use of the Cloud Services layer?

• A. Credits will be charged whenever the Cloud Services layer is used.
• B. Credits will be charged only when running a Snowflake-provisioned compute warehouse comfute_wh.
• C. Credits will be charged when the daily consumption of cloud services resources exceeds Wo of the daily warehouse usage.
• D. Credits will be charged only when a virtual warehouse consumes serverless compute services.