exam questions

Exam SnowPro Advanced Data Engineer All Questions

View all questions & answers for the SnowPro Advanced Data Engineer exam

Exam SnowPro Advanced Data Engineer topic 1 question 41 discussion

Actual exam question from Snowflake's SnowPro Advanced Data Engineer
Question #: 41
Topic #: 1
[All SnowPro Advanced Data Engineer Questions]

A Data Engineer has written a stored procedure that will run with caller's rights. The Engineer has granted ROLEA the right to use this stored procedure.
What is a characteristic of the stored procedure being called using ROLEA?

  • A. The stored procedure must run with caller's rights; it cannot be converted later to run with owner's rights.
  • B. If the stored procedure accesses an object that ROLEA does not have access to, the stored procedure will fail.
  • C. The stored procedure will run in the context (database and schema) where the owner created the stored procedure.
  • D. ROLEA will not be able to see the source code for the stored procedure, even though the role has usage privileges on the stored procedure.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
stopthisnow
1 month, 1 week ago
Selected Answer: B
A caller’s rights stored procedure runs with the database privileges of the role that called the stored procedure. Any statement that the caller could not execute outside the stored procedure cannot be executed inside the stored procedure, either. For example, if the role named “Nurse” does not have privileges to delete rows from the medical_records table, then if a user with the role “Nurse” calls a caller’s rights stored procedure that tries to delete rows from that table, the stored procedure will fail. https://docs.snowflake.com/en/developer-guide/stored-procedure/stored-procedures-rights#caller-s-rights-stored-procedures
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago