COF-C02 Snowflake Exam Questions and Free Practice Test

Question 151

- (Topic 1)
What is a best practice after creating a custom role?

A. Create the custom role using the SYSADMIN role.

B. Assign the custom role to the SYSADMIN role

C. Assign the custom role to the PUBLIC role

D. Add CUSTOM to all custom role names

Correct Answer:B
Assigning the custom role to the SYSADMIN role is considered a best practice because it allows the SYSADMIN role to manage objects created by the custom role. This is important for maintaining proper access control and ensuring that the SYSADMIN can perform necessary administrative tasks on objects created by users with the custom role.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Section 1.3 - SnowPro Core Certification Study Guide1

Question 152

- (Topic 3)
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.

Correct Answer:D
When deciding on a clustering key for a table, Snowflake recommends using the columns that are most actively used in the select filters. This is because clustering by these columns can improve the performance of queries that filter on these values, leading to more efficient scans and better overall query performance2. References: [COF-C02] SnowPro Core Certification Exam Study Guide

START COF-C02 EXAM