DATA-ENGINEER-ASSOCIATE practice

Q1 Single choice

A company uses an Amazon Redshift cluster as a data warehouse that is shared acro two departments.
To comply with a security policy, each department must have unique acce permiions.

Department A must have acce to tables and views for Department A. Department B must have acce to tables and views for Department B.

The company often runs SQL queries that use objects from both departments in one query.

Which solution will meet these requirements with the LEAST operational overhead?

A
Group tables and views for each department into dedicated schemas. Manage permiions at the schema level.
B
Group tables and views for each department into dedicated databases. Manage permiions at the database level.
C
Update the names of the tables and views to follow a naming convention that contains the department names. Manage permiions based on the new naming convention.
D
Create an IAM user group for each department. Use identity-based IAM policies to grant table and view permiions based on the IAM user group.