Free Snowflake COF-C03 Exam Questions

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

Page: 1 / 40

Total 200 Questions | Updated On: Jun 17, 2026

Add To Cart

Question 1

What is the function of the AUTO_SUSPEND property of a Virtual Warehouse? Choose one correct value.

A : Specifies if a Virtual Warehouse should be suspended immediately after its created.

B : Specifies whether to automatically resume a warehouse when a SQL statement is submitted to it.

C : Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.

D : Specifies the max threshold of queries after which point a virtual warehouse will be automatically suspended.

Answer: C

Question 2

What is the recommended compressed file size when loading data into Snowflake? Choose one correct value.

A : 10-50mb

B : 50-100mb

C : 100-250mb

D : 100-200mb

Answer: C

Question 3

Which languages can be used to develop a User Defined Function (UDF)? Choose four correct values.

A : Java

B : GO

C : JavaScript

D : Python

E : C#

F : C++

G : SQL

Answer: A,C,D,G

Question 4

Which queries would not require the use of a Virtual Warehouse and instead would make use of the metadata cache? Select all that apply.

A : SELECT EMP_ID, NAME, ADDRESS FROM EMPLOYEE;

B : SELECT COUNT(*) FROM EMPLOYEE;

C : DESCRIBE TABLE EMPLOYEE;

D : SELECT * FROM TABLE(FLATTEN(INPUT => PARSE_JSON('[1, ,77]'))) F;

Answer: B,C

Question 5

Fail-safe is available for external tables. True or false?

A : True

B : False

Answer: B

Page: 1 / 40

Total 200 Questions | Updated On: Jun 17, 2026

Add To Cart