A Company Is Going to Use an Amazon Aurora PostgreSQL

question 37

Multiple Choice

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.

---

Definitions:

Freedom To Farm Act

Legislation enacted to give farmers more flexibility in the planting choices of crops, aiming to make American agriculture more market-driven.

Reduced Export Demand

A situation where there is a decline in the international demand for a country's goods or services, often affecting the exporting country's economy.

Crop Production

The process of growing and harvesting plants, particularly agricultural crops, for consumption, industry, and feed, involving techniques like planting, irrigation, and pest control.

Agricultural Price And Income Instability

Fluctuations in the prices and incomes in the agricultural sector due to variables like weather conditions, demand changes, and global market forces.