SAA-C03 Question 317
Single answerA company is migrating its on-premises application to AWS and needs to ensure high availability for its relational database. The application requires a primary database instance for writes and multiple read replicas for read-heavy workloads. What is the MOST cost-effective and operationally efficient architecture to meet these requirements?
- A
Deploy an Amazon RDS database with Multi-AZ enabled and manually create read replicas on separate RDS instances.
- B
Deploy an Amazon RDS database with Multi-AZ enabled and automatic read replicas in different Regions.
- C
Deploy an Amazon RDS database with a primary instance and create multiple read replicas within the same Region.
- D
Deploy an Amazon Aurora database cluster with a primary instance and multiple Aurora Replicas.
Show answer and explanation
Correct answer: D
Explanation
Amazon Aurora is the best solution in this scenario as it combines high availability and read scalability with operational efficiency. It supports automatic replication, up to 15 read replicas, and offers better performance at a lower cost compared to a traditional Amazon RDS setup. Aurora's architecture is specifically optimized for scenarios like this, whereas other options either lack operational efficiency or introduce unnecessary complexity and costs.
- A. Incorrect.
This solution provides high availability through Multi-AZ, but creating read replicas manually is not operationally efficient. Additionally, read replicas cannot be part of the Multi-AZ setup.
- B. Incorrect.
While this option ensures high availability and read scalability, creating read replicas in different Regions introduces additional costs and latency, which may not be cost-effective or operationally efficient.
- C. Incorrect.
This option meets the requirement for high availability and read scalability within the same Region, but Amazon Aurora provides a more cost-effective and efficient solution for managing replicas.
- D. Correct.
Amazon Aurora is designed for high availability and read scalability. It supports up to 15 Aurora Replicas in the same Region, synchronizes data automatically, and is more operationally efficient compared to standard RDS.