Snowflake Exam ARA-R01 Topic 1 Question 12 Discussion

Actual exam question for Snowflake's ARA-R01 exam

Question #: 12
Topic #: 1

A company is following the Data Mesh principles, including domain separation, and chose one Snowflake account for its data platform.

An Architect created two data domains to produce two data products. The Architect needs a third data domain that will use both of the data products to create an aggregate data product. The read access to the data products will be granted through a separate role.

Based on the Data Mesh principles, how should the third domain be configured to create the aggregate product if it has been granted the two read roles?

AUse secondary roles for all users.

BCreate a hierarchy between the two read roles.

CRequest a technical ETL user with the sysadmin role.

DRequest that the two data domains share data using the Data Exchange.

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 Sabra at Jul 03, 2024, 05:41 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Ricarda

8 months ago

Sysadmin role for a simple aggregation? Someone's been watching too many hacking movies!

upvoted 0 times

Sharen

7 months ago

D) Request that the two data domains share data using the Data Exchange.

upvoted 0 times

...

Sylvia

7 months ago

Sysadmin role for a simple aggregation? Someone's been watching too many hacking movies!

upvoted 0 times

...

Marge

7 months ago

B) Create a hierarchy between the two read roles.

upvoted 0 times

...

Regenia

7 months ago

A) Use secondary roles for all users.

upvoted 0 times

...

Brittni

8 months ago

I think requesting that the two data domains share data using the Data Exchange would be the best option.

upvoted 0 times

...

Dexter

8 months ago

C) Requesting a sysadmin user? That's overkill! B) is the way to go, keep it simple and secure.

upvoted 0 times

Blondell

7 months ago

A) Using secondary roles for all users could also work to maintain security.

upvoted 0 times

...

Ashleigh

7 months ago

C) Agreed, requesting a sysadmin user seems unnecessary.

upvoted 0 times

...

Shaniqua

7 months ago

B) Create a hierarchy between the two read roles.

upvoted 0 times

...

Rebecka

8 months ago

C) Requesting a sysadmin user? That's overkill! B) is the way to go, keep it simple and secure.

upvoted 0 times

...

Regenia

8 months ago

B) Create a hierarchy between the two read roles.

upvoted 0 times

...

Melynda

8 months ago

A) Use secondary roles for all users.

upvoted 0 times

...

Son

8 months ago

I disagree, I believe we should use secondary roles for all users to maintain separation.

upvoted 0 times

...

Emmett

8 months ago

I'm torn between B) and D), but I think B) is the simpler and more elegant solution. Data Mesh is all about autonomy, and hierarchy seems to fit that better.

upvoted 0 times

...

Idella

8 months ago

D) Sharing data using the Data Exchange makes sense, but it might add an extra layer of complexity. I'd go with B) for a cleaner solution.

upvoted 0 times

Nicolette

8 months ago

Yeah, it would keep things organized and easier to manage in the long run.

upvoted 0 times

...

Cary

8 months ago

I agree, creating a hierarchy between the two read roles seems like a simpler solution.

upvoted 0 times

...

Eladia

8 months ago

B) Create a hierarchy between the two read roles seems like the right approach. That way, the third domain can access the required data without needing a separate technical user.

upvoted 0 times