Snowflake
COF-R02 · Question #43
A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?
The correct answer is D. The assumed role that dropped the role. See the full explanation below for the reasoning.
Question
A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?
Options
- AThe tables are now orphaned
- BThe user that deleted the role
- CSYSADMIN
- DThe assumed role that dropped the role
How the community answered
(25 responses)- A8% (2)
- B16% (4)
- C4% (1)
- D72% (18)
Community Discussion
No community discussion yet for this question.