CertsTopics Logo

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

Pass Using COF-C02 Exam Dumps

Page: 26 / 57
Total 751 questions
Get COF-C02 Full Access Download COF-C02 PDF

SnowPro Core Certification Exam Questions and Answers

Question 101

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.

Which SQL command should be used to delete the files?

Options:

A.

PURGE

B.

MODIFY

C.

REMOVE

D.

DELETE

Question 102

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

Options:

A.

INSERT

B.

PUT

C.

GET

D.

COPY

Question 103

Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

Options:

A.

PUT

B.

GET

C.

COPY

D.

SELECT

Question 104

Which services does the Snowflake Cloud Services layer manage? (Choose two.)

Options:

A.

Compute resources

B.

Query execution

C.

Authentication

D.

Data storage

E.

Metadata

Page: 26 / 57
Total 751 questions
Get COF-C02 Full Access Download COF-C02 PDF