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-R01 Topic 2 Question 27 Discussion

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


Contribute your Thoughts:

Joseph
25 days ago
Haha, this question is like a game of 'hide and seek' for the new table. The answer is definitely D!
upvoted 0 times
Annett
4 days ago
No, I believe the correct answer is D) The consumer role will see the table only after this grant is given on the provider side.
upvoted 0 times
...
Erick
6 days ago
I think the answer is A) The consumer role will automatically see the new table and no additional grants are needed.
upvoted 0 times
...
...
Matthew
30 days ago
This question is a piece of cake! The answer is C, the provider has to grant access to the new table.
upvoted 0 times
Billy
17 days ago
I agree with C, the provider needs to grant access to the new table for the consumer role to see it.
upvoted 0 times
...
Casey
21 days ago
Actually, I think it's C, the consumer role will see the table only after a grant is given on the provider side.
upvoted 0 times
...
Velda
22 days ago
No, I believe it's B, the consumer role will see the table only after a grant is given on the consumer side.
upvoted 0 times
...
Camellia
23 days ago
I think the answer is A, the consumer role will automatically see the new table.
upvoted 0 times
...
...
Halina
2 months ago
I think the consumer role will need a grant on the provider side for the new table to be visible.
upvoted 0 times
...
Renato
2 months ago
I'm pretty sure the answer is A. The consumer should automatically see the new table since they have the imported privileges privilege.
upvoted 0 times
Glendora
22 days ago
I agree, the imported privileges privilege should allow the consumer to see the new table without any additional grants.
upvoted 0 times
...
Wenona
25 days ago
A) The consumer role will automatically see the new table and no additional grants are needed.
upvoted 0 times
...
...
Carey
2 months ago
I agree with Derrick, the consumer role will need a grant on the consumer side to access the new table.
upvoted 0 times
...
Derrick
2 months ago
I believe the consumer role will need a grant on the consumer side to see the new table.
upvoted 0 times
...
Dante
2 months ago
I think the consumer role will automatically see the new table.
upvoted 0 times
...
Dick
2 months ago
I think D is the correct answer. The provider needs to grant usage and select privileges on the new table.
upvoted 0 times
...
Quentin
2 months ago
The answer is obviously C. The provider needs to grant access to the new table for the consumer to see it.
upvoted 0 times
Myra
1 months ago
So, option C is the right answer in this case.
upvoted 0 times
...
Cory
2 months ago
Yes, that's correct. The provider needs to grant access to the new table for the consumer to see it.
upvoted 0 times
...
Lashaunda
2 months ago
I think the consumer role will only see the new table after the grant is given on the provider side.
upvoted 0 times
...
...

Save Cancel