Winter Sale Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ex2p65

Exact2Pass Menu

Question # 4

Snowflake users can create a resource monitor at which levels? (Select TWO).

A.

User level

B.

Pipe level

C.

Account level

D.

Cloud services level

E.

Virtual warehouse level

Full Access
Question # 5

What happens to the privileges granted to Snowflake system-defined roles?

A.

The privileges cannot be revoked.

B.

The privileges can be revoked by an ACCOUNTADMIN.

C.

The privileges can be revoked by an orgadmin.

D.

The privileges can be revoked by any user-defined role with appropriate privileges.

Full Access
Question # 6

Which process does Snowflake follow when a stored procedure with owner's rights is called within a session?

A.

The procedure will be run with the privileges of the caller.

B.

The owner can set the caller's session variables.

C.

The owner will inherit the caller's current virtual warehouse.

D.

The owner can view the caller's session variables.

Full Access
Question # 7

What does Snowflake attempt to do if any of the compute resources for a virtual warehouse fail to provision during start-up?

A.

Repair the failed resources.

B.

Restart failed resources.

C.

Queue the failed resources

D.

Provision the failed resources

Full Access
Question # 8

Which governance feature is supported by all Snowflake editions?

A.

Object tags

B.

Masking policies

C.

Row access policies

D.

OBJECT_DEPENDENCIES View

Full Access
Question # 9

Which Snowflake table type is only visible to the user who creates it, can have the same name as permanent tables in the same schema, and is dropped at the end of the session?

A.

Temporary

B.

Local

C.

User

D.

Transient

Full Access
Question # 10

Which Snowflake native tool can be used to diagnose and troubleshoot network connections?

A.

SnowSQL

B.

Snowflake Python connector

C.

Snowsight

D.

SnowCD

Full Access
Question # 11

What is a non-configurable feature that provides historical data that Snowflake may recover during a 7-day period?

A.

Fail-safe

B.

Time Travel

C.

Cloning

D.

Account replication

Full Access
Question # 12

What are supported file formats for unloading data from Snowflake? (Choose three.)

A.

XML

B.

JSON

C.

Parquet

D.

ORC

E.

AVRO

F.

CSV

Full Access
Question # 13

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

A.

Removing a column from the query SELECT list

B.

Stopping the virtual warehouse that the query is running against

C.

Clustering of the data used by the query

D.

Executing the RESULTS_SCAN() table function

E.

Changing a column that is not in the cached query

Full Access
Question # 14

When creating a file format to load JSON data into Snowflake. what command will remove brackets ([ ]) from the data?

A.

STRIP_NULL_VALUES - TRUE

B.

REPLACE_INVALID_CHARACTERS = TRUE

C.

TRIM_SPACE = TRUE

D.

STRIP OUTER ARRAY = TRUE

Full Access
Question # 15

Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

A.

VARIANT

B.

VARRAY

C.

STRUCT

D.

ARRAY

E.

QUEUE

Full Access
Question # 16

Which minimum Snowflake edition allows for a dedicated metadata store?

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake

Full Access
Question # 17

Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

A.

Data is live, ready-to-query, and can be personalized.

B.

Data needs to be loaded into a cloud provider as a consumer account.

C.

Data is not available for copying or moving to an individual Snowflake account.

D.

Data is available without copying or moving.

E.

Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.

Full Access
Question # 18

When does a materialized view get suspended in Snowflake?

A.

When a column is added to the base table

B.

When a column is dropped from the base table

C.

When a DML operation is run on the base table

D.

When the base table is reclustered

Full Access
Question # 19

What causes objects in a data share to become unavailable to a consumer account?

A.

The DATA_RETENTI0N_TIME_IN_DAYS parameter in the consumer account is set to 0.

B.

The consumer account runs the GRANT IMPORTED PRIVILEGES command on the data share every 24 hours.

C.

The objects in the data share are being deleted and the grant pattern is not re-applied systematically.

D.

The consumer account acquires the data share through a private data exchange.

Full Access
Question # 20

Which command allows a user to unload data from a Snowflake database table into one or more files in a Snowflake or external stage?

A.

GET

B.

LIST

C.

PUT

D.

COPY INTO

Full Access
Question # 21

What are common issues found by using the Query Profile? (Choose two.)

A.

Identifying queries that will likely run very slowly before executing them

B.

Locating queries that consume a high amount of credits

C.

Identifying logical issues with the queries

D.

Identifying inefficient micro-partition pruning

E.

Data spilling to a local or remote disk

Full Access
Question # 22

How can a Snowsight user change a Standard virtual warehouse to a Snowpark-optimized virtual warehouse?

A.

Use the ALTER WAREHOUSE command on an active Standard virtual warehouse

B.

Use the alter warehouse command on an active Snowpark-optimized warehouse.

C.

Use the ALTER warehouse command on a suspended Standard virtual warehouse.

D.

Use the ALTER WAREHOUSE command on a suspended Snowpark-optimized warehouse.

Full Access
Question # 23

A user needs to know the maximum value of a date field in a table, and runs the following query:

....part of Snowflake architecture wilt this query use?

A.

Database Storage

B.

Query Processing

C.

Cloud Services

D.

Compute

Full Access
Question # 24

Which function determines the kind of value stored in a VARIANT column?

A.

CHECK_JSON

B.

IS_ARRAY

C.

IS_JSON

D.

TYPEOF

Full Access
Question # 25

If a JOIN operation is based on two columns which both contain NULL values, what SQL function will return results?

A.

An NVL function used to change the NULL values to another value

B.

An equal_null function

C.

A NULLIF function

D.

An I FNULL function used to change the NULL values to another value

Full Access
Question # 26

What Snowflake objects or services can be used to automatically load data from files as soon as. They are available in an external staged (Select TWO).

A.

Stream

B.

Snowpipe

C.

Task

D.

Directory table

E.

User-Defined Function (UDF)

Full Access
Question # 27

Which network policy has the HIGHEST precedence?

A.

Security Integration

B.

Account

C.

Database

D.

User

Full Access
Question # 28

While unloading data into a stage, how can the user ensure that the output will be a single file?

A.

Use the copy option files=single.

B.

Use the COPY Option SINGLE=TRUE .

C.

Use the get option SINGLE-TRUE.

D.

Use the GET option FILES-SINGLE.

Full Access
Question # 29

Which drivers or connectors are supported by Snowflake? (Select TWO)

A.

Perl Connector

B.

MongoDB Rust Driver

C.

Go Snowflake Driver

D.

Cobol Driver

E.

Snowflake Connector for Python

Full Access
Question # 30

Which type of role can be granted to a share?

A.

Account role

B.

Custom role

C.

Database role

D.

Secondary role

Full Access
Question # 31

Which object can be shared using Secure Data Sharing?

A.

Secure view

B.

Materialized view

C.

Externa! function

D.

User-Defined Function (UDF)

Full Access
Question # 32

Which privilege grants the ability to set a column-level security masking policy on a table or view column?

A.

APPLY

B.

CREATE

C.

SET

D.

MODIFY

Full Access
Question # 33

Which Snowflake governance feature allows users to assign metadata labels to improve data governance and database access control?

A.

Secure functions

B.

Secure views

C.

Object tagging

D.

Row-level security

Full Access
Question # 34

How can the Query Profile be used to troubleshoot a problematic query?

A.

It will indicate if a virtual warehouse memory is too small to run the query

B.

It will indicate if a user lacks the privileges needed to run the query.

C.

It will indicate if a virtual warehouse is in auto-scale mode

D.

It will indicate if the user has enough Snowflake credits to run the query

Full Access
Question # 35

How does Snowflake utilize clustering information to improve query performance?

A.

It prunes unnecessary micro-partitions based on clustering metadata.

B.

It compresses the data within micro-partitions for faster querying.

C.

It automatically allocates additional resources to improve query execution.

D.

It organizes clustering information to speed-up data retrieval from storage

Full Access
Question # 36

When working with table MY_TABLE that contains 10 rows, which sampling query will always return exactly 5 rows?

A.

SELECT * FROM MY_TABLE SAMPLE SYSTEM (5);

B.

SELECT * FROM MY_TABLE SAMPLE BERNOULLI (5);

C.

SELECT * FROM MY_TABLE SAMPLE (5 ROWS);

D.

SELECT * FROM MY_TABLE SAMPLE SYSTEM (1) SEED (5);

Full Access
Question # 37

What are the main differences between the account usage views and the information schema views? (Select TWO).

A.

No active warehouse to needed to query account usage views but one is needed to query information schema views.

B.

Account usage views do not contain data about tables but information schema views do.

C.

Account issue views contain dropped objects but information schema views do not.

D.

Data retention for account usage views is 1 year but is 7 days to 6 months for information schema views, depending on the view.

E.

Information schema views are read-only but account usage views are not.

Full Access
Question # 38

What actions can be performed by a consumer account on a shared database? (Select TWO).

A.

Cloning a shared table

B.

Modifying the data in a shared table

C.

Using Time Travel on a shared table

D.

Executing the select statement on a shared table

E.

Joining the data from a shared table with another table

Full Access
Question # 39

What Snowflake recommendation is designed to ensure that staged data is only loaded once"?

A.

Partitioning staged data files

B.

Loading only the most recently-staged data files

C.

Removing data files after loading

D.

Identifying and removing duplicates after each data load

Full Access
Question # 40

Which Snowflake object can be used to record DML changes made to a table?

A.

Snowpipe

B.

Stage

C.

Stream

D.

Task

Full Access
Question # 41

What is the MAXIMUM data retention period of transient databases when using the Snowflake Enterprise edition?

A.

1 day

B.

7 days

C.

30 days

D.

90 days

Full Access
Question # 42

Which function can be used with the copy into statement to convent rows from a relational table to a single variant column, and to unload rows into a JSON file?

A.

FLATTEN

B.

OBJECT_AS

C.

OBJECT_CONSTRUCT

D.

TO VARIANT

Full Access
Question # 43

How does the authorization associated with a pre-signed URL work tor an unstructured file?

A.

Anyone who has the URL can access the referenced file for the life of the token.

B.

Only the user who generates the URL can use the URL to access the referenced file.

C.

Only the users who have roles with sufficient privileges on the URL can access the referenced file.

D.

The role specified in the GET REST API call must have sufficient privileges on the stage to access the referenced file using the URL.

Full Access
Question # 44

The Snowflake Cloud Data Platform is described as having which of the following architectures?

A.

Shared-disk

B.

Shared-nothing

C.

Multi-cluster shared data

D.

Serverless query engine

Full Access
Question # 45

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

A.

SELECT SUM (ORDER_AMT) FROM SALES;

B.

SELECT AVG(ORDER_QTY) FROM SALES;

C.

SELECT MIN(ORDER_AMT) FROM SALES;

D.

SELECT ORDER_AMT * ORDER_QTY FROM SALES;

Full Access
Question # 46

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

A.

Reader

B.

Consumer

C.

Vendor

D.

Standard

E.

Personalized

Full Access
Question # 47

Which of the following statements apply to Snowflake in terms of security? (Choose two.)

A.

Snowflake leverages a Role-Based Access Control (RBAC) model.

B.

Snowflake requires a user to configure an IAM user to connect to the database.

C.

All data in Snowflake is encrypted.

D.

Snowflake can run within a user's own Virtual Private Cloud (VPC).

E.

All data in Snowflake is compressed.

Full Access
Question # 48

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

A.

Schema

B.

View

C.

Internal stage

D.

Table

E.

User

F.

Role

Full Access
Question # 49

What is the purpose of multi-cluster virtual warehouses?

A.

To create separate data warehouses to increase query optimization

B.

To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster

C.

To eliminate or reduce Queuing of concurrent queries

D.

To allow the warehouse to resize automatically

Full Access
Question # 50

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

A.

Whether or not it is also a secure view

B.

How often the underlying base table is queried

C.

How often the base table changes

D.

Whether the materialized view has a cluster key defined

E.

How often the materialized view is queried

Full Access
Question # 51

Which task is supported by the use of Access History in Snowflake?

A.

Data backups

B.

Cost monitoring

C.

Compliance auditing

D.

Performance optimization

Full Access
Question # 52

What affects whether the query results cache can be used?

A.

If the query contains a deterministic function

B.

If the virtual warehouse has been suspended

C.

If the referenced data in the table has changed

D.

If multiple users are using the same virtual warehouse

Full Access
Question # 53

What is the maximum Time Travel retention period for a temporary Snowflake table?

A.

90 days

B.

1 day

C.

7 days

D.

45 days

Full Access
Question # 54

What is the minimum Snowflake edition that has column-level security enabled?

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake

Full Access
Question # 55

What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

A.

Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.

B.

Scaling out adds clusters of varying sizes to a virtual warehouse.

C.

Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.

D.

Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.

E.

Scaling up resizes a virtual warehouse so it can handle more complex workloads.

F.

Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

Full Access
Question # 56

Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

A.

CONTENT

B.

PATH

C.

BYTE_SIZE

D.

INDEX

E.

DATATYPE

Full Access
Question # 57

Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

A.

Amazon Web Services

B.

Docker

C.

IBM Cloud

D.

Microsoft Azure Cloud

E.

Google Cloud Platform

F.

Oracle Cloud

Full Access
Question # 58

Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

A.

Database replication and failover

B.

Automated index management

C.

Customer managed keys (Tri-secret secure)

D.

Extended time travel

E.

Native support for geospatial data

Full Access
Question # 59

What is true about sharing data in Snowflake? (Choose two.)

A.

The Data Consumer pays for data storage as well as for data computing.

B.

The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

C.

A Snowflake account can both provide and consume shared data.

D.

The Provider is charged for compute resources used by the Data Consumer to query the shared data.

E.

The Data Consumer pays only for compute resources to query the shared data.

Full Access
Question # 60

Network policies can be set at which Snowflake levels? (Choose two.)

A.

Role

B.

Schema

C.

User

D.

Database

E.

Account

F.

Tables

Full Access
Question # 61

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

A.

SHOW GRANTS OF ROLE MY_ROLE

B.

SHOW GRANTS TO ROLE MY_ROLE

C.

SHOW GRANTS FOR ROLE MY_ROLE

D.

SHOW GRANTS ON ROLE MY_ROLE

Full Access
Question # 62

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

A.

Tri-Secret Secure

B.

Time Travel

C.

Fail-safe

D.

Data encryption

E.

External stages

Full Access
Question # 63

A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.

Which Snowflake feature will support this?

A.

Row access policies

B.

Data masking policies

C.

Data encryption

D.

Role based access control

Full Access
Question # 64

What COPY INTO SQL command should be used to unload data into multiple files?

A.

SINGLE=TRUE

B.

MULTIPLE=TRUE

C.

MULTIPLE=FALSE

D.

SINGLE=FALSE

Full Access
Question # 65

Which of the following statements describe features of Snowflake data caching? (Choose two.)

A.

When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

B.

When the data cache is full, the least-recently used data will be cleared to make room.

C.

A user can only access their own queries from the query result cache.

D.

A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

E.

The RESULT_SCAN table function can access and filter the contents of the query result cache.

Full Access
Question # 66

What is the only supported character set for loading and unloading data from all supported file formats?

A.

UTF-8

B.

UTF-16

C.

ISO-8859-1

D.

WINDOWS-1253

Full Access
Question # 67

Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

A.

PUT

B.

GET

C.

COPY

D.

SELECT

Full Access
Question # 68

A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.

How can this requirement be met?

A.

Use data encryption.

B.

Use dynamic data masking.

C.

Use secure materialized views.

D.

Revoke all roles for functional managers and end users.

Full Access
Question # 69

Why would a Snowflake user decide to use a materialized view instead of a regular view?

A.

The base tables do not change frequently.

B.

The results of the view change often.

C.

The query is not resource intensive.

D.

The query results are not used frequently.

Full Access
Question # 70

Which command sets the Virtual Warehouse for a session?

A.

COPY WAREHOUSE FROM <>;

B.

SET WAREHOUSE = <>;

C.

USE WAREHOUSE <>;

D.

USE VIRTUAL_WAREHOUSE <>;

Full Access
Question # 71

Which of the following are best practices for loading data into Snowflake? (Choose three.)

A.

Aim to produce data files that are between 100 MB and 250 MB in size, compressed.

B.

Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.

C.

Enclose fields that contain delimiter characters in single or double quotes.

D.

Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

E.

When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.

F.

Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

Full Access
Question # 72

In the Snowflake access control model, which entity owns an object by default?

A.

The user who created the object

B.

The SYSADMIN role

C.

Ownership depends on the type of object

D.

The role used to create the object

Full Access
Question # 73

In a Snowflake role hierarchy, what is the top-level role?

A.

SYSADMIN

B.

ORGADMIN

C.

ACCOUNTADMIN

D.

SECURITYADMIN

Full Access
Question # 74

A virtual warehouse is created using the following command:

Create warehouse my_WH with

warehouse_size = MEDIUM

min_cluster_count = 1

max_cluster_count = 1

auto_suspend = 60

auto_resume = true;

The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

A.

Increase the warehouse size from Medium to 2XL.

B.

Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

C.

Configure the warehouse to a multi-cluster warehouse.

D.

Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Full Access
Question # 75

When cloning a database, what is cloned with the database? (Choose two.)

A.

Privileges on the database

B.

Existing child objects within the database

C.

Future child objects within the database

D.

Privileges on the schemas within the database

E.

Only schemas and tables within the database

Full Access
Question # 76

Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

A.

Materialized view

B.

Sequence

C.

Secure view

D.

Transient table

E.

Clustered table

Full Access
Question # 77

Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

A.

External Tokenization

B.

External Tables

C.

Materialized Views

D.

User-Defined Table Functions (UDTF)

Full Access
Question # 78

Which services does the Snowflake Cloud Services layer manage? (Choose two.)

A.

Compute resources

B.

Query execution

C.

Authentication

D.

Data storage

E.

Metadata

Full Access
Question # 79

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

A.

Use the DROP command after the load completes.

B.

Specify the TEMPORARY option when creating the file format.

C.

Specify the PURGE copy option in the COPY INTO

command.

D.

Use the REMOVE command after the load completes.

E.

Use the DELETE LOAD HISTORY command after the load completes.

Full Access
 command, which will automatically delete the files after they have been successfully loaded. Additionally, you can use the REMOVE command after the load completes to manually delete the files from the stage12.

References = DROP STAGE, REMOVE

Question # 80

Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

A.

Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.

B.

The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.

C.

SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.

D.

A user cannot specify a default warehouse when using the ODBC driver.

E.

The default virtual warehouse size can be changed at any time.

Full Access
Question # 81

How does Snowflake Fail-safe protect data in a permanent table?

A.

Fail-safe makes data available up to 1 day, recoverable by user operations.

B.

Fail-safe makes data available for 7 days, recoverable by user operations.

C.

Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.

D.

Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

Full Access
Question # 82

Which view can be used to determine if a table has frequent row updates or deletes?

A.

TABLES

B.

TABLE_STORAGE_METRICS

C.

STORAGE_DAILY_HISTORY

D.

STORAGE USAGE

Full Access
Question # 83

How does Snowflake describe its unique architecture?

A.

A single-cluster shared data architecture using a central data repository and massively parallel processing (MPP)

B.

A multi-duster shared nothing architecture using a soloed data repository and massively parallel processing (MPP)

C.

A single-cluster shared nothing architecture using a sliced data repository and symmetric multiprocessing (SMP)

D.

A multi-cluster shared nothing architecture using a siloed data repository and symmetric multiprocessing (SMP)

Full Access
Question # 84

What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?

A.

View

B.

Secure view

C.

Materialized view

D.

External table

Full Access
Question # 85

What are characteristics of reader accounts in Snowflake? (Select TWO).

A.

Reader account users cannot add new data to the account.

B.

Reader account users can share data to other reader accounts.

C.

A single reader account can consume data from multiple provider accounts.

D.

Data consumers are responsible for reader account setup and data usage costs.

E.

Reader accounts enable data consumers to access and query data shared by the provider.

Full Access
Question # 86

Which function is used to convert rows in a relational table to a single VARIANT column?

A.

ARRAY_AGG

B.

OBJECT_AGG

C.

ARRAY_CONSTRUCT

D.

OBJECT_CONSTRUCT

Full Access
Question # 87

How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?

A.

A single executable statement can call only two stored procedures. In contrast, a single SQL statement can call multiple UDFs.

B.

A single executable statement can call only one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

C.

A single executable statement can call multiple stored procedures. In contrast, multiple SQL statements can call the same UDFs.

D.

Multiple executable statements can call more than one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

Full Access
Question # 88

Which URL provides access to files in Snowflake without authorization?

A.

File URL

B.

Scoped URL

C.

Pre-signed URL

D.

Scoped file URL

Full Access
Question # 89

Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?

A.

Caching

B.

Cluster depth

C.

Query pruning

D.

Retrieval optimization

Full Access
Question # 90

A Snowflake user is writing a User-Defined Function (UDF) that includes some unqualified object names.

How will those object names be resolved during execution?

A.

Snowflake will resolve them according to the SEARCH_PATH parameter.

B.

Snowflake will only check the schema the UDF belongs to.

C.

Snowflake will first check the current schema, and then the schema the previous query used

D.

Snowflake will first check the current schema, and them the PUBLIC schema of the current database.

Full Access
Question # 91

Which command can be used to list all the file formats for which a user has access privileges?

A.

LIST

B.

ALTER FILE FORMAT

C.

DESCRIBE FILE FORMAT

D.

SHOW FILE FORMATS

Full Access
Question # 92

Which common query problems are identified by the Query Profile? (Select TWO.)

A.

Syntax error

B.

Inefficient pruning

C.

Ambiguous column names

D.

Queries too large to fit in memory

E.

Object does not exist or not authorized

Full Access
Question # 93

While clustering a table, columns with which data types can be used as clustering keys? (Select TWO).

A.

BINARY

B.

GEOGRAPHY

C.

GEOMETRY

D.

OBJECT

E.

VARIANT

Full Access
Question # 94

Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).

A.

Binary file in Avro

B.

Binary file in Parquet

C.

Comma-separated JSON

D.

Newline Delimited JSON

E.

Plain text file containing XML elements

Full Access
Question # 95

When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?

A.

(12,2)

B.

(10,4)

C.

(14,8)

D.

(15,9)

Full Access
Question # 96

By default, which role has access to the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function?

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSADMIN

D.

ORGADMIN

Full Access
Question # 97

If a virtual warehouse runs for 61 seconds, shut down, and then restart and runs for 30 seconds, for how many seconds is it billed?

A.

60

B.

91

C.

120

D.

121

Full Access
Question # 98

When using the ALLOW_CLI£NT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?

A.

1 hour

B.

2 hours

C.

4 hours

D.

8 hours

Full Access
Question # 99

Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?

A.

The column name and element names are both case-sensitive.

B.

The column name and element names are both case-insensitive.

C.

The column name is case-sensitive but element names are case-insensitive.

D.

The column name is case-insensitive but element names are case-sensitive.

Full Access
Question # 100

How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?

A.

60 minutes

B.

24 hours

C.

14 days

D.

30 days

Full Access
Question # 101

What activities can a user with the ORGADMIN role perform? (Select TWO).

A.

Create an account for an organization.

B.

Edit the account data for an organization.

C.

Delete the account data for an organization.

D.

View usage information for all accounts in an organization.

E.

Select all the data in tables for all accounts in an organization.

Full Access
Question # 102

There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production. How can data be easily transferred from the production account to the non-production account?

A.

Clone the data from the production account to the non-production account.

B.

Create a data share from the production account to the non-production account.

C.

Create a subscription in the production account and have it publish to the non-production account.

D.

Create a reader account using the production account and link the reader account to the non-production account.

Full Access
Question # 103

What information does the Query Profile provide?

A.

Graphical representation of the data model

B.

Statistics for each component of the processing plan

C.

Detailed Information about I he database schema

D.

Real-time monitoring of the database operations

Full Access
Question # 104

What does the TableScan operator represent in the Query Profile?

A.

The access to a single table

B.

The access to data stored in stage objects

C.

The list of values provided with the VALUES clause

D.

The records generated using the TABLE (GENERATOR (...)) construct

Full Access
Question # 105

Which command should be used to unload all the rows from a table into one or more files in a named stage?

A.

COPY INTO

B.

GET

C.

INSERT INTO

D.

PUT

Full Access
Question # 106

Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake (VPS)

Full Access
Question # 107

What are valid sub-clauses to the OVER clause for a window function? (Select TWO).

A.

GROUP BY

B.

LIMIT

C.

ORDER BY

D.

PARTITION BY

E.

UNION ALL

Full Access
Question # 108

How does Snowflake reorganize data when it is loaded? (Select TWO).

A.

Binary format

B.

Columnar format

C.

Compressed format

D.

Raw format

E.

Zipped format

Full Access
Question # 109

When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?

A.

There are multiple SOL UDFs with the same names and the same number of arguments.

B.

There are multiple SQL UDFs with the same names and the same number of argument types.

C.

There are multiple SQL UDFs with the same names but with a different number of arguments or argument types.

D.

There are multiple SQL UDFs with different names but the same number of arguments or argument types.

Full Access
Question # 110

A user has semi-structured data to load into Snowflake but is not sure what types of operations will need to be performed on the data. Based on this situation, what type of column does Snowflake recommend be used?

A.

ARRAY

B.

OBJECT

C.

TEXT

D.

VARIANT

Full Access
Question # 111

For Directory tables, what stage allows for automatic refreshing of metadata?

A.

User stage

B.

Table stage

C.

Named internal stage

D.

Named external stage

Full Access
Question # 112

What is the Fail-safe retention period for transient and temporary tables?

A.

0 days

B.

1 day

C.

7 days

D.

90 days

Full Access
Question # 113

Which Snowflow object does not consume and storage costs?

A.

Secure view

B.

Materialized view

C.

Temporary table

D.

Transient table

Full Access
Question # 114

How can a user get the MOST detailed information about individual table storage details in Snowflake?

A.

SHOW TABLES command

B.

SHOW EXTERNAL TABLES command

C.

TABLES view

D.

TABLE STORAGE METRICS view

Full Access
Question # 115

By default, how long is the standard retention period for Time Travel across all Snowflake accounts?

A.

0 days

B.

1 day

C.

7 days

D.

14 days

Full Access
Question # 116

What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtual warehouse?

A.

1

B.

5

C.

10

D.

100

Full Access
Question # 117

What is the relationship between a Query Profile and a virtual warehouse?

A.

A Query Profile can help users right-size virtual warehouses.

B.

A Query Profile defines the hardware specifications of the virtual warehouse.

C.

A Query Profile can help determine the number of virtual warehouses available.

D.

A Query Profile automatically scales the virtual warehouse based on the query complexity.

Full Access
Question # 118

How is unstructured data retrieved from data storage?

A.

SQL functions like the GET command can be used to copy the unstructured data to a location on the client.

B.

SQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client.

C.

SQL functions can be used to retrieve the data from the query results cache. When the query results are output to a client, the unstructured data will be output to the client as files.

D.

SQL functions can call on different web extensions designed to display different types of files as a web page. The web extensions will allow the files to be downloaded to the client.

Full Access
Question # 119

What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?

A.

Access control

B.

Fail-safe

C.

Network policies

D.

Time Travel

Full Access
Question # 120

At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?

A.

Account

B.

Database

C.

Schema

D.

Table

Full Access
Question # 121

Which Snowflake command can be used to unload the result of a query to a single file?

A.

Use COPY INTO followed by a GET command to download the file.

B.

Use COPY INTO followed by a put command to download the file.

C.

Use COPY INTO with SINGLE = TRUE followed by a GET command to download the file.

D.

Use COPY INTO with SINGLE = TRUE followed by a PUT command to download the file.

Full Access
Question # 122

Which role has the ability to create a share from a shared database by default?

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSADMIN

D.

ORGADMIN

Full Access
Question # 123

What is the default value in the Snowflake Web Interface (Ul) for auto suspending a Virtual Warehouse?

A.

1 minutes

B.

5 minutes

C.

10 minutes

D.

15 minutes

Full Access
Question # 124

A user wants to add additional privileges to the system-defined roles for their virtual warehouse. How does Snowflake recommend they accomplish this?

A.

Grant the additional privileges to a custom role.

B.

Grant the additional privileges to the ACCOUNTADMIN role.

C.

Grant the additional privileges to the SYSADMIN role.

D.

Grant the additional privileges to the ORGADMIN role.

Full Access
Question # 125

What happens when a network policy includes values that appear in both the allowed and blocked IP address list?

A.

Those IP addresses are allowed access to the Snowflake account as Snowflake applies the allowed IP address list first.

B.

Those IP addresses are denied access lei the Snowflake account as Snowflake applies the blocked IP address list first.

C.

Snowflake issues an alert message and adds the duplicate IP address values lo both 'he allowed and blocked IP address lists.

D.

Snowflake issues an error message and adds the duplicate IP address values to both the allowed and blocked IP address list

Full Access
Question # 126

What information is found within the Statistic output in the Query Profile Overview?

A.

Operator tree

B.

Table pruning

C.

Most expensive nodes

D.

Nodes by execution time

Full Access
Question # 127

Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?

A.

Automatic clustering

B.

Materialized views

C.

Query acceleration service

D.

Search optimization service

Full Access
Question # 128

What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO).'

A.

Views

B.

Materialized views

C.

Tables

D.

External tables

E.

Future grants

Full Access
Question # 129

What is the purpose of a Query Profile?

A.

To profile how many times a particular query was executed and analyze its u^age statistics over time.

B.

To profile a particular query to understand the mechanics of the query, its behavior, and performance.

C.

To profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.

D.

To profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.

Full Access
Question # 130

What does SnowCD help Snowflake users to do?

A.

Copy data into files.

B.

Manage different databases and schemas.

C.

Troubleshoot network connections to Snowflake.

D.

Write SELECT queries to retrieve data from external tables.

Full Access
Question # 131

Which commands can only be executed using SnowSQL? (Select TWO).

A.

COPY INTO

B.

GET

C.

LIST

D.

PUT

E.

REMOVE

Full Access
Question # 132

Which command is used to start configuring Snowflake for Single Sign-On (SSO)?

A.

CREATE SESSION POLICY

B.

CREATE NETWORK RULE

C.

CREATE SECURITY INTEGRATION

D.

CREATE PASSWORD POLICY

Full Access
Question # 133

Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?

A.

Tags

B.

Comments

C.

Internal tokenization

D.

Row access policies

Full Access
Question # 134

Which commands are restricted in owner's rights stored procedures? (Select TWO).

A.

SHOW

B.

MERGE

C.

INSERT

D.

DELETE

E.

DESCRIBE

Full Access
Question # 135

Which views are included in the DATA SHARING USAGE schema? (Select TWO).

A.

ACCESS_HISTORY

B.

DATA_TRANSFER_HISTORY

C.

WAREHOUSE_METERING_HISTORY

D.

MONETIZED_USAGE_DAILY

E.

LISTING TELEMETRY DAILY

Full Access
Question # 136

Which VALIDATION_MODE value will return the errors across the files specified in a COPY command, including files that were partially loaded during an earlier load?

A.

RETURN_-1_R0WS

B.

RETURN_n_ROWS

C.

RETURN_ERRORS

D.

RETURN ALL ERRORS

Full Access
Question # 137

Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?

A.

CREATE STAGE

B.

COPY INTO

C.

COPY INTO

D.

CREATE PIPE

Full Access
Question # 138

What does a Notify & Suspend action for a resource monitor do?

A.

Send an alert notification to all account users who have notifications enabled.

B.

Send an alert notification to all virtual warehouse users when thresholds over 100% have been met.

C.

Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses after all statements being executed by the warehouses have completed.

D.

Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses immediately, canceling any statements being executed by the warehouses.

Full Access
Question # 139

Who can grant object privileges in a regular schema?

A.

Object owner

B.

Schema owner

C.

Database owner

D.

SYSADMIN

Full Access
Question # 140

What happens to the objects in a reader account when the DROP MANAGED ACCOUNT command is executed?

A.

The objects are dropped.

B.

The objects enter the Fail-safe period.

C.

The objects enter the Time Travel period.

D.

The objects are immediately moved to the provider account.

Full Access
Question # 141

Which Snowflake database object can be used to track data changes made to table data?

A.

Tag

B.

Task

C.

Stream

D.

Stored procedure

Full Access
Question # 142

Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO).

A.

A user with an USERADMIN or higher role

B.

A user with a SECURITYADMIN or higher role

C.

A role that has been granted the ATTACH POLICY privilege

D.

A role that has the NETWORK_POLlCY account parameter set

E.

A role that has the ownership of the network policy

Full Access
Question # 143

What step can reduce data spilling in Snowflake?

A.

Using a larger virtual warehouse

B.

Increasing the virtual warehouse maximum timeout limit

C.

Increasing the amount of remote storage for the virtual warehouse

D.

Using a common table expression (CTE) instead of a temporary table

Full Access
Question # 144

A column named "Data" contains VARIANT data and stores values as follows:

How will Snowflake extract the employee's name from the column data?

A.

Data:employee.name

B.

DATA:employee.name

C.

data:Employee.name

D.

data:employee.name

Full Access
Question # 145

Which metadata table will store the storage utilization information even for dropped tables?

A.

DATABASE_STORAGE_USAGE_HISTORY

B.

TABLE_STORAGE_METRICS

C.

STORAGE_DAILY_HISTORY

D.

STAGE STORAGE USAGE HISTORY

Full Access
Question # 146

Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?

A.

OAuth

B.

Network policies

C.

Single Sign-On (SSO)

D.

Multi-Factor Authentication (MFA)

Full Access
Question # 147

When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?

A.

File URL

B.

Scoped URL

C.

Relative URL

D.

Pre-Signed URL

Full Access
Question # 148

Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?

A.

DATA_RETENTION_TIME_IN_DAYS

B.

MAX_DATA_EXTENSION_TIME_IN_DAYS

C.

MIN_DATA_RETENTION_TIME_IN_DAYS

D.

MAX CONCURRENCY LEVEL

Full Access
Question # 149

Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Select TWO).

A.

Bytes scanned

B.

Partitions scanned

C.

Bytes spilled to local storage

D.

Bytes spilled to remote storage

E.

Percentage scanned from cache

Full Access
Question # 150

Which statements describe benefits of Snowflake's separation of compute and storage? (Select TWO).

A.

The separation allows independent scaling of computing resources.

B.

The separation ensures consistent data encryption across all virtual data warehouses.

C.

The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.

D.

Storage volume growth and compute usage growth can be tightly coupled.

E.

Compute can be scaled up or down without the requirement to add more storage.

Full Access
Question # 151

Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?

A.

Access history

B.

Data classification

C.

Dynamic Data Masking

D.

Object tagging

Full Access
Question # 152

What is the purpose of the STRIP NULL_VALUES file format option when loading semi-structured data files into Snowflake?

A.

It removes null values from all columns in the data.

B.

It converts null values to empty strings during loading.

C.

It skips rows with null values during the loading process.

D.

It removes object or array elements containing null values.

Full Access
Question # 153

What transformations are supported when loading data into a table using the COPY INTO

command? (Select TWO).

A.

Column reordering

B.

Column omission

C.

JOIN function

D.

FLATTEN function

E.

GROUP BY function

Full Access
Question # 154

What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?

A.

FLATTEN

B.

GET_PATH

C.

CHECK_JSON

D.

PARSE JSON

Full Access
Question # 155

Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).

A.

Bytes scanned

B.

Bytes written to result

C.

Partitions scanned

D.

Partitions total

E.

Percentage scanned from cache

Full Access
Question # 156

How should clustering be used to optimize the performance of queries that run on a very large table?

A.

Manually re-cluster the table regularly.

B.

Choose one high cardinality column as the clustering key.

C.

Use the column that is most-frequently used in query select clauses as the clustering key.

D.

Assess the average table depth to identify how clustering is impacting the query.

Full Access
Question # 157

What metadata does Snowflake store for rows in micro-partitions? (Select TWO).

A.

Range of values

B.

Distinct values

C.

Index values

D.

Sorted values

E.

Null values

Full Access
Question # 158

Which type of loop requires a BREAK statement to stop executing?

A.

FOR

B.

LOOP

C.

REPEAT

D.

WHILE

Full Access
Question # 159

Which Snowflake role can manage any object grant globally, including modifying and revoking grants?

A.

USERADMIN

B.

ORGADMIN

C.

SYSADMIN

D.

SECURITYADMIN

Full Access
Question # 160

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?

A.

Flatten the data and store it in structured data types in a flattened table. Query the table.

B.

Store the data in a table with a variant data type. Query the table.

C.

Store the data in a table with a vai : ant data type and include STRIP_NULL_VALUES while loading the table. Query the table.

D.

Store the data in an external stage and create views on top of it. Query the views.

Full Access
Question # 161

What will prevent unauthorized access to a Snowflake account from an unknown source?

A.

Network policy

B.

End-to-end encryption

C.

Multi-Factor Authentication (MFA)

D.

Role-Based Access Control (RBAC)

Full Access
Question # 162

What is the default character set used when loading CSV files into Snowflake?

A.

UTF-8

B.

UTF-16

C.

ISO S859-1

D.

ANSI_X3.A

Full Access
Question # 163

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

Full Access
Question # 164

What are ways to create and manage data shares in Snowflake? (Select TWO)

A.

Through the Snowflake web interface (Ul)

B.

Through the DATA_SHARE=TRUE parameter

C.

Through SQL commands

D.

Through the enable__share=true parameter

E.

Using the CREATE SHARE AS SELECT * TABLE command

Full Access
Question # 165

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.

Which of the following statements will accommodate this request?

A.

ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

B.

GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

C.

GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

D.

GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

Full Access
Question # 166

Where would a Snowflake user find information about query activity from 90 days ago?

A.

account__usage . query history view

B.

account__usage.query__history__archive View

C.

information__schema . cruery_history view

D.

information__schema - query history_by_ses s i on view

Full Access
Question # 167

A sales table FCT_SALES has 100 million records.

The following Query was executed

SELECT COUNT (1) FROM FCT__SALES;

How did Snowflake fulfill this query?

A.

Query against the result set cache

B.

Query against a virtual warehouse cache

C.

Query against the most-recently created micro-partition

D.

Query against the metadata excite

Full Access
Question # 168

Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

A.

ORC

B.

XML

C.

Avro

D.

Parquet

E.

JSON

Full Access
Question # 169

Which of the following commands cannot be used within a reader account?

A.

CREATE SHARE

B.

ALTER WAREHOUSE

C.

DROP ROLE

D.

SHOW SCHEMAS

E.

DESCRBE TABLE

Full Access
Question # 170

True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

A.

True

B.

False

Full Access
Question # 171

In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

A.

Bytes scanned

B.

Bytes sent over the network

C.

Number of partitions scanned

D.

Percentage scanned from cache

E.

External bytes scanned

Full Access
Question # 172

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

Full Access
Question # 173

Which Snowflake technique can be used to improve the performance of a query?

A.

Clustering

B.

Indexing

C.

Fragmenting

D.

Using INDEX__HINTS

Full Access
Question # 174

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

Full Access
Question # 175

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

A.

The table contains a column that has very low cardinality

B.

DML statements that are being issued against the table are blocked

C.

The table has a small number of micro-partitions

D.

Queries on the table are running slower than expected

E.

The clustering depth for the table is large

Full Access
Question # 176

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

A.

Compute Credits = 50 Credits Cloud Services = 10

B.

Compute Credits = 80 Credits Cloud Services = 5

C.

Compute Credits = 10 Credits Cloud Services = 9

D.

Compute Credits = 120 Credits Cloud Services = 10

E.

Compute Credits = 200 Credits Cloud Services = 26

Full Access
Question # 177

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

A.

The user has the appropriate privileges on the objects associated with the query

B.

Micro-partitions have been reclustered since the query was last run

C.

The new query is run using the same virtual warehouse as the previous query

D.

The query includes a User Defined Function (UDF)

E.

The query has been run within 24 hours of the previously-run query

Full Access
Question # 178

Which statement about billing applies to Snowflake credits?

A.

Credits are billed per-minute with a 60-minute minimum

B.

Credits are used to pay for cloud data storage usage

C.

Credits are consumed based on the number of credits billed for each hour that a warehouse runs

D.

Credits are consumed based on the warehouse size and the time the warehouse is running

Full Access
Question # 179

Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

A.

Pipes

B.

Streams

C.

Tasks

D.

Procedures

Full Access
Question # 180

Which command can be used to load data into an internal stage?

A.

LOAD

B.

copy

C.

GET

D.

PUT

Full Access
Question # 181

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

Full Access
Question # 182

Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

A.

Load files that are approximately 25 MB or smaller.

B.

Remove all dates and timestamps.

C.

Load files that are approximately 100-250 MB (or larger)

D.

Avoid using embedded characters such as commas for numeric data types

E.

Remove semi-structured data types

Full Access
Question # 183

When unloading to a stage, which of the following is a recommended practice or approach?

A.

Set SINGLE: = true for larger files

B.

Use OBJECT_CONSTRUCT ( * ) when using Parquet

C.

Avoid the use of the CAST function

D.

Define an individual file format

Full Access
Question # 184

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

Full Access
Question # 185

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

A.

True

B.

False

Full Access
Question # 186

The fail-safe retention period is how many days?

A.

1 day

B.

7 days

C.

45 days

D.

90 days

Full Access
Question # 187

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

A.

The primary cluster in the virtual warehouse

B.

The entire virtual warehouse

C.

The database in which the virtual warehouse resides

D.

The Queries currently being run on the virtual warehouse

Full Access
Question # 188

Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

A.

Each Snowflake account can be hosted in a different cloud vendor and region.

B.

Each Snowflake account must be hosted in a different cloud vendor and region

C.

All Snowflake accounts must be hosted in the same cloud vendor and region

D.

Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

Full Access
Question # 189

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

Full Access
Question # 190

Which of the following objects can be shared through secure data sharing?

A.

Masking policy

B.

Stored procedure

C.

Task

D.

External table

Full Access
Question # 191

Which of the following are benefits of micro-partitioning? (Select TWO)

A.

Micro-partitions cannot overlap in their range of values

B.

Micro-partitions are immutable objects that support the use of Time Travel.

C.

Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

D.

Rows are automatically stored in sorted order within micro-partitions

E.

Micro-partitions can be defined on a schema-by-schema basis

Full Access
Question # 192

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

A.

Materialized views

B.

Sequences

C.

Procedures

D.

Tables

E.

Secure User Defined Functions (UDFs)

Full Access
Question # 193

Which Snowflake partner specializes in data catalog solutions?

A.

Alation

B.

DataRobot

C.

dbt

D.

Tableau

Full Access
Question # 194

True or False: Fail-safe can be disabled within a Snowflake account.

A.

True

B.

False

Full Access
Question # 195

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

A.

Internal stages

B.

Incremental backups

C.

Time Travel

D.

Zero-copy clones

E.

Fail-safe

Full Access
Question # 196

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

Full Access
Question # 197

True or False: A Virtual Warehouse can be resized while suspended.

A.

True

B.

False

Full Access
Question # 198

What is the purpose of an External Function?

A.

To call code that executes outside of Snowflake

B.

To run a function in another Snowflake database

C.

To share data in Snowflake with external parties

D.

To ingest data from on-premises data sources

Full Access
Question # 199

A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?

A.

SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME

FROM ACCOUNT_USAGE.USERS;

B.

SELECT EVENT_TIMESTAMP, USER_NAME

FROM table(information_schema.login_history_by_user())

C.

SELECT EVENT_TIMESTAMP, USER_NAME

FROM ACCOUNT_USAGE.ACCESS_HISTORY;

D.

SELECT EVENT_TIMESTAMP, USER_NAME

FROM ACCOUNT_USAGE.LOGIN_HISTORY;

Full Access
Question # 200

When is the result set cache no longer available? (Select TWO)

A.

When another warehouse is used to execute the query

B.

When another user executes the query

C.

When the underlying data has changed

D.

When the warehouse used to execute the query is suspended

E.

When it has been 24 hours since the last query

Full Access
Question # 201

Which data type can be used to store geospatial data in Snowflake?

A.

Variant

B.

Object

C.

Geometry

D.

Geography

Full Access
Question # 202

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

A.

Data is hashed by the cluster key to facilitate fast searches for common data values

B.

Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

C.

Smaller micro-partitions are created for common data values to allow for more parallelism

D.

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

Full Access
Question # 203

What is the MINIMUM Snowflake edition that must be used in order to see the ACCESS_HISTORY view?

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake (VPS)

Full Access
Question # 204

What does a table with a clustering depth of 1 mean in Snowflake?

A.

The table has only 1 micro-partition.

B.

The table has 1 overlapping micro-partition.

C.

The table has no overlapping micro-partitions.

D.

The table has no micro-partitions.

Full Access
Question # 205

Which Snowflake function and command combination should be used to convert rows in a relational table to a single VARIANT column, and unload the rows Into a file in JSON format? (Select TWO).

A.

PUT

B.

GET

C.

COPY

D.

EXPORT

E.

OBJECT CONSTRUCT

Full Access
Question # 206

Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

A.

Bytes sent over network

B.

Percentage scanned from cache

C.

Partitions total

D.

Bytes spilled to local storage

E.

Partitions scanned

Full Access
Question # 207

Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

A.

Cloud services layer

B.

Compute layer

C.

Storage layer

D.

Cloud agnostic layer

Full Access
Question # 208

Which of the following statements describes a schema in Snowflake?

A.

A logical grouping of objects that belongs to a single database

B.

A logical grouping of objects that belongs to multiple databases

C.

A named Snowflake object that includes all the information required to share a database

D.

A uniquely identified Snowflake account within a business entity

Full Access
Question # 209

What is the recommended compressed file size range for continuous data loads using Snowpipe?

A.

8-16 MB

B.

16-24 MB

C.

10-99 MB

D.

100-250 MB

Full Access
Question # 210

Snowflake's hierarchical key mode includes which keys? (Select TWO).

A.

Account master keys

B.

Database master keys

C.

File keys

D.

Secure view keys

E.

Schema master keys

Full Access
Question # 211

A materialized view should be created when which of the following occurs? (Choose two.)

A.

There is minimal cost associated with running the query.

B.

The query consumes many compute resources every time it runs.

C.

The base table gets updated frequently.

D.

The query is highly optimized and does not consume many compute resources.

E.

The results of the query do not change often and are used frequently.

Full Access
Question # 212

When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).

A.

When users will be using compute at different times throughout a 24/7 period

B.

When managing a steady workload

C.

When the compute must be available with no delay or lag time

D.

When the user does not want to have to manually turn on the warehouse each time it is needed

E.

When the warehouse is shared across different teams

Full Access
Question # 213

What is the difference between a stored procedure and a User-Defined Function (UDF)?

A.

Stored procedures can execute database operations while UDFs cannot.

B.

Returning a value is required in a stored procedure while returning values in a UDF is optional.

C.

Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.

D.

Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.

Full Access
Question # 214

What can a Snowflake user do with the information included in the details section of a Query Profile?

A.

Determine the total duration of the query.

B.

Determine the role of the user who ran the query.

C.

Determine the source system that the queried table is from.

D.

Determine if the query was on structured or semi-structured data.

Full Access
Question # 215

What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?

A.

Duo Security

B.

OAuth

C.

Okta

D.

Single Sign-On (SSO)

Full Access
Question # 216

Which languages requite that User-Defined Function (UDF) handlers be written inline? (Select TWO).

A.

Java

B.

Javascript

C.

Scala

D.

Python

E.

SQL

Full Access
Question # 217

Which Snowflake URL type is used by directory tables?

A.

File

B.

Pre-signed

C.

Scoped

D.

Virtual-hosted style

Full Access
Question # 218

How can a Snowflake user optimize query performance in Snowflake? (Select TWO).

A.

Create a view.

B.

Cluster a table.

C.

Enable the search optimization service.

D.

Enable Time Travel.

E.

Index a table.

Full Access
Question # 219

Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?

A.

Directory

B.

File

C.

Pre-signed

D.

Scoped

Full Access
Question # 220

Which activities are included in the Cloud Sen/ices layer? (Select TWO).

A.

Data storage

B.

Dynamic data masking

C.

Partition scanning

D.

User authentication

E.

Infrastructure management

Full Access
Question # 221

Which role has the ability to create and manage users and roles?

A.

ORGADMIN

B.

USERADMIN

C.

SYSADMIN

D.

SECURITYADMIN

Full Access
Question # 222

Which type of join will list a I rows in the specified table, even if those rows have no match in the other table?

A.

Cross join

B.

Inner join

C.

Natural join

D.

Outer join

Full Access
Question # 223

When unloading data to an external stage, what is the MAXIMUM file size supported?

A.

1 GB

B.

5 GB

C.

10 GB

D.

16 GB

Full Access
Question # 224

Which transformation is supported by a COPY INTO

command?

A.

Filter using a where clause

B.

Filter using a limit keyword

C.

Cast using a SELECT statement

D.

Order using an ORDER BY clause

Full Access
command in Snowflake supports transformations such as casting using a SELECT statement. This allows for the transformation of data types as the data is being loaded into the table, which can be particularly useful when the data types in the source files do not match the data types in the target table

Question # 225

What technique does Snowflake use to limit the number of micro-partitions scanned by each query?

A.

B-tree

B.

Indexing

C.

Map reduce

D.

Pruning

Full Access
Question # 226

How can a user change which columns are referenced in a view?

A.

Modify the columns in the underlying table

B.

Use the ALTER VIEW command to update the view

C.

Recreate the view with the required changes

D.

Materialize the view to perform the changes

Full Access
Question # 227

Which SQL command can be used to see the CREATE definition of a masking policy?

A.

SHOW MASKING POLICIES

B.

DESCRIBE MASKING POLICY

C.

GET_DDL

D.

LIST MASKING POLICIES

Full Access
Question # 228

By definition, a secure view is exposed only to users with what privilege?

A.

IMPORT SHARE

B.

OWNERSHIP

C.

REFERENCES

D.

USAGE

Full Access
Question # 229

What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?

A.

Swift

B.

JavaScript

C.

Python

D.

SQL

Full Access
Question # 230

What file formats does Snowflake support for loading semi-structured data? (Choose three.)

A.

TSV

B.

JSON

C.

PDF

D.

Avro

E.

Parquet

F.

JPEG

Full Access
Question # 231

What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake

Full Access
Question # 232

A user has a standard multi-cluster warehouse auto-scaling policy in place.

Which condition will trigger a cluster to shut-down?

A.

When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

B.

When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

C.

When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

D.

When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

Full Access
Question # 233

Where is Snowflake metadata stored?

A.

Within the data files

B.

In the virtual warehouse layer

C.

In the cloud services layer

D.

In the remote storage layer

Full Access
Question # 234

What are benefits of using Snowpark with Snowflake? (Select TWO).

A.

Snowpark uses a Spark engine to generate optimized SQL query plans.

B.

Snowpark automatically sets up Spark within Snowflake virtual warehouses.

C.

Snowpark does not require that a separate cluster be running outside of Snowflake.

D.

Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.

E.

Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).

Full Access
Question # 235

How would a user run a multi-cluster warehouse in maximized mode?

A.

Configure the maximum clusters setting to "Maximum."

B.

Turn on the additional clusters manually after starting the warehouse.

C.

Set the minimum Clusters and maximum Clusters settings to the same value.

D.

Set the minimum clusters and maximum clusters settings to different values.

Full Access
Question # 236

Which Snowflake tool would be BEST to troubleshoot network connectivity?

A.

SnowCLI

B.

SnowUI

C.

SnowSQL

D.

SnowCD

Full Access
Question # 237

Which pages are included in the Activity area of Snowsight? (Select TWO).

A.

Contacts

B.

Sharing settings

C.

Copy History

D.

Query History

E.

Automatic Clustering History

Full Access
Question # 238

Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

A.

Caching query results

B.

Running EXPLAIN and SHOW commands

C.

Cloning a database

D.

Running a custom query

E.

Running COPY commands

Full Access
Question # 239

Which Snowflake object can be accessed in he FROM clause of a query, returning a set of rows having one or more columns?

A.

A User-Defined Table Function (UDTF)

B.

A Scalar User Function (UDF)

C.

A stored procedure

D.

A task

Full Access
Question # 240

What is used to diagnose and troubleshoot network connections to Snowflake?

A.

SnowCD

B.

Snowpark

C.

Snowsight

D.

SnowSQL

Full Access
Question # 241

What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

A.

Enterprise

B.

Business Critical

C.

Standard

D.

Virtual Private Snowflake

Full Access
Question # 242

A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

A.

GRANT ROLE MYROLE TO USER USER1;

GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

B.

GRANT ROLE MYROLE TO USER USER1;

GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

C.

GRANT ROLE MYROLE TO USER USER1;

GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. K"-'SCHEMA TO USER! ;

D.

GRANT ROLE MYROLE TO USER USER1;

GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

Full Access
Question # 243

What is the MAXIMUM Time Travel retention period for a transient table?

A.

O days

B.

1 day

C.

7 days

D.

90 days

Full Access
Question # 244

Which of the following describes the Snowflake Cloud Services layer?

A.

Coordinates activities in the Snowflake account

B.

Executes queries submitted by the Snowflake account users

C.

Manages quotas on the Snowflake account storage

D.

Manages the virtual warehouse cache to speed up queries

Full Access
Question # 245

Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?

A.

PARSE_JSON

B.

CHECK_JSON

C.

JSON_EXTRACT_PATH_TEXT

D.

PARSE_XML

Full Access
Question # 246

Which objects together comprise a namespace in Snowflake? (Select TWO).

A.

Account

B.

Database

C.

Schema

D.

Table

E.

Virtual warehouse

Full Access