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

What is the minimum Snowflake edition required to create User Defined Functions (UDFs) in Java?

A : Business Critical

B : Standard

C : Virtual Private Snowflake

D : Enterprise

Answer: B

Question 2

Which of the following can be executed/called with Snowpipe?

A : A User Defined Function (UDF)

B : A stored procedure

C : A single copy_into statement

D : A single insert__into statement

Answer: C

Question 3

To use the overwrite option on insert, which privilege must be granted to the role?

A : truncate

B : DELETE

C : UPDATE

D : SELECT

Answer: B

Question 4

A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?

A : SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME FROM ACCOUNT_USAGE.USERS;

B : SELECT EVENT_TIMESTAMP, USER_NAME FROM table(information_schema.login_history_by_user())

C : SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.ACCESS_HISTORY;

D : SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.LOGIN_HISTORY;

Answer: D

Question 5

If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

A : The columns that are queried in the select clause.

B : The columns with very high cardinality.

C : The columns with many different values.

D : The columns most actively used in the select filters.

Answer: D

Page: 1 / 171

Total 851 Questions | Updated On: Oct 07, 2022

Add To Cart