Snowpro Core · Free Practice Question Easy
Question 63
What is the default execution context for Stored Procedures in Snowflake if the execution context (caller or owner) is not explicitly specified?
-
A
System
-
B
Owner
-
C
Admin
-
D
Caller
Reveal correct answer
Correct answer: B
A.
"System" is also not a valid execution context in Snowflake. The default and configurable options are strictly limited to either caller or owner.
B.
The default execution context for Stored Procedures is the owner’s rights if nothing is specified. This setting ensures that the procedure executes with the permissions of the procedure’s owner by default.
C.
"Admin" is not a valid execution context option in Snowflake for Stored Procedures. The execution context is limited to either the caller’s or the owner’s rights.
D.
If the execution context is not specified, Stored Procedures in Snowflake default to the owner’s rights. The caller’s rights must be explicitly set using EXECUTE AS CALLER.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
