SnowPro Advanced: Architect — Question 52
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?
Answer options
- 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
Correct answer: A
Explanation
The correct answer, A, provides the necessary permissions for a read-only role by allowing USAGE on the database and schemas, along with SELECT on all tables, which is essential for reading data. Option B incorrectly suggests SELECT on schemas, which is unnecessary, while C includes MODIFY, which is not suitable for a read-only role. Option D includes REFERENCES instead of SELECT, making it inadequate for accessing the data.