Discuss Snowflake ARA-R01 Exam Topic 2 Question 45

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 ;

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

Get Premium ARA-R01 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

27 comments · newest first

Rolande 4 days ago

D seems excessive. Just adding a table shouldn't require all that.

Esteban 9 days ago

C is too complicated. I lean towards A.

Justine 14 days ago

I disagree, B makes more sense. Grants are needed on the consumer side.

Helga 19 days ago

I think A is correct. New tables should be visible automatically.

Margot 25 days ago

Exactly, security first!

Emily 30 days ago

True, but better safe than sorry, right?

Mollie 1 month ago

D covers all bases, but it's overkill.

Margot 1 month ago

Complexity ensures security, though.

Emily 2 months ago

C is too complicated. A is straightforward.

Margot 2 months ago

I lean towards C. Provider needs to grant access first.

Mollie 2 months ago

Because the new table needs explicit permissions.

Emily 2 months ago

But if privileges are imported, why need extra grants?

Mollie 2 months ago

I disagree, B makes more sense. Grants are essential.

Emily 2 months ago

I think A is correct. Automatic updates are efficient.

Casey 3 months ago

D) seems like overkill, why so many grants?

Shannon 3 months ago

C) is definitely wrong, it’s all about the consumer side.

Francoise 3 months ago

Wait, really? I thought new tables needed extra permissions!

Emerson 3 months ago

I think B) makes more sense, grants are needed.

Cecily 3 months ago

A) is correct, new tables auto show up!

Tyisha 3 months 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!

Winifred 4 months 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.

Jillian 4 months 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?

Lawanda 4 months ago

I think the consumer account will automatically see the new table since they have the imported privileges, but I'm not entirely sure.

Margarett 4 months 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.

Clare 6 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.

Felicitas 6 months ago

I think I practiced a similar question where the consumer needed specific grants to see new tables. It might be option B?

Cyndy 6 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.

Snowflake ARA-R01 Exam - Topic 2 Question 45 Discussion