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
7 months ago
Wait, really? I thought they’d just vanish!
upvoted 0 times
...
Romana
7 months ago
I’m pretty sure it’s the assumed role that dropped it.
upvoted 0 times
...
Avery
7 months ago
SYSADMIN takes over ownership, right?
upvoted 0 times
...
Samira
8 months ago
I thought the user who dropped it would own them?
upvoted 0 times
...
Pamella
8 months ago
The tables are orphaned now.
upvoted 0 times
...
Venita
8 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
8 months ago
I feel like SYSADMIN might take ownership in some scenarios, but I can't recall the specifics.
upvoted 0 times
...
Lorriane
8 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
9 months ago
I think the tables might become orphaned if the role is dropped, but I'm not entirely sure.
upvoted 0 times
...
Deane
9 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
9 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
9 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
9 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
11 months ago
I'm pretty sure the tables are orphaned now. That's the only logical answer, right?
upvoted 0 times
...
Tess
11 months ago
I believe the user that deleted the role will now own the tables.
upvoted 0 times
...
Glory
11 months ago
I think the tables are now orphaned.
upvoted 0 times
...

Save Cancel