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 3 Question 47 Discussion

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?
D) The SELECT privileges for roles B and C will remain.
A) The table object DB1. S1. T1 will be dropped.
B) The OWNERSHIP privilege on table DB1. S1. T1 will be transferred to the ACCOUNTADMIN role.
C) The SELECT privilege on table DB1. S1. T1 to role B will be shown as GRANTED_BY the role ACCOUNTADMIN.

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
Tanesha
2 days ago
C implies changes, which might not happen.
upvoted 0 times
...
Julieta
7 days ago
C is tricky, but I lean towards it.
upvoted 0 times
...
Clement
13 days ago
But what about C?
upvoted 0 times
...
Leota
18 days ago
D makes sense, privileges stay.
upvoted 0 times
...
Tanesha
2 months ago
I feel it's D.
upvoted 0 times
...
Jaclyn
2 months ago
Because ACCOUNTADMIN takes over ownership.
upvoted 0 times
...
Clement
2 months ago
Why B?
upvoted 0 times
...
Jaclyn
3 months ago
I think it's B.
upvoted 0 times
...
Sophia
3 months ago
Wait, can you really drop a role like that?
upvoted 0 times
...
Kelvin
3 months ago
D should stay, I agree.
upvoted 0 times
...
Elke
3 months ago
C makes sense, right?
upvoted 0 times
...
Elbert
3 months ago
I think B is correct.
upvoted 0 times
...
Elena
3 months ago
A is definitely not happening.
upvoted 0 times
...
Sue
4 months ago
I'm a bit confused about the implications of dropping a role. Does it really affect the privileges granted to other roles?
upvoted 0 times
...
Azzie
4 months ago
This question feels similar to one we practiced where we discussed role privileges. I think the SELECT privileges for roles B and C should still be intact.
upvoted 0 times
...
Talia
4 months ago
I think if the role that owns the table is dropped, the ownership might transfer to the ACCOUNTADMIN, but I need to double-check that.
upvoted 0 times
...
Paz
5 months ago
I remember something about ownership and privileges, but I'm not entirely sure how dropping a role affects them.
upvoted 0 times
...
Barbra
5 months ago
This is a tricky one. I'll have to think it through carefully.
upvoted 0 times
...
Daisy
5 months ago
Haha, I bet the person who wrote this question was having a bad day.
upvoted 0 times
...
Lemuel
5 months ago
D is the right answer. The SELECT privileges for roles B and C will remain.
upvoted 0 times
...
Alana
5 months ago
I'm not sure about this one. The question is a bit confusing.
upvoted 0 times
...
Caprice
6 months ago
Option B seems correct. The OWNERSHIP privilege on the table should be transferred to the ACCOUNTADMIN role.
upvoted 0 times
...
Salena
6 months 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
6 months 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
6 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
6 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
6 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