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?

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 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:

Submit Cancel

Lynsey

4 months ago

Wait, really? I thought they’d just vanish!

upvoted 0 times

...

Romana

4 months ago

I’m pretty sure it’s the assumed role that dropped it.

upvoted 0 times

...

Avery

4 months ago

SYSADMIN takes over ownership, right?

upvoted 0 times

...

Samira

4 months ago

I thought the user who dropped it would own them?

upvoted 0 times

...

Pamella

5 months ago

The tables are orphaned now.

upvoted 0 times

...

Venita

5 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

5 months ago

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

upvoted 0 times

...

Lorriane

5 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

6 months ago

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

upvoted 0 times

...

Deane

6 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

6 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

6 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

6 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

8 months ago

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

upvoted 0 times

...

Tess

8 months ago

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

upvoted 0 times

...

Glory

8 months ago

I think the tables are now orphaned.

upvoted 0 times

...