Snowflake ARA-R01 Exam - Topic 3 Question 11 Discussion

Actual exam question for Snowflake's ARA-R01 exam

Question #: 11
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 Loreta at Jun 19, 2024, 08:39 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Ashleigh

3 months ago

Sounds too easy, I doubt it's that straightforward.

upvoted 0 times

...

Blythe

3 months ago

Definitely option A, makes sense with imported privileges.

upvoted 0 times

...

Rosalind

3 months ago

Wait, are you sure? I thought grants were always required.

upvoted 0 times

...

Silva

4 months ago

I think that's true, no extra grants needed!

upvoted 0 times

...

Micheline

4 months ago

A new table will be visible to the consumer automatically.

upvoted 0 times

...

Lavonda

4 months ago

I recall that if a new table is added, the provider needs to grant access for it to be visible to the consumer. So, I think it could be option D, but I'm not completely confident.

upvoted 0 times

...

Mindy

4 months ago

I practiced a question like this before, and I feel like the consumer needs to be granted something on their side to see new tables. So, I might lean towards option B.

upvoted 0 times

...

Demetra

4 months ago

I'm not entirely sure, but I remember something about needing to grant privileges on the provider side for new tables. Maybe option C or D?

upvoted 0 times

...

Rolande

5 months ago

I think the consumer role will automatically see the new table since they have the imported privileges. It seems like that's how it works in similar scenarios.

upvoted 0 times

...

Lashonda

5 months ago

Based on my understanding, the correct answer is D. The provider will need to grant the necessary permissions on the new table to the data share for the consumer to access it. The "imported privileges" don't automatically extend to new objects.

upvoted 0 times

...

Gilberto

5 months ago

I'm a bit confused on this one. The wording about the "imported privileges" privilege makes me think the answer could be A, but I'm not 100% sure. I'll need to re-read the question carefully.

upvoted 0 times

...

Isabelle

5 months ago

I'm pretty confident that the answer is B. The consumer role will need an additional grant on the consumer side to see the new table, since the "imported privileges" only apply to the initial shared tables.

upvoted 0 times

...

Georgiann

5 months ago

Okay, let me break this down step-by-step. The key information is that the consumer role has the "imported privileges" privilege, so that should give me a clue on how the new table will be handled.

upvoted 0 times

...

Ariel

5 months ago

Hmm, this seems like a tricky one. I'll need to carefully read through the options and think about the implications of the data share setup.

upvoted 0 times

...

Martina

5 months ago

Okay, I remember learning about Cisco's PnP Connect in one of my networking classes. I believe the correct answer is B, pnp.cisco.com. That sounds like the right server name for onboarding an IR1101 using the IoT Operations Dashboard.

upvoted 0 times

...

Marget

5 months ago

This seems straightforward - using a version control system like Git is the way to go for managing Terraform code and collaborating with the team.

upvoted 0 times

...

Carlee

5 months ago

I think the answer is A - using routing rules. That seems like the most straightforward way to automate the process of adding cases to a queue.

upvoted 0 times

...

Joni

5 months ago

I remember a practice question that asked about safeguarding data, and I think it was about penetration testing. That said, I could confuse it with vulnerability assessments.

upvoted 0 times

...

Mary

2 years ago

Option A would be nice, but I doubt the system is that automated. The provider will definitely need to do some manual work to share the new table.

upvoted 0 times

...

Junita

2 years ago

Haha, if I was the data provider, I'd just forget to grant access to the new table and watch the consumers freak out!

upvoted 0 times

...

Malcom

2 years ago

I'm pretty sure the provider needs to do some additional grants for the new table. Option D looks like the most comprehensive solution.

upvoted 0 times

Avery

2 years ago

Agreed, Option D covers all the bases for granting access to table_6.

upvoted 0 times

...

Paulene

2 years ago

It's important to make sure the consumer role has the proper privileges to access the new table.

upvoted 0 times

...

Loren

2 years ago

Yes, Option D includes all the necessary grants on the provider side for the consumer to see the new table.

upvoted 0 times

...

Pansy

2 years ago

I think Option D is the best choice for granting access to the new table.

upvoted 0 times

...

Jerrod

2 years ago

Option C is the correct answer. The provider needs to grant select access on the new table to the shared database.

upvoted 0 times

Carlota

2 years 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

...

Tatum

2 years 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

...

Ronny

2 years 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

...