Confidently Practice Online with Free COF-C02 Exam Cram

Practice your SnowPro Core Certification certification test with free COF-C02 exam cram and take control of your certification preparation. At FreeExamCram, you can practice online for free using real COF-C02 exam dumps, verified questions, and expert-designed free online practice tests. Moreover our Snowflake COF-C02 exam cram backed by our confidence-boosting refund guarantee.

Question 1

A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers. How can this requirement be met?

Options :

A : Use data encryption.

B : Use dynamic data masking.

C : Use secure materialized views.

D : Revoke all roles for functional managers and end users.

Answer: B

Question 2

Which command should be used to load data from a local computer into Snowflake?

Options :

A : CREATE EXTERNAL TABLE

B : COPY INTO

C : INSERT

D : PUT

Answer: B

Question 3

What is a characteristic of the Snowflake Query Profile?

Options :

A : It can provide statistics on a maximum number of 100 queries per week.

B : It provides a graphic representation of the main components of the query processing.

C : It provides detailed statistics about which queries are using the greatest number of compute resources.

D : It can be used by third-party software using the Query Profile API.

Answer: B

Question 4

Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should be assigned to which role?

Options :

A : ACCOUNTADMIN

B : SECURITYADMIN

C : SYSADMIN

D : USERADMIN

Answer: A

Question 5

At what levels can a resource monitor be configured? (Select TWO).

Options :

A : Account

B : Database

C : Organization

D : Schema

E : Virtual warehouse

Answer: A,E