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-C01 Topic 2 Question 44 Discussion

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

Tammi
1 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
...
Arlen
1 months ago
Wait, did they just throw in a new table to test our knowledge? Sneaky, but I think C is the way to go.
upvoted 0 times
Olive
6 days ago
I agree, we need to grant select on the provider side for the consumer to see the new table.
upvoted 0 times
...
Janessa
14 days ago
I think C is the correct answer.
upvoted 0 times
...
...
Helene
1 months ago
Woah, this question is like a game of 'find the hidden treasure' in the grant statements! I'm feeling lucky, let's go with D.
upvoted 0 times
...
Donette
1 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
Whitney
4 days ago
I'm not sure, but B does seem like the most straightforward option.
upvoted 0 times
...
Gladys
16 days ago
Yeah, keeping it simple is usually the best approach.
upvoted 0 times
...
Jarod
17 days ago
I think B is the right answer too.
upvoted 0 times
...
...
Vallie
1 months ago
Oh, this is a tricky one! I bet the answer is D, that's the most comprehensive grant statement.
upvoted 0 times
Stevie
24 days ago
I agree with you, D seems to be the most comprehensive grant statement.
upvoted 0 times
...
Ellsworth
1 months ago
I think the answer is A, the consumer role will automatically see the new table.
upvoted 0 times
...
...
Vannessa
2 months ago
Hmm, I'm thinking the answer is C. The provider needs to grant the access to the new table explicitly.
upvoted 0 times
Rose
30 days ago
Yes, the consumer role will only see the new table after the grant is given on the provider side.
upvoted 0 times
...
Cathrine
1 months ago
I agree, the provider needs to grant access to the new table on their side.
upvoted 0 times
...
...
Katie
2 months ago
I agree with you, Mozell. It seems like the consumer role needs a grant on the consumer side to see the new table.
upvoted 0 times
...
Mozell
2 months ago
I believe the consumer role will see the table only after a grant is given on the consumer side.
upvoted 0 times
...
Katie
2 months ago
I think the consumer role will automatically see the new table.
upvoted 0 times
...

Save Cancel