A user can't own a table. Ownership of any objects owned by the dropped role is transferred to the *role* that executes the DROP ROLE command.

D Ownership of any objects owned by the dropped role is transferred to the role that executes the DROP ROLE command. To transfer ownership of each of these objects to a different role, use GRANT OWNERSHIP … COPY CURRENT GRANTS.

D is the RIGHT ANSWER https://docs.snowflake.com/en/sql-reference/sql/drop-role#usage-notes Ownership of any objects owned by the dropped role is transferred to the role that executes the DROP ROLE command. To transfer ownership of each of these objects to a different role, use GRANT OWNERSHIP … COPY CURRENT GRANTS.

D is correct

Correct answer is D Ownership of any objects 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#usage-notes

D is correct

Answer is D

D is Correct

D. The assumed role that dropped the role In Snowflake, when a role is dropped, the ownership of objects owned by that role (such as tables) is transferred to the role that performed the drop operation. Therefore, the assumed role that dropped the role will now own the two tables.

D. Dropped roles cannot be recovered; they must be recreated. Ownership of any objects owned by the dropped role is transferred to the role that executes the DROP ROLE command. To transfer ownership of each of these objects to a different role, use GRANT OWNERSHIP … COPY CURRENT GRANTS.

D is the RIGHT ANSWER

D is correct

Users don´t own objects, role does so answer is D

D is correct

B is correct

B Correct