Exam SnowPro Advanced Architect All QuestionsBrowse all questions from this exam
Question 55

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?

    Correct Answer: A

    To create a read-only role for employees in the human resources department, the necessary permissions are: USAGE on the database to allow access to the database itself, USAGE on all schemas to access the structures within the database, and SELECT on all tables to enable read-only access to the data in those tables. This ensures that the employees can view but not modify the data. Therefore, the correct permission set is 'USAGE on database hr_db, USAGE on all schemas in database hr_db, SELECT on all tables in database hr_db'.

Discussion
hillcat111Option: A

Answer is A and is validated

hillcat111Option: A

Answer is correct A