Which of the following describes a Snowflake stored procedure?
A.
They can be created as secure and hide the underlying metadata from the user.
B.
They can only access tables from a single database.
C.
They can contain only a single SQL statement.
D.
They can be created to run with a caller ' s rights or an owner ' s rights.
The Answer Is:
D
This question includes an explanation.
Explanation:
Snowflake stored procedures can be created to execute with the privileges of the role that owns the procedure (owner’s rights) or with the privileges of the role that calls the procedure (caller’s rights). This allows for flexibility in managing security and access control within Snowflake1.
COF-C03 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"