SnowPro Core Certification — Question 1237

Which process does Snowflake follow when a stored procedure with owner's rights is called within a session?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C, as the owner of the stored procedure inherits the caller's current virtual warehouse when the procedure is executed. Option A is incorrect because the procedure runs with the owner's privileges, not the caller's. Options B and D are also incorrect as they do not accurately describe the behavior of the stored procedure in this context.