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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake ADA-C01 Exam - Topic 1 Question 21 Discussion

The following commands were executed:Grant usage on database PROD to role PROD_ANALYST;Grant usage on database PROD to role PROD_SUPERVISOR;Grant ALL PRIVILEGES on schema PROD. WORKING to role PROD_ANALYST;Grant ALL PRIVILEGES on schema PROD. WORKING to role PROD_SUPERVISOR;Grant role PROD ANALYST to user A;Grant role PROD SUPERVISOR to user B;What authority does each user have on the WORKING schema?
D) Both user A and user B can create tables in the PROD. WORKING schema.
A) Only user B can create tables, because all privileges were transferred to PROD_SUPERVISOR.
B) Tables created by either user A or user B will be visible to both users.
C) All existing tables in schema PROD. WORKING will be visible to both users.

Snowflake ADA-C01 Exam - Topic 1 Question 21 Discussion

Actual exam question for Snowflake's ADA-C01 exam
Question #: 21
Topic #: 1
[All ADA-C01 Questions]

The following commands were executed:

Grant usage on database PROD to role PROD_ANALYST;

Grant usage on database PROD to role PROD_SUPERVISOR;

Grant ALL PRIVILEGES on schema PROD. WORKING to role PROD_ANALYST;

Grant ALL PRIVILEGES on schema PROD. WORKING to role PROD_SUPERVISOR;

Grant role PROD ANALYST to user A;

Grant role PROD SUPERVISOR to user B;

What authority does each user have on the WORKING schema?

Show Suggested Answer Hide Answer
Suggested Answer: D

by Sherman at Aug 27, 2024, 02:57 AM

Limited Time Offer

25%

Off

Get Premium ADA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Tricia
8 months ago
So, does that mean user A can also modify existing tables?
upvoted 0 times
...
Sarah
8 months ago
Yeah, all tables will be visible to both users too!
upvoted 0 times
...
Peggie
8 months ago
Wait, are you sure? I thought only user B could create tables.
upvoted 0 times
...
Alesia
8 months ago
Totally agree, they can both create tables!
upvoted 0 times
...
Val
8 months ago
User A and B both have ALL PRIVILEGES on the schema.
upvoted 0 times
...
Merissa
9 months ago
I’m leaning towards option D because it seems like both roles were given similar privileges, but I might be mixing up some details from our last review session.
upvoted 0 times
...
Darci
9 months ago
I feel like user B definitely has the authority to create tables since they got all privileges too, but I’m not confident about user A's permissions.
upvoted 0 times
...
Jeffrey
9 months ago
I remember a practice question where we discussed visibility of tables between users. I think both users can see existing tables, but I'm confused about their ability to create new ones.
upvoted 0 times
...
Tonja
9 months ago
I think user A has the ability to create tables because they were granted ALL PRIVILEGES on the schema. But I'm not entirely sure if user B has the same rights.
upvoted 0 times
...
German
9 months ago
I think I've got a good handle on this. The key is recognizing that the ALL PRIVILEGES grants to the roles apply to the WORKING schema.
upvoted 0 times
...
Alease
9 months ago
I'm a bit confused by all the different permissions being granted. I'll need to make sure I fully understand the implications of each command.
upvoted 0 times
...
Franklyn
9 months ago
Okay, let me think this through step-by-step. The key is understanding how the privileges are being assigned to the roles and users.
upvoted 0 times
...
Pura
9 months ago
Hmm, this looks like a tricky one. I'll need to carefully read through the permissions granted to each role and user.
upvoted 0 times
...
Candra
9 months ago
I remember discussing how incentives like free yarn could motivate new posters, but I'm not sure if it would really work long-term.
upvoted 0 times
...
Linette
10 months ago
I think the PAC file is primarily used for redirection, but I'm a bit unsure if it's specific to a proxy type.
upvoted 0 times
...
Willie
2 years ago
Wait, what? I thought the goal was to grant privileges, not take them away. I'm going to have to go with A on this one.
upvoted 0 times
Stanton
2 years ago
Josephine: Oh, I see. Thanks for clarifying!
upvoted 0 times
...
Carri
2 years ago
I agree with Carri, both users have the authority to create tables.
upvoted 0 times
...
Josephine
2 years ago
No, both user A and user B can create tables in the WORKING schema.
upvoted 0 times
...
Iesha
2 years ago
I think user B has all the privileges on the WORKING schema.
upvoted 0 times
...
...
Leonida
2 years ago
This is a classic database permissions question. I'm confident the answer is D. Both users can create tables since they were granted the necessary privileges.
upvoted 0 times
Christa
2 years ago
Great, thanks for confirming. It's important to understand database permissions for different roles and users.
upvoted 0 times
...
Almeta
2 years ago
Yes, that's correct. User A and user B can both create tables in the PROD. WORKING schema.
upvoted 0 times
...
Casey
2 years ago
I think the answer is D. Both users have the authority to create tables in the WORKING schema.
upvoted 0 times
...
...
Alverta
2 years ago
I believe the correct answer is D, as both users have been granted the necessary roles and privileges.
upvoted 0 times
...
Shannon
2 years ago
I'm not sure, but I think the answer might be B, as tables created by either user could be visible to both.
upvoted 0 times
...
Thaddeus
2 years ago
Ha, what a tricky question! I'm going with C. All existing tables in the PROD. WORKING schema will be visible to both users, but I'm not sure about creating new ones.
upvoted 0 times
Carmelina
2 years ago
I agree with you, D seems to be the most logical choice here.
upvoted 0 times
...
Fernanda
2 years ago
I think D is the correct answer. Both user A and user B can create tables in the PROD. WORKING schema.
upvoted 0 times
...
...
Queenie
2 years ago
I agree with Georgene, user A and user B should both be able to create tables.
upvoted 0 times
...
Viola
2 years ago
Hmm, I'm not so sure. I think the answer might be B. The tables created by either user should be visible to both users since they were both granted usage on the database and all privileges on the schema.
upvoted 0 times
Galen
2 years ago
No, I believe it's B. Tables created by either user will be visible to both.
upvoted 0 times
...
Jaime
2 years ago
I think the answer is D. Both users can create tables in the WORKING schema.
upvoted 0 times
...
...
Georgene
2 years ago
I think the answer is D, because both users have been granted the necessary roles.
upvoted 0 times
...
Milly
2 years ago
I think the correct answer is D. Both user A and user B can create tables in the PROD. WORKING schema since they were both granted ALL PRIVILEGES on that schema.
upvoted 0 times
Renay
2 years ago
It's good to know that both users have the same level of authority on the WORKING schema.
upvoted 0 times
...
Dominque
2 years ago
That's correct, since both users were granted ALL PRIVILEGES on the schema, they can both create tables.
upvoted 0 times
...
Rodney
2 years ago
I agree with you, user A and user B both have the authority to create tables in the PROD. WORKING schema.
upvoted 0 times
...
...

Save Cancel