MENU
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?
Suggested Answer: D
Get Premium ARA-C01 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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
35 comments · newest first
NA
Nana
11 months ago
I doubt it, seems like there should be more permissions involved.
IZ
Izetta
11 months ago
Definitely option A, no extra steps required.
KR
Kristeen
11 months ago
Surprised that new tables aren't automatically visible!
OL
Oliva
11 months ago
I think that's wrong, additional grants are needed.
FL
Floyd
11 months ago
The consumer role will automatically see the new table!
AN
Annmarie
12 months ago
I think option D sounds like it covers all the bases, but it seems a bit excessive. I just hope I remember the specifics about the grants correctly!
LI
Lindsay
12 months ago
I'm a bit confused about whether the consumer role needs additional grants or not. I feel like I saw something similar where it required a grant on the consumer side.
ER
Erin
12 months ago
I remember a practice question where we had to grant privileges on the provider side for new tables. It feels like option C might be the right choice here.
KE
Keneth
1 year ago
I think if a new table is added, the consumer account should automatically see it because of the imported privileges, right? But I'm not completely sure.
GE
Geoffrey
1 year ago
Ah, I see. This is all about the data sharing setup and the specific privileges that have been granted. I'll need to carefully evaluate each answer choice to determine the correct one.
MO
Mollie
1 year ago
Alright, let me walk through this step-by-step. The consumer role has the "imported privileges" privilege, so that's important. And the question is asking what will happen if a new table is added to the provider schema. I'll need to think about the different grant options.
KA
Kanisha
1 year ago
I think the key here is understanding how the data sharing works between the provider and consumer accounts. The new table was added to the provider schema, so I'll need to consider how that impacts the consumer side.
AL
Aliza
1 year ago
Okay, let me see here. The question says the consumer role has been granted the "imported privileges" privilege, so that's a good starting point.
BR
Brice
1 year ago
Hmm, this one seems tricky. I'll need to carefully read through the options and think about the privileges that have been granted.
TA
Tammi
2 years ago
Attention, fellow data wizards! The answer is clearly C, unless you want to get lost in a maze of grant statements.
AR
Arlen
2 years ago
Wait, did they just throw in a new table to test our knowledge? Sneaky, but I think C is the way to go.
CH
Chery
2 years ago
Exactly, it's important to understand how data sharing and privileges work in this scenario.
LO
Louvenia
2 years ago
That makes sense, we have to give the necessary privileges for the consumer role to access the new table.
OL
Olive
2 years ago
I agree, we need to grant select on the provider side for the consumer to see the new table.
JA
Janessa
2 years ago
I think C is the correct answer.
HE
Helene
2 years 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.
DO
Donette
2 years ago
Haha, I bet the exam writer is just trying to confuse us. I'm going with B, gotta keep it simple!
BU
Buddy
2 years ago
Let's go with B then, simplicity is key.
WH
Whitney
2 years ago
I'm not sure, but B does seem like the most straightforward option.
GL
Gladys
2 years ago
Yeah, keeping it simple is usually the best approach.
JA
Jarod
2 years ago
I think B is the right answer too.
VA
Vallie
2 years ago
Oh, this is a tricky one! I bet the answer is D, that's the most comprehensive grant statement.
ST
Stevie
2 years ago
I agree with you, D seems to be the most comprehensive grant statement.
EL
Ellsworth
2 years ago
I think the answer is A, the consumer role will automatically see the new table.
VA
Vannessa
2 years ago
Hmm, I'm thinking the answer is C. The provider needs to grant the access to the new table explicitly.
RO
Rose
2 years ago
Yes, the consumer role will only see the new table after the grant is given on the provider side.
CA
Cathrine
2 years ago
I agree, the provider needs to grant access to the new table on their side.
KA
Katie
2 years ago
I agree with you, Mozell. It seems like the consumer role needs a grant on the consumer side to see the new table.
MO
Mozell
2 years ago
I believe the consumer role will see the table only after a grant is given on the consumer side.
KA
Katie
2 years ago
I think the consumer role will automatically see the new table.