A company is migrating a legacy application that uses hard-coded IP addresses for database connections. The company wants to refactor the application to use a more resilient architecture in AWS. Which THREE steps should the company take to modernize the database connectivity? (Choose THREE.)
Read replicas provide scalability and resilience for read-heavy workloads.
Why this answer
Read replicas can offload read traffic and enhance resilience, but note that read replicas are primarily for read scaling, not automatic failover. Option D is correct because using the RDS endpoint (DNS name) in the connection string allows the application to automatically reconnect to a new primary instance during failover, removing the hard-coded IP address. Option E is correct because storing the database endpoint in an environment variable or configuration file decouples the application from the infrastructure, enabling easier updates and failover handling.
Option A is incorrect because Multi-AZ deployment provides high availability with automatic failover, but it does not directly address the issue of hard-coded IP addresses; the application still needs to use the DNS endpoint. Option C is incorrect because Elastic IP addresses are not suitable for RDS; RDS uses DNS endpoints for connectivity, and Elastic IPs are associated with EC2 instances, not RDS.