Summer Special 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: bestdeal

Free Snowflake COF-R02 Practice Exam with Questions & Answers | Set: 10

Questions 91

Which of the following statements describes a benefit of Snowflake’s separation of compute and storage?

(Choose all that apply.)

Options:
A.

Growth of storage and compute are tightly coupled together

B.

Storage expands without the requirement to add more compute

C.

Compute can be scaled up or down without the requirement to add more storage

D.

Multiple compute clusters can access stored data without contention

Snowflake COF-R02 Premium Access
Questions 92

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

Options:
A.

Configure the Maximum Clusters setting to “Auto-Scale”

B.

Set the Warehouse type to “Auto”

C.

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

D.

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

Questions 93

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

Options:
A.

True

B.

False

Questions 94

True or False: The COPY command must specify a File Format in order to execute.

Options:
A.

True

B.

False

Questions 95

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

Options:
A.

Tables

B.

Named File Formats

C.

Schemas

D.

Shares

E.

Databases

F.

Users

Questions 96

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

Options:
A.

Custom

B.

Economy

C.

Optimized

D.

Standard

Questions 97

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

Options:
A.

True

B.

False

Questions 98

Select the different types of Internal Stages: (Choose three.)

Options:
A.

Named Stage

B.

User Stage

C.

Table Stage

D.

Schema Stage

Questions 99

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

Options:
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