Answer: The role that dropped the custom role.

According to Snowflake documentation, when a role is dropped, ownership of any objects owned by that role is transferred to the role that executes the DROP ROLE command. This is explicitly stated in the official Snowflake documentation referenced in the community discussion. Option D correctly identifies this behavior. Option A (ACCOUNTADMIN) and Option B (SYSADMIN) are incorrect because ownership does not automatically transfer to these predefined roles. Option C (tables will be standalone or orphaned) is also incorrect because Snowflake has a specific ownership transfer mechanism rather than leaving objects orphaned.

Author: LeetQuiz Editorial Team