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