Answer-first summary for fast verification
Answer: The owner will inherit the caller's current virtual warehouse.
The question asks about the process Snowflake follows for stored procedures with owner's rights. According to Snowflake documentation and the community discussion consensus (100% agreement on C with upvoted references to official docs), when a stored procedure is defined with owner's rights (as opposed to caller's rights), the procedure executes with the privileges of the owner and inherits the current virtual warehouse of the caller. Option C correctly states that 'The owner will inherit the caller's current virtual warehouse.' Options A, B, and D are incorrect: A describes caller's rights procedures, not owner's rights; B and D describe capabilities that aren't specific to owner's rights procedures in Snowflake.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
When a stored procedure with owner's rights is executed in a session, what process does Snowflake use?
A
The procedure will be run with the privileges of the caller.
B
The owner can set the caller's session variables.
C
The owner will inherit the caller's current virtual warehouse.
D
The owner can view the caller's session variables.