Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location PL
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
9 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
7 months ago
Josephine: Oh, I see. Thanks for clarifying!
upvoted 0 times
...
Carri
8 months ago
I agree with Carri, both users have the authority to create tables.
upvoted 0 times
...
Josephine
8 months ago
No, both user A and user B can create tables in the WORKING schema.
upvoted 0 times
...
Iesha
8 months ago
I think user B has all the privileges on the WORKING schema.
upvoted 0 times
...
...
Leonida
9 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
8 months ago
Great, thanks for confirming. It's important to understand database permissions for different roles and users.
upvoted 0 times
...
Almeta
8 months ago
Yes, that's correct. User A and user B can both create tables in the PROD. WORKING schema.
upvoted 0 times
...
Casey
8 months ago
I think the answer is D. Both users have the authority to create tables in the WORKING schema.
upvoted 0 times
...
...
Alverta
9 months ago
I believe the correct answer is D, as both users have been granted the necessary roles and privileges.
upvoted 0 times
...
Shannon
9 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
9 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
9 months ago
I agree with you, D seems to be the most logical choice here.
upvoted 0 times
...
Fernanda
9 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
9 months ago
I agree with Georgene, user A and user B should both be able to create tables.
upvoted 0 times
...
Viola
10 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
9 months ago
No, I believe it's B. Tables created by either user will be visible to both.
upvoted 0 times
...
Jaime
9 months ago
I think the answer is D. Both users can create tables in the WORKING schema.
upvoted 0 times
...
...
Georgene
10 months ago
I think the answer is D, because both users have been granted the necessary roles.
upvoted 0 times
...
Milly
10 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
9 months ago
It's good to know that both users have the same level of authority on the WORKING schema.
upvoted 0 times
...
Dominque
9 months ago
That's correct, since both users were granted ALL PRIVILEGES on the schema, they can both create tables.
upvoted 0 times
...
Rodney
9 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
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77