CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Snowflake
  5. COF-R02

Free COF-R02 Exam Braindumps (page: 31)

Page 30 of 83
PDF with 330 Questions

What is a best practice after creating a custom role?

  1. Create the custom role using the SYSADMIN role.
  2. Assign the custom role to the SYSADMIN role
  3. Assign the custom role to the PUBLIC role
  4. 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.



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

  1. Materialized views
  2. Sequences
  3. Procedures
  4. Tables
  5. 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



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

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

Answer(s): A



Which Snowflake partner specializes in data catalog solutions?

  1. Alation
  2. DataRobot
  3. dbt
  4. 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






Post your Comments and Discuss Snowflake COF-R02 exam with other Community members:

COF-R02 Discussions & Posts