What is the minimum Snowflake edition required for row level security?

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake

Which of the following significantly improves the performance of selective point lookup queries on a table?

A.

Clustering

B.

Materialized Views

C.

Zero-copy Cloning

D.

Search Optimization Service

Which command sets the Virtual Warehouse for a session?

A.

COPY WAREHOUSE FROM <<config file>>;

B.

SET WAREHOUSE = <<warehouse name>>;

C.

USE WAREHOUSE <<warehouse name>>;

D.

USE VIRTUAL_WAREHOUSE <<warehouse name>>;

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.

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

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

A.

INSERT

B.

PUT

C.

GET

D.

COPY

A running virtual warehouse is suspended. What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

A.

1 second

B.

60 seconds

C.

5 minutes

D.

60 minutes

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

What is the following SQL command used for?
Select * from table(validate(t1, job_id => '_last'));

A.

To validate external table files in table t1 across all sessions

B.

To validate task SQL statements against table t1 in the last 14 days

C.

To validate a file for errors before it gets executed using a COPY command

D.

To return errors from the last executed COPY command into table t1 in the current session

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

When loading data into Snowflake, how should the data be organized?

A.

Into single files with 100-250 MB of compressed data per file

B.

Into single files with 1-100 MB of compressed data per file

C.

Into files of maximum size of 1 GB of compressed data per file

D.

Into files of maximum size of 4 GB of compressed data per file

Where can a user find and review the failed logins of a specific user for the past 30 days?

A.

The USERS view in ACCOUNT_USAGE

B.

The LOGIN_HISTORY view in ACCOUNT_USAGE

C.

The ACCESS_HISTORY view in ACCOUNT_USAGE

D.

The SESSIONS view in ACCOUNT_USAGE