Which of the following connectors allow Multi-Factor Authentication (MFA) authorization
when connecting?
(Choose all that apply.)

A.

JDBC

B.

SnowSQL

C.

Snowflake Web Interface (UI)

D.

ODBC

E.

Python
D18912E1457D5D1DDCBD40AB3BF70D5D

True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).

A.

True

B.

False

Fail-safe is unavailable on which table types?

A.

Temporary

B.

Transient

C.

Provisional

D.

Permanent

which of the following are valid approaches to loading data into a snowflake table? select
all the below that apply.

A.

Bulk copy from an External Stage

B.

Continuous load using Snowpipe REST API

C.

The Snowflake Web Interface (UT) data loading wizard

D.

Bulk copy from an Internal Stage

True or False: When you create a custom role, it is a practice to immediately grant that role
to ACCOUNTADMIN.

A.

True

B.

False

Which of the following accurately represents how a table fits into Snowflake’s logical container hierarchy?
Select one.

A.

Account -> Schema -> Database -> Table

B.

Account -> Database -> Schema -> Table

C.

Database -> Schema -> Table -> Account

D.

Database -> Table -> Schema -> Account

Which of the following are common use cases for zero-copy cloning?
Choose 3 answers

A.

Quick provisioning of Dev and Test/QA environments

B.

Data backups

C.

Point in time snapshots

D.

Performance optimization

Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:

A.

Scaling rhythmically

B.

Scaling max

C.

Scaling out

D.

Scaling up

Which type of table corresponds to a single Snowflake session?

A.

Temporary

B.

Translent

C.

Provisional

D.

Permanent

True or False the longer the data retention period, the higher the resulting storage costs. 

A.

True

B.

False