SAA-C03 · Question #569
A company runs an ecommerce application on Amazon EC2 instances behind an Application Load Balancer. The instances run in an Amazon EC2 Auto Scaling group across multiple Availability Zones. The…
The correct answer is C. Use Amazon Aurora with a Multi-AZ deployment. Configure Aurora Auto Scaling with Aurora. Amazon Aurora MySQL-compatible offers a distributed, fault-tolerant storage system with Multi- AZ high availability and supports Aurora Replicas that "share the same underlying storage" for low-latency reads. Aurora provides Aurora Auto Scaling to "automatically add or remove…
Question
A company runs an ecommerce application on Amazon EC2 instances behind an Application Load Balancer. The instances run in an Amazon EC2 Auto Scaling group across multiple Availability Zones. The Auto Scaling group scales based on CPU utilization metrics. The ecommerce application stores the transaction data in a MySQL 8.0 database that is hosted on a large EC2 instance. The database's performance degrades quickly as application load increases. The application handles more read requests than write transactions. The company wants a solution that will automatically scale the database to meet the demand of unpredictable read workloads while maintaining high availability. Which solution will meet these requirements?
Options
- AUse Amazon Redshift with a single node for leader and compute functionality.
- BUse Amazon RDS with a Single-AZ deployment. Configure Amazon RDS to add reader instances
- CUse Amazon Aurora with a Multi-AZ deployment. Configure Aurora Auto Scaling with Aurora
- DUse Amazon ElastiCache (Memcached) with EC2 Spot Instances.
How the community answered
(29 responses)- A7% (2)
- B3% (1)
- C72% (21)
- D17% (5)
Explanation
Amazon Aurora MySQL-compatible offers a distributed, fault-tolerant storage system with Multi- AZ high availability and supports Aurora Replicas that "share the same underlying storage" for low-latency reads. Aurora provides Aurora Auto Scaling to "automatically add or remove Aurora Replicas based on load," ideal for unpredictable, read-heavy workloads. This architecture offloads reads from the writer and maintains HA through automatic failover. Amazon RDS Single- AZ (B) lacks HA. Redshift (A) is a data warehouse, not a transactional DB. ElastiCache (D) can reduce read pressure but does not provide durable read replicas or automatic HA scaling at the database tier. Aurora's design directly addresses the requirement to automatically scale reads while maintaining availability, matching Well-Architected guidance to use managed, elastic services for variable demand.
Community Discussion
No community discussion yet for this question.