Exam COF-C02 Topic 3 Question 326 Discussion

Actual exam question for Snowflake's COF-C02 exam
Question #: 326
Topic #: 3
Which process does Snowflake follow when a stored procedure with owner's rights is called within a session?

Suggested Answer: A Vote an answer

* Owner's Rights Stored Procedures:
* When a stored procedure with owner's rights is called, it runs with the privileges of the owner, not the caller.
* This ensures that the procedure executes with access to objects the owner has privileges for, regardless of the caller's permissions.
Why Other Options Are Incorrect:
* B. The owner can set the caller's session variables: Stored procedures cannot modify session variables of the caller.
* C. The owner will inherit the caller's current virtual warehouse: The procedure uses the session's current warehouse, not inherited settings.
* D. The owner can view the caller's session variables: Session variables are private to the caller and not visible to the owner.
References:
* Stored Procedure Privileges Documentation

by Luther at Feb 22, 2025, 12:22 PM

Limited Time Offer

15%

Off

Get Premium COF-C02 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10