Answer-first summary for fast verification
Answer: They can be created to run with a caller's rights or an owner's rights.
The correct answer is D because stored procedures in Snowflake can indeed be created to run with either caller's rights or owner's rights, which is a well-documented feature that controls access privileges. Option A is incorrect because while stored procedures can be created as secure, they cannot hide underlying metadata from 'all' users - the owner and authorized roles can still view the definition. Option B is incorrect because stored procedures can access tables across multiple databases, not just a single database. Option C is incorrect because stored procedures can contain multiple SQL statements, not just a single one. The community discussion shows strong consensus for D (77% of answers), with detailed reasoning from multiple users citing official Snowflake documentation about rights management in 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 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.