SnowPro Core Certification — Question 143

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 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 is D because stored procedures in Snowflake can be configured to run with the permissions of either the caller or the owner, providing flexibility in access control. Option A is incorrect as while stored procedures can be secure, they do not necessarily hide all metadata from all users. Option B is wrong because stored procedures can access tables across multiple databases. Option C is not true since stored procedures can contain multiple SQL statements.