Free Snowflake COF-C02 Exam Questions

Become Snowflake Certified with updated COF-C02 exam questions and correct answers

Page: 1 / 184

Total 917 Questions | Updated On: Jun 05, 2025

Add To Cart

Question 1

Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).

A : Binary file in Avro

B : Binary file in Parquet

C : Comma-separated JSON

D : Newline Delimited JSON

E : Plain text file containing XML elements

Answer: B,D

Question 2

Which function will generate a URL that can be accessed by a non-Snowflake user?

A : GET_PRESIGNED_URL

B : GET_STAGE_LOCATION

C : BUILD_SCOPED_FILE_URL

D : BUILD_STAGE_FILE_URL

Answer: B

Question 3

Which function will generate a URL that can be accessed by a non-Snowflake user?

A : GET_PRESIGNED_URL

B : GET_STAGE_LOCATION

C : BUILD_SCOPED_FILE_URL

D : BUILD_STAGE_FILE_URL

Answer: B

Question 4

Which statement is true regarding costs when a Snowflake account shares data with a non-Snowflake user or a non-Snowflake organization?

A : The data provider is charged for the compute charges for queries the data consumer runs.

B : The data consumer is charged for the compute charges for queries they run.

C : Both the data provider and the data consumer are charged for the compute costs.

Answer: A

Question 5

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

A : Free listing

B : Paid listing

C : Direct share

D : Data Exchange

Answer: C

Page: 1 / 184

Total 917 Questions | Updated On: Jun 05, 2025

Add To Cart