SnowPro Core Certification — Question 417

What is a feature of a stored procedure in Snowflake?

Answer options

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

Correct answer: D

Explanation

The correct answer, D, highlights that stored procedures in Snowflake can operate under the privileges of either the caller or the owner, allowing for flexible permission management. Options A, B, and C are incorrect because stored procedures can expose metadata, access multiple databases, and support multiple SQL statements.