Free Snowflake COF-C02 Exam Questions

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

Page: 1 / 194

Total 970 Questions | Updated On: Dec 17, 2025

Add To Cart

Question 1

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 2

Which function is used to convert rows in a relational table to a single VARIANT column?

A : ARRAY_AGG

B : OBJECT_AGG

C : ARRAY_CONSTRUCT

D : OBJECT_CONSTRUCT

Answer: D

Question 3

Which file format option should be used when unloading data into a stage to create a CSV or a JSON file?

A : PARSE_HEADER

B : TRIM_SPACE

C : FILE_EXTENSION

D : SKIP_HEADER

Answer: C

Question 4

What role is required to use Partner Connect?

A : ACCOUNTADMIN

B : ORGADMIN

C : SECURITYADMIN

D : SYSADMIN

Answer: A

Question 5

What is the MINIMUM Snowftake edition that supports database replication?

A : Standard

B : Enterprise

C : Business Critical

D : Virtual Private Snowflake (VPS)

Answer: B

Page: 1 / 194

Total 970 Questions | Updated On: Dec 17, 2025

Add To Cart