Free Snowflake COF-C02 Practice Exam Questions and Answers 2026

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

Page: 1 / 194

Total 970 Questions | Updated On: Apr 02, 2026

Add To Cart

Question 1

A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?

A : list @mytable;

B : list @%raytable;

C : list @ %m.ystage;

D : list @mystage;

Answer: D

Question 2

What does Snowflake attempt to do if any of the compute resources for a virtual warehouse fail to provision during start-up?

A : Repair the failed resources.

B : Restart failed resources.

C : Queue the failed resources

D : Provision the failed resources

Answer: B

Question 3

A Snowflake user accidentally deleted a table. The table no longer exists, but the session is within the data retention period. How can the table be restored using the LEAST amount of operational overhead?

A : Clone the table schema as it existed before the table was dropped.

B : Clone the database as it existed before the table was dropped.

C : Recreate the table and reload the data.

D : Run the UNDROP command against the table.

Answer: D

Question 4

Which data types optimally store semi-structured data? (Select TWO).

A : ARRAY

B : CHARACTER

C : STRING

D : VARCHAR

E : VARIANT

Answer: A,E

Question 5

Which items are considered schema objects in Snowflake? (Select TWO).

A : Pipe

B : File format

C : Resource monitor

D : Storage integration

E : Virtual warehouse

Answer: A,B

Page: 1 / 194

Total 970 Questions | Updated On: Apr 02, 2026

Add To Cart