QUESTION: 117

What is a best practice after creating a custom role?

Create the custom role using the SYSADMIN role.
Assign the custom role to the SYSADMIN role
Assign the custom role to the PUBLIC role
Add CUSTOM to all custom role names

Answer(s): B

Explanation:

When creating roles that will serve as the owners of securable objects in the system, Snowflake recommends creating a hierarchy of custom roles, with the top-most custom role assigned to the system role SYSADMIN. This role structure allows system administrators to manage all objects in the account, such as warehouses and database objects, while restricting management of users and roles to the USERADMIN role.

Reveal Solution Next Question

QUESTION: 118

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

Materialized views
Sequences
Procedures
Tables
Secure User Defined Functions (UDFs)

Answer(s): D,E

Explanation:

Secure Data Sharing enables sharing selected objects in a database in your account with other

Snowflake accounts. The following Snowflake database objects can be shared:
Tables
External tables Secure views
Secure materialized views Secure UDFs

Reference:

https://docs.snowflake.com/en/user-guide/data-sharing-intro.html

Reveal Solution Next Question

QUESTION: 119

Will data cached in a warehouse be lost when the warehouse is resized?

Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
Yes. because the compute resource is replaced in its entirety with a new compute resource.
No. because the size of the cache is independent from the warehouse size
Yes. became the new compute resource will no longer have access to the cache encryption key

Answer(s): A

Reveal Solution Next Question

QUESTION: 120

Which Snowflake partner specializes in data catalog solutions?

Alation
DataRobot
dbt
Tableau

Answer(s): A

Explanation:

Alation provides Data Cataloging functionality. They state they are the 'One Place to Find, Understand, & Govern Data Across an Enterprise.

Reference:

https://docs.snowflake.com/en/user-guide/ecosystem-all.html

Reveal Solution Next Question

Free COF-R02 Exam Braindumps (page: 30)

QUESTION: 117

Explanation:

QUESTION: 118

Explanation:

Reference:

QUESTION: 119

QUESTION: 120

Explanation:

Reference: