New Year Sale ! 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 Exam ADA-C01 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:

Submit Cancel
Willie
3 months 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 months ago
Josephine: Oh, I see. Thanks for clarifying!
upvoted 0 times
...
Carri
2 months ago
I agree with Carri, both users have the authority to create tables.
upvoted 0 times
...
Josephine
2 months ago
No, both user A and user B can create tables in the WORKING schema.
upvoted 0 times
...
Iesha
2 months ago
I think user B has all the privileges on the WORKING schema.
upvoted 0 times
...
...
Leonida
3 months 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 months ago
Great, thanks for confirming. It's important to understand database permissions for different roles and users.
upvoted 0 times
...
Almeta
2 months ago
Yes, that's correct. User A and user B can both create tables in the PROD. WORKING schema.
upvoted 0 times
...
Casey
3 months ago
I think the answer is D. Both users have the authority to create tables in the WORKING schema.
upvoted 0 times
...
...
Alverta
3 months ago
I believe the correct answer is D, as both users have been granted the necessary roles and privileges.
upvoted 0 times
...
Shannon
3 months 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
4 months 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
3 months ago
I agree with you, D seems to be the most logical choice here.
upvoted 0 times
...
Fernanda
3 months 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
4 months ago
I agree with Georgene, user A and user B should both be able to create tables.
upvoted 0 times
...
Viola
4 months 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
3 months ago
No, I believe it's B. Tables created by either user will be visible to both.
upvoted 0 times
...
Jaime
3 months ago
I think the answer is D. Both users can create tables in the WORKING schema.
upvoted 0 times
...
...
Georgene
4 months ago
I think the answer is D, because both users have been granted the necessary roles.
upvoted 0 times
...
Milly
4 months 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
3 months ago
It's good to know that both users have the same level of authority on the WORKING schema.
upvoted 0 times
...
Dominque
3 months ago
That's correct, since both users were granted ALL PRIVILEGES on the schema, they can both create tables.
upvoted 0 times
...
Rodney
3 months 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