New Year Sale 2026! 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 3 Question 47 Discussion

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

Review the output of the SHOW statement below which displays the current grants on the table DB1. S1. T1:

This statement is executed:

USE ROLE ACCOUNTADMIN;

DROP ROLE A;

What will occur?

Show Suggested Answer Hide Answer
Suggested Answer: D

Dropping role A does not affect the SELECT privileges granted to roles B and C on the table DB1.S1.T1. According to theSnowflake documentation, dropping a role revokes all privileges granted to the role, but does not revoke any privileges granted by the role. Therefore, the OWNERSHIP privilege on the table DB1.S1.T1 will be revoked from role A, but the SELECT privileges granted by role A to role B and by role B to role C will remain. The GRANTED_BY column will still show the original grantor of the privilege, not the ACCOUNTADMIN role.


by ARR at Jan 10, 2026, 09: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
Paz
4 days ago
I remember something about ownership and privileges, but I'm not entirely sure how dropping a role affects them.
upvoted 0 times
...
Barbra
9 days ago
This is a tricky one. I'll have to think it through carefully.
upvoted 0 times
...
Daisy
15 days ago
Haha, I bet the person who wrote this question was having a bad day.
upvoted 0 times
...
Lemuel
20 days ago
D is the right answer. The SELECT privileges for roles B and C will remain.
upvoted 0 times
...
Alana
25 days ago
I'm not sure about this one. The question is a bit confusing.
upvoted 0 times
...
Caprice
1 month ago
Option B seems correct. The OWNERSHIP privilege on the table should be transferred to the ACCOUNTADMIN role.
upvoted 0 times
...
Salena
1 month ago
I'm a little uncertain about the correct answer here. I'll need to carefully review the information provided and think through the potential impacts of dropping the role.
upvoted 0 times
...
Flo
1 month ago
I feel pretty confident about this one. The DROP ROLE A statement will not affect the table itself, but it will remove any grants that role A had on the table. The other roles' grants should remain unchanged.
upvoted 0 times
...
Tyisha
2 months ago
Okay, let me think this through step-by-step. The SHOW statement indicates that role A has some grants on the table. The DROP ROLE A command should remove those grants, but I'm not sure about the other roles.
upvoted 0 times
...
Denny
2 months ago
I'm a bit confused by the wording of the question. Does the DROP ROLE A statement affect the table grants, or is it just about the role itself?
upvoted 0 times
...
Ryan
2 months ago
I think I know how to approach this question. The key is to carefully analyze the SHOW statement output and the subsequent SQL commands to determine the impact on the table's grants.
upvoted 0 times
...

Save Cancel