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: Apr 07, 2026

Add To Cart

Question 1

A data engineer is running some transformation jobs using a M virtual warehouse. The virtual warehouse seems to be suspending between the jobs, making subsequent jobs take longer. What could be the issue? Choose one correct value.

A : The Virtual Warehouse AUTO_RESUME property is set to FALSE.

B : The Virtual Warehouse AUTO_SUSPEND property (in seconds) is set too low.

C : The Virtual Warehouse is too small for the workload they're running.

D : The Virtual Warehouse INITIALLY_SUSPEND property is set to TRUE.

Answer: B

Question 2

True or False: When a zero-copy clone of a database is created in Snowflake, the privileges on the database itself and all child objects are automatically inherited by the cloned database.

A : False

B : True

Answer: A

Question 3

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 4

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

A : True

B : False

Answer: B

Question 5

Which feature is available starting from the Enterprise Edition of Snowflake?

A : Secure Data Sharing

B : Multi-cluster Warehouses

C : Time Travel up to 1 day

D : Customer Managed Encryption

Answer: B

Page: 1 / 40

Total 200 Questions | Updated On: Apr 07, 2026

Add To Cart