Big Halloween Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

Exam ARA-C01 All Questions
Exam ARA-C01 All Questions

View all questions & answers for the ARA-C01 exam

Snowflake SnowPro Advanced: Architect ARA-C01 Question # 2 Topic 1 Discussion

ARA-C01 Exam Topic 1 Question 2 Discussion:
Question #: 2
Topic #: 1

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?


A.

USAGE on database hr_db, USAGE on all schemas in database hr_db, SELECT on all tables in database hr_db


B.

USAGE on database hr_db, SELECT on all schemas in database hr_db, SELECT on all tables in database hr_db


C.

MODIFY on database hr_db, USAGE on all schemas in database hr_db, USAGE on all tables in database hr_db


D.

USAGE on database hr_db, USAGE on all schemas in database hr_db, REFERENCES on all tables in database hr_db


Get Premium ARA-C01 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.