Which of the following describes a Snowflake stored procedure?

The correct answer is D. They can be created to run with a caller's rights or an owner's rights. Snowflake stored procedures support two execution rights models: Caller's Rights (the procedure runs with the privileges of the user who calls it) and Owner's Rights (the procedure runs with the privileges of the procedure owner, regardless of who calls it). This is a key…

Account Access and Security

Question

Options

AThey can be created as secure and hide the underlying metadata from the user.
BThey can only access tables from a single database.
CThey can contain only a single SQL statement.
DThey can be created to run with a caller's rights or an owner's rights.

How the community answered

(24 responses)

A
4% (1)
B
4% (1)
D
92% (22)

Explanation

Snowflake stored procedures support two execution rights models: Caller's Rights (the procedure runs with the privileges of the user who calls it) and Owner's Rights (the procedure runs with the privileges of the procedure owner, regardless of who calls it). This is a key security and access control feature. - A is wrong: stored procedures do not have a 'SECURE' option like views. B is wrong: stored procedures can access objects across multiple databases. C is wrong: they can contain multiple SQL statements and complex logic, including JavaScript, Python, Scala, Java, or Snowflake Scripting.

Topics

#Stored Procedures#Execution Rights#Security Model#Permissions

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice