Snowflake Exam ARA-C01 Topic 2 Question 44 Discussion

Actual exam question for Snowflake's ARA-C01 exam

Question #: 44
Topic #: 2

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 Shizue at Jan 14, 2025, 11:03 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Tammi

2 months ago

Attention, fellow data wizards! The answer is clearly C, unless you want to get lost in a maze of grant statements.

upvoted 0 times

...

2 months ago

Haha, I bet the exam writer is just trying to confuse us. I'm going with B, gotta keep it simple!

upvoted 0 times

Buddy

22 days ago

Let's go with B then, simplicity is key.

upvoted 0 times

...

Whitney

26 days ago

I'm not sure, but B does seem like the most straightforward option.

upvoted 0 times

...

Gladys

1 months ago

Yeah, keeping it simple is usually the best approach.

upvoted 0 times

...

Jarod

1 months ago

I think B is the right answer too.

upvoted 0 times

...

3 months ago

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

upvoted 0 times

...