Halloween Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: scxmas70

COF-R02 Exam Dumps - SnowPro Core Recertification Exam

Searching for workable clues to ace the Snowflake COF-R02 Exam? You’re on the right place! ExamCert has realistic, trusted and authentic exam prep tools to help you achieve your desired credential. ExamCert’s COF-R02 PDF Study Guide, Testing Engine and Exam Dumps follow a reliable exam preparation strategy, providing you the most relevant and updated study material that is crafted in an easy to learn format of questions and answers. ExamCert’s study tools aim at simplifying all complex and confusing concepts of the exam and introduce you to the real exam scenario and practice it with the help of its testing engine and real exam dumps

Go to page:
Question # 17

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

A.

Custom

B.

Economy

C.

Optimized

D.

Standard

Full Access
Question # 18

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

A.

UPSERT

B.

MERGE

C.

UPDATE

D.

TRUNCATE TABLE

Full Access
Question # 19

Which interfaces can be used to create and/or manage Virtual Warehouses?

A.

The Snowflake Web Interface (UI)

B.

SQL commands

C.

Data integration tools

D.

All of the above

Full Access
Question # 20

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

Full Access
Question # 21

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

Full Access
Question # 22

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

A.

Concurrency

B.

Performance

Full Access
Question # 23

True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.

A.

True

B.

False

Full Access
Question # 24

Which of the following objects can be cloned? (Choose four.)

A.

Tables

B.

Named File Formats

C.

Schemas

D.

Shares

E.

Databases

F.

Users

Full Access
Go to page: