Free Snowflake COF-C03 Practice Exam Questions and Answers 2026

Start Learning with the Newest and 100% Free COF-C03 Exam Dumps Questions

Page: 1 / 40

Total 200 Questions | Updated On: Apr 07, 2026

Add To Cart

Question 1

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 2

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

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

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 5

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

Page: 1 / 40

Total 200 Questions | Updated On: Apr 07, 2026

Add To Cart