Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake Exam ARA-R01 Topic 3 Question 25 Discussion

Actual exam question for Snowflake's ARA-R01 exam
Question #: 25
Topic #: 3
[All ARA-R01 Questions]

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?

Show Suggested Answer Hide 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


Contribute your Thoughts:

Corrina
2 months ago
Looks like the provider is playing a game of 'keep the data away from the consumer.' Let's hope they're not too stingy.
upvoted 0 times
...
Ricarda
2 months ago
Ah, the joys of data sharing. I'm sure this is just the beginning of the fun.
upvoted 0 times
Mollie
2 months ago
C) The 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;
upvoted 0 times
...
Dong
2 months ago
B) The 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;
upvoted 0 times
...
Aretha
2 months ago
A) The consumer role will automatically see the new table and no additional grants are needed.
upvoted 0 times
...
...
Ernie
3 months ago
I think the consumer role will need a grant on the provider side to see the new table.
upvoted 0 times
...
Youlanda
3 months ago
I agree with Lonny, the consumer role will need a grant on the consumer side to access the new table.
upvoted 0 times
...
Erick
3 months ago
Hold up, why do I have to do all this manual grant business? Shouldn't it just work automatically?
upvoted 0 times
Ryann
2 months ago
D) The 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 ;
upvoted 0 times
...
Marge
2 months ago
B) The 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;
upvoted 0 times
...
Detra
2 months ago
C) The 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;
upvoted 0 times
...
Sol
3 months ago
A) The consumer role will automatically see the new table and no additional grants are needed.
upvoted 0 times
...
...
Lonny
3 months ago
I believe the consumer role will need a grant on the consumer side to see the new table.
upvoted 0 times
...
Lenna
3 months ago
Hmm, I think option C is the way to go. Gotta make sure that provider side grant is in place.
upvoted 0 times
Tomoko
2 months ago
Yes, the provider side grant is crucial for the consumer role to see the new table.
upvoted 0 times
...
Adria
3 months ago
I agree, option C seems like the correct choice.
upvoted 0 times
...
...
Ruthann
3 months ago
I think the consumer role will automatically see the new table.
upvoted 0 times
...
Filiberto
3 months ago
The data provider is really keeping us on our toes here! I bet they've got a trick up their sleeve.
upvoted 0 times
Corrina
2 months ago
D) The 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 ;
upvoted 0 times
...
Buddy
2 months ago
C) The 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;
upvoted 0 times
...
Delisa
2 months ago
B) The 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;
upvoted 0 times
...
Thomasena
2 months ago
A) The consumer role will automatically see the new table and no additional grants are needed.
upvoted 0 times
...
...

Save Cancel