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: Nov 21, 2024

Add To Cart

Question 1

A Snowflake share can only have one consumer account added to it.

A : True

B : False

Answer: B

Question 2

Which of the following roles are available out of the box in Snowflake?

A : ACCOUNTADMIN

B : USERADMIN

C : SECURITYADMIN

D : ROOT

Answer: A,B,C

Question 3

Which of the following ACCOUNT_USAGE view can be used to view the storage consumed by a database?

A : ACCOUNT_USAGE.TAGS

B : ACCOUNT_USAGE.DATABASES

C : ACCOUNT_USAGE. DATABASE_STORAGE_USAGE_HISTORY

D : ACCOUNT_USAGE.SESSIONS

Answer: C

Question 4

Which of the following correctly describes the query profile shown?

Select all that apply.

A : The query profile indicates that an active virtual warehouse was NOT required for this query.

B : The query profile indicates that the metadata cache was used.

C : The query profile indicates that results produced by a previous query were reused.

D : The query profile indicates that the virtual warehouse cache was used.

Answer: A,C

Question 5

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

Page: 1 / 279

Total 1392 Questions | Updated On: Nov 21, 2024

Add To Cart