Which solution will meet these requirements with the MOST operational efficiency?
Create an Amazon DynamoDB database table configured with global tables.
Create an Amazon RDS database with Multi-AZ deployments.
Create an Amazon RDS database with Multi-AZ DB cluster deployment.
Create an Amazon RDS database configured with cross-Region read replicas.
Explanations:
Amazon DynamoDB is a NoSQL database, which does not support PostgreSQL queries or structure. It is not compatible with the requirement for a PostgreSQL database engine.
Amazon RDS Multi-AZ deployment improves availability by replicating to a standby in a different Availability Zone but does not provide increased read capacity, as there are no additional read replicas.
Amazon RDS Multi-AZ DB cluster deployment provides high availability and allows for reader nodes, which increases capacity for read workloads. This solution best meets both high availability and read scalability requirements.
Cross-Region read replicas improve read scalability but are intended for geographically distributed applications and incur additional latency. This solution is more complex operationally than Multi-AZ DB clusters for local scaling.
I systematize that the answer is:
Create an Amazon RDS database with Multi-AZ DB cluster deployment.
I categorize that the answer is:
Create an Amazon RDS database with Multi-AZ DB cluster deployment.