Câu 53: SnowPro Advanced Architect

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?

1. A. USAGE on database hr_db, USAGE on all schemas in database hr_db, SELECT on all tables in database hr_db — đáp án hiện tại
2. B. USAGE on database hr_db, SELECT on all schemas in database hr_db, SELECT on all tables in database hr_db
3. C. MODIFY on database hr_db, USAGE on all schemas in database hr_db, USAGE on all tables in database hr_db
4. D. USAGE on database hr_db, USAGE on all schemas in database hr_db, REFERENCES on all tables in database hr_db