A custom role owns multiple tables. If this role is dropped from the system, who becomes the owner of these tables?
A custom role owns multiple tables. If this role is dropped from the system, who becomes the owner of these tables?
When a custom role is dropped from the system, the ownership of any objects (including tables) owned by the dropped role is transferred to the role that executes the DROP ROLE command.
https://docs.snowflake.com/en/sql-reference/sql/drop-role#:~:text=Ownership%20of%20any%20objects%20owned%20by%20the%20dropped%20role%20is%20transferred%20to%20the%20role%20that%20executes%20the%20DROP%20ROLE%20command.
correct
D is correct