How can the Database Specialist meet these requirements?

A company is going to use an Amazon Aurora PostgreSQL DB cluster for an application backend. The DB cluster contains some tables with sensitive data. A Database Specialist needs to control the access privileges at the table level.

How can the Database Specialist meet these requirements?
A . Use AWS IAM database authentication and restrict access to the tables using an IAM policy.
B . Configure the rules in a NACL to restrict outbound traffic from the Aurora DB cluster.
C . Execute GRANT and REVOKE commands that restrict access to the tables containing sensitive data.
D . Define access privileges to the tables containing sensitive data in the pg_hba.conf file.

View Answer

Answer: C

Explanation:

Reference: https://aws.amazon.com/blogs/database/managing-postgresql-users-and-roles/