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 COF-R02 Exam - Topic 4 Question 60 Discussion

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?
D) The assumed role that dropped the role
A) The tables are now orphaned
B) The user that deleted the role
C) SYSADMIN

Snowflake COF-R02 Exam - Topic 4 Question 60 Discussion

Actual exam question for Snowflake's COF-R02 exam
Question #: 60
Topic #: 4
[All COF-R02 Questions]

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

Show Suggested Answer Hide Answer
Suggested Answer: D

by Dannie at Aug 12, 2025, 11:49 PM

Limited Time Offer

25%

Off

Get Premium COF-R02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Lynsey
8 months ago
Wait, really? I thought they’d just vanish!
upvoted 0 times
...
Romana
9 months ago
I’m pretty sure it’s the assumed role that dropped it.
upvoted 0 times
...
Avery
9 months ago
SYSADMIN takes over ownership, right?
upvoted 0 times
...
Samira
9 months ago
I thought the user who dropped it would own them?
upvoted 0 times
...
Pamella
9 months ago
The tables are orphaned now.
upvoted 0 times
...
Venita
9 months ago
I think it could be the assumed role that dropped the role, but I need to double-check that concept.
upvoted 0 times
...
Samuel
10 months ago
I feel like SYSADMIN might take ownership in some scenarios, but I can't recall the specifics.
upvoted 0 times
...
Lorriane
10 months ago
I remember a practice question where the owner of the tables was transferred to the user who dropped the role. Could that be the case here?
upvoted 0 times
...
Haydee
10 months ago
I think the tables might become orphaned if the role is dropped, but I'm not entirely sure.
upvoted 0 times
...
Deane
10 months ago
I'm pretty confident I know the answer to this one. When a role is dropped, the tables it owns become orphaned, so the correct answer is A.
upvoted 0 times
...
Shenika
10 months ago
Okay, I've got a strategy here. I'll need to consider what happens to the objects owned by a role when that role is dropped. That should point me to the right answer.
upvoted 0 times
...
Gerald
11 months ago
I'm a bit confused on this one. Does the role get deleted, or just the user that created it? I'll need to review the details more carefully.
upvoted 0 times
...
Rosendo
11 months ago
Hmm, this is an interesting one. I'll need to think through the ownership implications of dropping a role that owns tables.
upvoted 0 times
...
Pedro
1 year ago
I'm pretty sure the tables are orphaned now. That's the only logical answer, right?
upvoted 0 times
...
Tess
1 year ago
I believe the user that deleted the role will now own the tables.
upvoted 0 times
...
Glory
1 year ago
I think the tables are now orphaned.
upvoted 0 times
...

Save Cancel