CertsTopics Logo

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

SnowPro Core Certification COF-C02 Reddit Questions

Page: 12 / 71
Total 948 questions
Get COF-C02 Full Access Download COF-C02 PDF

SnowPro Core Certification Exam Questions and Answers

Question 45

Which command should be used to load data from a local computer into Snowflake?

Options:

A.

CREATE EXTERNAL TABLE

B.

COPY INTO

C.

INSERT

D.

PUT

Question 46

What does Snowflake recommend when planning virtual warehouse usage for a data load?

Options:

A.

Load the fewest possible number of large files.

B.

Dedicate a separate warehouse for loading data.

C.

Increase the size of the warehouse used.

D.

Use several single-duster warehouses.

Question 47

Which categories are included in the execution time summary in a Query Profile? (Select TWO).

Options:

A.

Pruning

B.

Spilling

C.

Initialization

D.

Local Disk I/O

E.

Percentage of data read from cache

Question 48

Which data sharing option allows a Snowflake user to set up and manage a group of accounts and offer a share to that group?

Options:

A.

Free listing

B.

Paid listing

C.

Direct share

D.

Data Exchange

Page: 12 / 71
Total 948 questions
Get COF-C02 Full Access Download COF-C02 PDF