SnowPro Core Exam - Question 55

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.

Answer is D

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

B Correct

B is correct

D is correct

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

D is correct

D is the RIGHT ANSWER

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. 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 is Correct