Answer-first summary for fast verification
Answer: They can be created to run with a caller's rights or an owner's rights.
Option D is correct because Snowflake stored procedures can be created with either CALLER's RIGHTS (executing with the privileges of the user calling the procedure) or OWNER's RIGHTS (executing with the privileges of the procedure owner), which is a key security feature. Option A is incorrect because stored procedures cannot hide underlying metadata from all users. Option B is incorrect because stored procedures can access tables across multiple databases within the same account. Option C is incorrect because stored procedures can contain multiple SQL statements and complex logic, not just a single statement. The community discussion shows 100% consensus on D with upvoted comments confirming this is the correct characteristic of Snowflake stored procedures.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is a characteristic of a stored procedure in Snowflake?
A
They can be created as secure and hide the underlying metadata from all users.
B
They can only access tables from a single database.
C
They can only contain a single SQL statement.
D
They can be created to run with a caller's rights or an owner's rights.
No comments yet.