SAP-C02 Practice Question: Accelerate Workload Migration and Modernization
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.)
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use Amazon RDS read replicas to offload read traffic and improve resilience.
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.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Enable Multi-AZ deployment for the RDS instance to automatically failover.
Why it's wrong here
Multi-AZ is a best practice but does not directly address hard-coded IPs.
- ✓
Use Amazon RDS read replicas to offload read traffic and improve resilience.
Why this is correct
Read replicas provide scalability and resilience for read-heavy workloads.
- ✗
Assign an Elastic IP address to the RDS instance for consistent connectivity.
Why it's wrong here
Elastic IPs are not used with RDS.
- ✓
Migrate the database to Amazon RDS and use the RDS endpoint (DNS name) in the connection string.
Why this is correct
RDS endpoint provides a DNS name that remains the same across failovers.
- ✓
Modify the application to read the database endpoint from an environment variable or configuration file.
Why this is correct
This decouples the application from hard-coded IPs.
Go deeper
Related to this question
About these practice questions
This SAP-C02 question is part of Courseiva's 1,660-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This SAP-C02 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SAP-C02 exam.