When a role is dropped, which role inherits ownership of objects owned by the dropped role?

When a role is dropped, which role inherits ownership of objects owned by the dropped role?
A . The SYSADMIN role
B . The role above the dropped role in the RBAC hierarchy
C . The role executing the command
D . The SECURITYADMIN role

Answer: B

Explanation:

According to the Snowflake documentation1, when a role is dropped, ownership of all objects owned by the dropped role is transferred to the role that is directly above the dropped role in the role hierarchy. This is to ensure that there is always a single owner for each object in the system.

1: Drop Role | Snowflake Documentation

Latest ADA-C01 Dumps Valid Version with 72 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments