Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Snowflake COF-R02 - SnowPro Core Recertification Exam

Snowflake COF-R02 Premium Access     Download Demo    
Page: 1 / 10
Total 330 questions

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

A.

True

B.

False

What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

A.

Standard

B.

Premier

C.

Enterprise

D.

Business Critical Edition

Which of the following are true of multi-cluster Warehouses? Select all that apply below.

A.

A multi-cluster Warehouse can add clusters automatically based on query activity

B.

A multi-cluster Warehouse can automatically turn itself off after a period of inactivity

C.

A multi-cluster Warehouse can scale down when query activity slows

D.

A multi-cluster Warehouse can automatically turn itself on when a query is executed against it

What are the three layers that make up Snowflake’s architecture?

Choose 3 answer

A.

Compute

B.

Tri-Secret Secure

C.

Storage

D.

Cloud Services

Which of the following statement is true of Snowflake?

Select one.

A.

It was built specifically for the cloud

B.

it was built as an on-premises solution and then potted to the cloud

C.

It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

D.

It was built for Hadoop architecture

E.

It's based on an Oracle Architecture

When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

A.

Concurrency

B.

Performance

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

A.

True

B.

False

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

A.

The Pipe load history is reset to empty

B.

The REFRESH parameter is set to TRUE

C.

Previously loaded files will be ignored

D.

All of the above

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

A.

True

B.

False

True or False: It is possible to load data into Snowflake without creating a named File Format object.

A.

True

B.

False