AWS Certified Solutions Architect – Associate (SAA-C02) — Question 493
A company is running a database on Amazon Aurora. The database is idle every evening. An application that performs extensive reads on the database experiences performance issues during morning hours when user traffic spikes. During these peak periods, the application receives timeout errors when reading from the database. The company does not have a dedicated operations team and needs an automated solution to address the performance issues.
Which actions should a solutions architect take to automatically adjust to the increased read load on the database? (Choose two.)
Answer options
- A. Migrate the database to Aurora Serverless.
- B. Increase the instance size of the Aurora database.
- C. Configure Aurora Auto Scaling with Aurora Replicas.
- D. Migrate the database to an Aurora multi-master cluster.
- E. Migrate the database to an Amazon RDS for MySQL Multi-AZ deployment.
Correct answer: A, C
Explanation
Aurora Serverless automatically starts up, shuts down, and scales capacity up or down based on your application's needs, which perfectly handles the idle nights and morning spikes without manual intervention. Additionally, configuring Aurora Auto Scaling with Aurora Replicas allows the system to dynamically add reader instances to handle sudden surges in read traffic, resolving the timeout issues. Other options either require manual overhead, like manual resizing, or do not offer automatic horizontal scaling for read traffic.