
Answer-first summary for fast verification
Answer: The current active primary role
In Snowflake, when an object is created, the owner is the role that was active at the time of creation. This is explicitly stated in Snowflake documentation and confirmed by the community discussion where option C received 100% consensus with a reference to official documentation. The public role (A) is a predefined role but not automatically the owner. The user's default role (B) may or may not be the active role during creation. The owner of the parent schema (D) does not automatically own new objects created within it unless that role is the active role.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.