ARA-C01 · Question #18
ARA-C01 Question #18: Real Exam Question with Answer & Explanation
Sign in or unlock ARA-C01 to reveal the answer and full explanation for question #18. The question stem and answer options stay visible for context.
Question
There are two databases in an account, named fin_db and hr_db which contain payroll and employee data, respectively. Accountants and Analysts in the company require different permissions on the objects in these databases to perform their jobs. Accountants need read-write access to fin_db but only require read-only access to hr_db because the database is maintained by human resources personnel. An Architect needs to create a read-only role for certain employees working in the human resources department. Which permission sets must be granted to this role?
Options
- AUSAGE on database hr_db, USAGE on all schemas in database hr_db, SELECT on all tables in
- BUSAGE on database hr_db, SELECT on all schemas in database hr_db, SELECT on all tables in
- CMODIFY on database hr_db, USAGE on all schemas in database hr_db, USAGE on all tables in
- DUSAGE on database hr_db, USAGE on all schemas in database hr_db, REFERENCES on all
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.