Free Snowflake COF-C02 Exam Questions

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

Page: 1 / 171

Total 851 Questions | Updated On: Mar 26, 2025

Add To Cart

Question 1

At what level is the MIN_DATA_RETENSION_TIME_IN_DAYS parameter set?

A : Account

B : Database

C : Schema

D : Table

Answer: A

Question 2

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 3

Which of the following terms may be used to describe Snowflake?

Select all that apply.

A : Shared Data

B : Native SQL support

C : Built from scratch, specifically designed for execution on cloud platforms.

D : Hybrid Columnar Storage

E : Shared Disk

F : Shared Compute

Answer: A,B,C,D

Question 4

A sales table FCT_SALES has 100 million records.

The following Query was executed

SELECT COUNT (1) FROM FCT__SALES;

How did Snowflake fulfill this query?

A : Query against the result set cache

B : Query against a virtual warehouse cache

C : Query against the most-recently created micro-partition

D : Query against the metadata excite

Answer: D

Question 5

Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

A : UPDATE TABLE FROM STREAM

B : SELECT FROM STREAM

C : INSERT INTO TABLE SELECT FROM STREAM

D : ALTER TABLE AS SELECT FROM STREAM

E : BEGIN COMMIT

Answer: C,D

Page: 1 / 171

Total 851 Questions | Updated On: Mar 26, 2025

Add To Cart