SnowPro Core Certification — Question 1321

A custom role owns multiple tables. If this role is dropped from the system, who becomes the owner of these tables?

Answer options

• A. ACCOUNTADMIN
• B. SYSADMIN
• C. Tables will be standalone or orphaned.
• D. The role that dropped the custom role.

Correct answer: D

Explanation

When a role is dropped, the ownership of the tables it managed is transferred to the role that executed the drop command. Options A and B are incorrect as they do not automatically inherit ownership in this scenario. Option C is also incorrect because the tables do not become orphaned; they are reassigned to the dropping role.