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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake ARA-R01 Exam - Topic 2 Question 45 Discussion

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?
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 ;
A) The consumer role will automatically see the new table and no additional grants are needed.
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;
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;

Snowflake ARA-R01 Exam - Topic 2 Question 45 Discussion

Actual exam question for Snowflake's ARA-R01 exam
Question #: 45
Topic #: 2
[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


by Lucille at May 08, 2026, 05:11 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Emerson
1 day ago
I think B) makes more sense, grants are needed.
upvoted 0 times
...
Cecily
7 days ago
A) is correct, new tables auto show up!
upvoted 0 times
...
Tyisha
12 days ago
I’m leaning towards option D because it mentions granting usage on both the database and schema, which seems comprehensive. But I could be wrong!
upvoted 0 times
...
Winifred
17 days ago
I feel like we discussed how new tables need specific grants on the provider side. So, options C and D could be relevant here.
upvoted 0 times
...
Jillian
22 days ago
I remember a similar question where we had to grant privileges on the consumer side. Maybe option B is the right choice this time?
upvoted 0 times
...
Lawanda
27 days ago
I think the consumer account will automatically see the new table since they have the imported privileges, but I'm not entirely sure.
upvoted 0 times
...
Margarett
1 month ago
I vaguely remember that for the consumer to access new tables, there are multiple grants involved, especially on the provider side. Option D seems like it covers that.
upvoted 0 times
...
Clare
3 months ago
I feel like the provider needs to grant permissions for the new table, but I can't recall if it's just for the table or the whole schema.
upvoted 0 times
...
Felicitas
3 months ago
I think I practiced a similar question where the consumer needed specific grants to see new tables. It might be option B?
upvoted 0 times
...
Cyndy
3 months ago
I remember something about how new tables in shared schemas work, but I'm not sure if they automatically appear for the consumer.
upvoted 0 times
...

Save Cancel