SnowPro Core Recertification Exam (COF-R02) Practice Test

Questions # 21:

Which of the following DML commands isn’t supported by Snowflake?

Options:

UPSERT

MERGE

UPDATE

TRUNCATE TABLE

Questions # 22:

Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?

(Choose all that apply.)

Options:

JDBC

SnowSQL

Snowflake Web Interface (UI)

ODBC

Python

D18912E1457D5D1DDCBD40AB3BF70D5D

Questions # 23:

Which of the following statements are true about Schemas in Snowflake? (Choose two.)

Options:

A Schema may contain one or more Databases

A Database may contain one or more Schemas

A Schema is a logical grouping of Database Objects

Each Schema is contained within a Warehouse

Questions # 24:

True or False: A single database can exist in more than one Snowflake account.

Options:

True

False

Questions # 25:

True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

Options:

True

False

Questions # 26:

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

Options:

Configure the Maximum Clusters setting to “Auto-Scale”

Set the Warehouse type to “Auto”

Set the Minimum Clusters and Maximum Clusters settings to the same value

Set the Minimum Clusters and Maximum Clusters settings to the different values

Questions # 27:

True or False: Snowflake supports federated authentication in all editions.

Options:

True

False

Questions # 28:

True or False: You can query the files in an External Stage directly without having to load the data into a table.

Options:

True

False

Questions # 29:

True or False: An active warehouse is required to run a COPY INTO statement.

Options:

True

False

Questions # 30:

True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

Options:

True

False

Viewing page 3 out of 10 pages

Viewing questions 21-30 out of questions

Spring Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Pass the Snowflake SnowPro Core Certification COF-R02 Questions and answers with ExamsMirror

Exam COF-R02 Premium Access

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

TOP CODES