Spring Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: buysanta

Exact2Pass Menu

SnowPro Core Recertification Exam

Last Update 8 hours ago Total Questions : 330

The SnowPro Core Recertification Exam content is now fully updated, with all current exam questions added 8 hours ago. Deciding to include COF-R02 practice exam questions in your study plan goes far beyond basic test preparation.

You'll find that our COF-R02 exam questions frequently feature detailed scenarios and practical problem-solving exercises that directly mirror industry challenges. Engaging with these COF-R02 sample sets allows you to effectively manage your time and pace yourself, giving you the ability to finish any SnowPro Core Recertification Exam practice test comfortably within the allotted time.

Question # 81

Which type of table corresponds to a single Snowflake session?

A.

Temporary

B.

Translent

C.

Provisional

D.

Permanent

Question # 82

True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

A.

True

B.

False

Question # 83

True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

A.

True

B.

False

Question # 84

The PUT command: (Choose two.)

A.

Automatically creates a File Format object

B.

Automatically uses the last Stage created

C.

Automatically compresses files using Gzip

D.

Automatically encrypts files

Question # 85

Which of the following statements are true of Snowflake releases: (Choose two.)

A.

They happen approximately weekly

B.

They roll up and release approximately monthly, but customers can request early release application

C.

During a release, new customer requests/queries/connections transparently move over to the newer

version

D.

A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the

system will be unavailable and customer is upgraded

Question # 86

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

A.

A Schema may contain one or more Databases

B.

A Database may contain one or more Schemas

C.

A Schema is a logical grouping of Database Objects

D.

Each Schema is contained within a Warehouse

Question # 87

If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

A.

4

B.

16

C.

32

D.

128

Question # 88

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

A.

Concurrency

B.

Performance

Question # 89

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

Question # 90

Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?

Select one.

A.

More micro-partitions

B.

Better query scheduling

C.

Double the numbers of servers In the compute duster

D.

Higher storage costs

Go to page: