Winter Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: v4s65

COF-R02 Exam Dumps - SnowPro Core Recertification Exam

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: