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.
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. 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
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
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.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
uncle_benz
Highly Voted 2 years agoMallikharjuna452
Most Recent 4 months agoPrashantGupta1616
5 months, 2 weeks ago_yyukta
8 months, 4 weeks agoBobFar
1 year, 1 month agoMarge23
1 year, 2 months agomagnasiun1
1 year, 5 months agoMayuri917233
1 year, 6 months agoJosa2
1 year, 8 months agoAndroJS
1 year, 10 months agoTapasgup007
1 year, 11 months agoseaun
2 years agogreenlever
2 years agogreenlever
2 years, 1 month agoTapsinha
2 years, 9 months agolostri
2 years, 10 months ago