Snowflake Exam ARA-R01 Topic 4 Question 14 Discussion

Actual exam question for Snowflake's ARA-R01 exam

Question #: 14
Topic #: 4

[All ARA-R01 Questions]

In a managed access schema, what are characteristics of the roles that can manage object privileges? (Select TWO).

AUsers with the SYSADMIN role can grant object privileges in a managed access schema.

BUsers with the SECURITYADMIN role or higher, can grant object privileges in a managed access schema.

CUsers who are database owners can grant object privileges in a managed access schema.

DUsers who are schema owners can grant object privileges in a managed access schema.

EUsers who are object owners can grant object privileges in a managed access schema.

Show Suggested Answer

Suggested Answer: D

In the scenario described, where a third data domain needs access to two existing data products in a Snowflake account structured according to Data Mesh principles, the best approach is to utilize Snowflake's Data Exchange functionality. Option D is correct as it facilitates the sharing and governance of data across different domains efficiently and securely. Data Exchange allows domains to publish and subscribe to live data products, enabling real-time data collaboration and access management in a governed manner. This approach is in line with Data Mesh principles, which advocate for decentralized data ownership and architecture, enhancing agility and scalability across the organization. Reference:

Snowflake Documentation on Data Exchange

Articles on Data Mesh Principles in Data Management

by Tresa at Jul 13, 2024, 08:38 PM

Limited Time Offer

25%

Off

Get Premium ARA-R01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Carlota

7 hours ago

I agree with Janella. I think B and D are the right answers here. SECURITYADMIN and schema owners have the necessary privileges to manage object privileges.

upvoted 0 times

...

Ria

2 days ago

I think A) Users with the SYSADMIN role can grant object privileges in a managed access schema.

upvoted 0 times

...

Janella

4 days ago

Options B and D seem correct to me. Users with the SECURITYADMIN role or higher, and users who are schema owners, can grant object privileges in a managed access schema.

upvoted 0 times

...