Free Practice Snowflake COF-R02 Exam Questions 2025

Stay ahead with 100% Free SnowPro Core Recertification COF-R02 Dumps Practice Questions

Page: 1 / 67

Total 333 Questions | Updated On: Jun 03, 2025

Add To Cart

Question 1

When loading data into Snowflake, how should the data be organized?

A : Into single files with 100-250 MB of compressed data per file

B : Into single files with 1-100 MB of compressed data per file

C : Into files of maximum size of 1 GB of compressed data per file

D : Into files of maximum size of 4 GB of compressed data per file

Answer: A

Question 2

What happens to historical data when the retention period for an object ends?

A : The data is cloned into a historical object.

B : The data moves to Fail-safe

C : Time Travel on the historical data is dropped.

D : The object containing the historical data is dropped.

Answer: D

Question 3

Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

A : A directory table is a separate database object.

B : Directory tables store data file metadata.

C : A directory table will be automatically added to a stage.

D : Directory tables do not have their own grantable privileges.

E : Directory table data can not be refreshed manually.

Answer: B,D

Question 4

Which type of table corresponds to a single Snowflake session?

A : Temporary

B : Translent

C : Provisional

D : Permanent

Answer: A

Question 5

True or False: Data Providers can share data with only the Data Consumer.

A : True

B : False

Answer: B

Page: 1 / 67

Total 333 Questions | Updated On: Jun 03, 2025

Add To Cart