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: Oct 07, 2022

Add To Cart

Question 1

A Snowflake account has activated federated authentication. What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?

A : The user will be unable to enter a password.

B : The user will encounter an error, and will not be able to log in.

C : The user will be able to log into Snowflake successfully.

D : After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.

Answer: A

Question 2

The COPY command can unload data from a table into which of the following locations? Select all that apply.

A : Local NAS

B : Named Internal Stage

C : External Stage

D : On-premises system

Answer: B,C

Question 3

At what level is the MIN_DATA_RETENSION_TIME_IN_DAYS parameter set?

A : Account

B : Database

C : Schema

D : Table

Answer: A

Question 4

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

Question 5

What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?

A : Standard Edition

B : Enterprise Edition

C : Business Critical Edition

D : Virtual Private Snowflake Edition

Answer: C

Page: 1 / 171

Total 851 Questions | Updated On: Oct 07, 2022

Add To Cart