Free Snowflake COF-C02 Exam Dumps Questions & Answers

What do temporary and transient tables have m common in Snowflake? (Select TWO).

• A.Both tables have data retention period maximums of one day.
• B.Both tables have no Fail-safe period.
• C.For both tables the retention period ends when the tables are dropped.
• D.Both tables are visible only to a single user session.
• E.For both tables, the retention period does not end when the session ends

What are characteristics of the ownership privilege when it is granted on a regular Snowflake schema? (Select TWO).

• A.It is automatically granted to the role that creates a database object within the schema.
• B.It must be granted to a role in order to alter warehouse settings.
• C.It allows a role to manage grants on the schema.
• D.It can be transferred from one role to another for a specific schema.
• E.It grants the ability to query data from the schema.

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

• A.SHOW GRANTS FOR ROLE MY_ROLE
• B.SHOW GRANTS TO ROLE MY_ROLE
• C.SHOW GRANTS OF ROLE MY_ROLE
• D.SHOW GRANTS ON ROLE MY_ROLE

By default, when is a resource monitor reset to 0?

• A.At the beginning of each month
• B.At the beginning of each week
• C.At the beginning of each day
• D.At the beginning of each year

What Snowflake authentication method is recommended to use for logging onto the Snowflake CLI?

• A.Single Sign-On (SSO) with Multi-Factor Authentication (MFA)
• B.Login and password
• C.Okta native authentication
• D.Key-pair authentication