SnowPro Core Certification — Question 60

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

Answer options

• A. The tables are now orphaned
• B. The user that deleted the role
• C. SYSADMIN
• D. The assumed role that dropped the role

Correct answer: D

Explanation

When a role that owns tables is dropped, the ownership of those tables is transferred to the role that was assumed when the drop command was executed. The other options are incorrect because the tables do not become orphaned, the user who deleted the role does not automatically gain ownership, and SYSADMIN does not gain ownership unless specifically granted.