Free Practice Snowflake COF-C02 Exam Questions 2025

Stay ahead with 100% Free SnowPro Core Certification COF-C02 Dumps Practice Questions

Page: 1 / 184

Total 917 Questions | Updated On: Jun 05, 2025

Add To Cart

Question 1

You have a medium-sized virtual warehouse for executing ad-hoc queries. Due to many queries concurrently executing at peak times, the queries start queuing. What is the best way to reduce queuing?

A : Kill all long-running queries

B : Create several Medium-sized virtual warehouses and redirect users to use different virtual warehouses.

C : Configure the virtual warehouse to be a multi-cluster virtual warehouse. The virtual warehouse scales out and back depending on the query demands.

D : Request users to spread their queries throughout the day.

Answer: C

Question 2

Which function determines the kind of value stored in a VARIANT column?

A : CHECK_JSON

B : IS_ARRAY

C : IS_JSON

D : TYPEOF

Answer: D

Question 3

Which COPY INTOoptions can be used to load data from a staged file when the metadata in the file has expired? (Select TWO)

A : LOAD_UNCERTAIN_FILES

B : LOAD_EXPIRED_FILES

C : FORCE

D : ENFORCE_LENGTH

E : PURGE

Answer: A,C

Question 4

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 5

How can a Snowflake user post-process the result of SHOW FILE FORMATS?

A : Use the RESULT_SCAN function.

B : Create a CURSOR for the command.

C : Put it in the FROM clause in brackets.

D : Assign the command to RESULTSET.

Answer: A

Page: 1 / 184

Total 917 Questions | Updated On: Jun 05, 2025

Add To Cart