SnowflakeSnowflake
DEA-C02 · Question #41
DEA-C02 Question #41: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #41. The question stem and answer options stay visible for context.
Security and Governance
Question
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?
Options
- AThe stored procedure must run with caller's rights; it cannot be converted later to run with owner's
- BIf the stored procedure accesses an object that ROLEA does not have access to, the stored
- CThe stored procedure will run in the context (database and schema) where the owner created the
- DROLEA will not be able to see the source code for the stored procedure, even though the role has
Unlock DEA-C02 to see the answer
You've previewed enough free DEA-C02 questions. Unlock DEA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Stored Procedures#Caller's Rights#Access Control#Snowflake Security