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

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?
A . The tables are now orphaned
B. The user that deleted the role
C. SYSADMIN
D. The assumed role that dropped the role

View Answer

Answer: D

Explanation:

Reference: https://docs.snowflake.com/en/sql-reference/sql/drop-role.html