Free Practice Snowflake SnowPro-Core Exam Questions 2026

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

Page: 1 / 194

Total 970 Questions | Updated On: Feb 18, 2026

Add To Cart

Question 1

True or False: Data in Time Travel and fail-safe storage is stored free of charge by Snowflake.

A : False

B : True

Answer: A

Question 2

What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

A : Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 30 days.Fail Safe retention time is 1 day.

B : Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 365 days.Fail Safe retention time is 7 days.

C : Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 90 days.Fail Safe retention time is 7 days.

D : Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 90 days.Fail Safe retention time is 7 days.

E : Default Time Travel Retention is set to 7 days.Maximum Time Travel Retention is 1 day.Fail Safe retention time is 90 days.

F : Default Time Travel Retention is set to 90 days.Maximum Time Travel Retention is 7 days.Fail Safe retention time is 356 days.

Answer: D

Question 3

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 4

The Snowflake VARIANT data Type imposes a 16 MB size limit on what?

A : An individual row

B : An individual column

C : A view

D : A file in a stage

Answer: B

Question 5

A user needs to MINIMIZE the cost of large tables that are used to store transitory dat a. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake. What table type should be used?

A : Permanent

B : Transient

C : Temporary

D : Externa

Answer: B

Page: 1 / 194

Total 970 Questions | Updated On: Feb 18, 2026

Add To Cart