Free Snowflake COF-C02 Exam Questions

Become Snowflake Certified with updated COF-C02 exam questions and correct answers

Page: 1 / 279

Total 1392 Questions | Updated On: Jan 08, 2025

Add To Cart

Question 1

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 2

True or False: The data in the views in the ACCOUNT_USAGE schema can have a latency of up to 3 hours.

A : True

B : False

Answer: A

Question 3

Which of the following statement is correct regarding Snowflake billing? Select all that apply.

A : Snowflake billing is based on the amount of data processed by queries

B : If a virtual warehouse is suspended, it does not contribute to the cost.

C : Snowflake billing is based on the number of queries executed.

D : Snowflake billing is based on the actual used storage.

Answer: B,D

Question 4

An administrator cloned a table called Customer to a new table called Prospects. The administrator then proceeds to load new data into the Customer table. What can you expect to happen to the Prospects table?

Select all that apply.

A : The data loading fails as it is impossible to load data into a table that was a source for a cloning operation.

B : The new data does not show up in the Prospects table.

C : The new data is loaded into the Customer table and its clone, the Prospects table.

D : The new data is loaded successfully into the Customer table only.

Answer: B,D

Question 5

How many shares can be consumed by single Data Consumer?

A : 1

B : 10

C : 100, but can be increased by contacting support

D : Unlimited

Answer: D

Page: 1 / 279

Total 1392 Questions | Updated On: Jan 08, 2025

Add To Cart