ARA-C01 · Question #4
ARA-C01 Question #4: Real Exam Question with Answer & Explanation
Sign in or unlock ARA-C01 to reveal the answer and full explanation for question #4. The question stem and answer options stay visible for context.
Question
An Architect needs to grant a group of ORDER_ADMIN users the ability to clean old data in an ORDERS table (deleting all records older than 5 years), without granting any privileges on the table. The group's manager (ORDER_MANAGER) has full DELETE privileges on the table. How can the ORDER_ADMIN role be enabled to perform this data cleanup, without needing the DELETE privilege held by the ORDER_MANAGER role?
Options
- ACreate a stored procedure that runs with caller's rights, including the appropriate "> 5 years"
- BCreate a stored procedure that can be run using both caller's and owner's rights (allowing the user
- CCreate a stored procedure that runs with owner's rights, including the appropriate "> 5 years"
- DThis scenario would actually not be possible in Snowflake ?any user performing a DELETE on a
Unlock ARA-C01 to see the answer
You've previewed enough free ARA-C01 questions. Unlock ARA-C01 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.