Snowflake Exam ARA-R01 Topic 3 Question 15 Discussion

Actual exam question for Snowflake's ARA-R01 exam

Question #: 15
Topic #: 3

The data share exists between a data provider account and a data consumer account. Five tables from the provider account are being shared with the consumer account. The consumer role has been granted the imported privileges privilege.

What will happen to the consumer account if a new table (table_6) is added to the provider schema?

AThe consumer role will automatically see the new table and no additional grants are needed.

BThe consumer role will see the table only after this grant is given on the consumer side:
grant imported privileges on database PSHARE_EDW_4TEST_DB to DEV_ROLE;

CThe consumer role will see the table only after this grant is given on the provider side:
use role accountadmin;
Grant select on table EDW.ACCOUNTING.Table_6 to share PSHARE_EDW_4TEST;

DThe consumer role will see the table only after this grant is given on the provider side:
use role accountadmin;
grant usage on database EDW to share PSHARE_EDW_4TEST ;
grant usage on schema EDW.ACCOUNTING to share PSHARE_EDW_4TEST ;
Grant select on table EDW.ACCOUNTING.Table_6 to database PSHARE_EDW_4TEST_DB ;

Show Suggested Answer

Suggested Answer: D

When a new table (table_6) is added to a schema in the provider's account that is part of a data share, the consumer will not automatically see the new table. The consumer will only be able to access the new table once the appropriate privileges are granted by the provider. The correct process, as outlined in option D, involves using the provider's ACCOUNTADMIN role to grant USAGE privileges on the database and schema, followed by SELECT privileges on the new table, specifically to the share that includes the consumer's database. This ensures that the consumer account can access the new table under the established data sharing setup. Reference:

Snowflake Documentation on Managing Access Control

Snowflake Documentation on Data Sharing

by Vincenza at Aug 04, 2024, 09:11 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Gabriele

6 months ago

I think the consumer role will need a grant on the provider side to see the new table.

upvoted 0 times

...

Verdell

6 months ago

I agree with Lucia, the consumer role will need a grant on the consumer side.

upvoted 0 times

...

Lucia

6 months ago

I believe the consumer role will need a grant on the consumer side to see the new table.

upvoted 0 times

...

Dorsey

6 months ago

I think the consumer role will automatically see the new table.

upvoted 0 times

...

Karma

7 months ago

Hmm, let me think this through... I'd say C is the way to go. Gotta keep that data secure, am I right?

upvoted 0 times

Rueben

6 months ago

C is the way to go for sure.

upvoted 0 times

...

Janna

6 months ago

Definitely, we need to ensure data security at all times.

upvoted 0 times

...

Filiberto

6 months ago

Agreed, granting access on the provider side seems like the right move.

upvoted 0 times

...

Roxane

7 months ago

I think C is the best option for security.

upvoted 0 times

...

Leila

7 months ago

I think the consumer role will need a grant on the provider side to see the new table.

upvoted 0 times

...

Jesus

7 months ago

I agree with Novella, the consumer role will need a grant on the consumer side to access the new table.

upvoted 0 times

...

Theron

7 months ago

This question is making me thirsty. Anyone else want to grab a Snowflake while we figure this out?

upvoted 0 times

...

Marica

7 months ago

I'm pretty sure the answer is B. The consumer role needs to be granted the imported privileges to see the new table.

upvoted 0 times

Maurine

7 months ago

Yes, that's correct. The imported privileges need to be granted to the consumer role for them to see the new table.

upvoted 0 times

...

Madelyn

7 months ago

I think you're right, the consumer role will only see the new table after the grant is given on the consumer side.

upvoted 0 times

...

Novella

7 months ago

I believe the consumer role will need a grant on the consumer side to see the new table.

upvoted 0 times

...

Earlean

8 months ago

D seems more comprehensive, covering database and schema level grants as well. Gotta cover all the bases, you know?

upvoted 0 times

...

Regenia

8 months ago

I think the consumer role will automatically see the new table.

upvoted 0 times

...

Emelda

8 months ago

I think the answer is C. The provider needs to grant access to the new table for the consumer to see it.

upvoted 0 times

Irving

7 months ago

I'm leaning towards D. The consumer role will see the table only after a grant is given on the provider side.

upvoted 0 times

...

Tasia

7 months ago

I agree with C. The consumer role will see the table only after a grant is given on the provider side.

upvoted 0 times

...

Franklyn

7 months ago

Yes, the consumer role will need the grant on the provider side to access the new table.

upvoted 0 times

...

Vernice

7 months ago

I think option C is the correct one. The consumer role will only see the new table after the grant is given on the provider side.

upvoted 0 times

...

Sue

7 months ago

I think it's B. The consumer role will see the table only after a grant is given on the consumer side.

upvoted 0 times

...

Jamey

7 months ago

I agree, the provider needs to grant access for the consumer to see the new table.

upvoted 0 times

...

Magda

8 months ago

I believe the answer is A. The consumer role will automatically see the new table.

upvoted 0 times

...