Snowflake Exam COF-R02 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?

AThe tables are now orphaned

BThe user that deleted the role

CSYSADMIN

DThe assumed role that dropped the role

Show Suggested Answer

Suggested Answer: D

by Dannie at Aug 13, 2025, 12:49 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Samuel

2 days ago

I feel like SYSADMIN might take ownership in some scenarios, but I can't recall the specifics.

upvoted 0 times

...

Lorriane

8 days 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

13 days ago

I think the tables might become orphaned if the role is dropped, but I'm not entirely sure.

upvoted 0 times

...

Deane

18 days 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

23 days 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

28 days 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

1 month 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

3 months ago

I'm pretty sure the tables are orphaned now. That's the only logical answer, right?

upvoted 0 times

...

Tess

3 months ago

I believe the user that deleted the role will now own the tables.

upvoted 0 times

...

Glory

3 months ago

I think the tables are now orphaned.

upvoted 0 times

...