AWS Certified Solutions Architect - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
A company deploys its applications on Amazon Elastic Kubernetes Service (Amazon EKS) behind an Application Load Balancer in an AWS Region. The application needs to store data in a PostgreSQL database engine. The company wants the data in the database to be highly available. The company also needs increased capacity for read workloads.
Which solution will meet these requirements with the MOST operational efficiency?
Other
Community
UAnonymous
A
Create an Amazon DynamoDB database table configured with global tables.
B
Create an Amazon RDS database with Multi-AZ deployments.
C
Create an Amazon RDS database with Multi-AZ DB cluster deployment.
D
Create an Amazon RDS database configured with cross-Region read replicas.
Explanation:
Explanation
The correct answer is C. Create an Amazon RDS database with Multi-AZ DB cluster deployment.
Let's analyze each option:
A. Create an Amazon DynamoDB database table configured with global tables.
- Problem: The requirement specifies PostgreSQL database engine. DynamoDB is a NoSQL database, not PostgreSQL.
- Global tables provide multi-region replication but don't meet the PostgreSQL requirement.
B. Create an Amazon RDS database with Multi-AZ deployments.
- Provides high availability through synchronous replication to a standby instance in another Availability Zone.
- Limitation: Only provides a single standby instance for failover, not for read scaling.
- Doesn't address read workload scaling - the standby instance cannot be used for read operations in standard Multi-AZ deployments.
C. Create an Amazon RDS database with Multi-AZ DB cluster deployment.
- ✓ Provides high availability with three instances across three Availability Zones.
- ✓ Supports read scaling - includes two readable standby instances that can handle read queries.
- ✓ Most operationally efficient because it combines high availability with read scaling in a single deployment.
- ✓ Specifically designed for PostgreSQL and MySQL with Aurora storage.
D. Create an Amazon RDS database configured with cross-Region read replicas.
- Provides read scaling through read replicas in another region.
- Provides disaster recovery but not local high availability.
- Less operationally efficient than Multi-AZ DB cluster because:
- Cross-region replication adds latency
- More complex to manage across regions
- Higher costs for cross-region data transfer
- Doesn't provide automatic failover within the primary region
Key Points:
- Multi-AZ DB cluster deployment provides both high availability (automatic failover) and read scaling (two readable standby instances).
- This is the most operationally efficient solution as it addresses both requirements in a single, integrated architecture.
- The company's application is already in a single AWS Region, so cross-region solutions add unnecessary complexity.
Comments
Loading comments...