DBS-C01 practice question 12 of 35

A company is going to use an Amazon Aurora PostgreSQL DB cluster for an application backend. The DB cluster contains some tables with sensitive dat a. A Database Specialist needs to control the access privileges at the table level. How can the Database Specialist meet these requirements?

Full set: 322 questions
Answer options
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. Correct answer
D: Define access privileges to the tables containing sensitive data in the pg_hba.conf file.
Correct Answer:
C. Execute GRANT and REVOKE commands that restrict access to the tables containing sensitive data.
Scroll to Top