SAP-C02 Question 471
Select 2An e-commerce company is running its web application on Amazon EC2 instances behind an Application Load Balancer (ALB). The application stores user session data on a single Amazon RDS instance. Recently, the company experienced a database outage, causing the entire application to become inaccessible. As a Solutions Architect, how can you improve the reliability of this architecture?
- A
Enable Multi-AZ deployment for the Amazon RDS instance to provide high availability.
- B
Use Amazon DynamoDB as a session store instead of storing session data in the Amazon RDS instance.
- C
Configure Auto Scaling for the Amazon RDS instance to handle database load spikes.
- D
Implement read replicas for the Amazon RDS instance to offload read traffic and improve reliability.
- E
Migrate the application to Amazon S3 static hosting to eliminate reliance on the database.
Show answer and explanation
Correct answers: A, B
Explanation
To improve the reliability of the architecture, enabling Multi-AZ deployment ensures high availability for the database, and using DynamoDB for session storage minimizes the dependency on a single point of failure. These measures address the identified reliability issues without overcomplicating the architecture.
- A. Correct.
Enabling Multi-AZ deployment for the Amazon RDS instance provides automatic failover to a standby instance in case of a database outage, thereby improving reliability.
- B. Correct.
Using Amazon DynamoDB as a session store decouples session data from the RDS instance, reducing the dependency on a single database and increasing reliability.
- C. Incorrect.
Auto Scaling is not applicable to Amazon RDS instances; database scaling must be done by scaling the instance type or using features like Aurora Serverless.
- D. Incorrect.
Read replicas help with read traffic but do not improve reliability for write operations or in the event of a primary database outage.
- E. Incorrect.
Migrating the application to Amazon S3 static hosting is not a viable option for an e-commerce application that requires dynamic server-side processing and database integration.