SAP-C02 Practice Question: Accelerate Workload Migration and Modernization
A company is migrating a legacy Java-based customer relationship management (CRM) system from on-premises to AWS. The application currently runs on a single physical server with a monolithic architecture. The application stores data in an Oracle database on a separate server. The company has purchased a third-party migration tool that can convert Oracle stored procedures to Amazon Aurora PostgreSQL-compatible code. The migration team has successfully migrated the database to Aurora PostgreSQL using AWS DMS with ongoing CDC. The application now runs on a single EC2 instance in a test environment. However, during load testing, the application experiences high latency and intermittent timeouts when accessing the database. The team notices that the application makes many short-lived database connections and uses a connection pool that was configured for the on-premises environment. The team has also observed that the application logs show a high number of connection timeouts. The company wants to modernize the application to be highly available and scalable on AWS. Which combination of actions should the team take to resolve the performance issues and achieve the company's goals?
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
✓
Deploy the application on Amazon ECS with Fargate, and use Amazon RDS Proxy to manage database connections efficiently. Refactor the application to separate components into multiple microservices.
The issue is likely due to the connection pool being inefficient for the cloud environment and the monolithic architecture not scaling. Deploying the application as microservices on containers with an RDS Proxy for connection pooling addresses both performance and high availability. Simply increasing connection pool size may overwhelm the database. Using Lambda would require significant refactoring. Vertical scaling does not provide high availability.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Deploy the application on Amazon ECS with Fargate, and use Amazon RDS Proxy to manage database connections efficiently. Refactor the application to separate components into multiple microservices.
Why this is correct
Correct. RDS Proxy reduces connection overhead, and microservices enable scalability and HA.
- ✗
Use Amazon ElastiCache to cache database query results and reduce the number of direct database connections. Keep the application on a single EC2 instance but use an Auto Scaling group with a minimum of one instance.
Why it's wrong here
Caching may help but does not address the connection pooling issue or provide HA for the application.
- ✗
Increase the connection pool size in the application configuration to handle more concurrent requests. Then deploy the application on a larger EC2 instance to handle the load.
Why it's wrong here
Increasing pool size may lead to database resource exhaustion, and vertical scaling does not provide HA.
- ✗
Migrate the application to run on AWS Lambda with a connection pool managed by the Lambda function. Use Amazon RDS Proxy to handle the database connections.
Why it's wrong here
Lambda has limitations on long-running connections and may require significant refactoring.
Visual reference
Quick reference
Cloud Service Model Comparison
| Model | You Manage | Provider Manages | Examples |
|---|---|---|---|
| IaaS | OS, runtime, apps, data | Hardware, hypervisor, networking | EC2, Azure VMs, GCP Compute Engine |
| PaaS | Apps and data | OS, runtime, middleware, hardware | Elastic Beanstalk, Azure App Service |
| SaaS | Data and settings only | Everything else | Microsoft 365, Salesforce, Workday |
| FaaS / Serverless | Function code only | Infra, scaling, runtime | Lambda, Azure Functions, Cloud Run |
| CaaS | Containers and apps | Kubernetes, OS, hardware | EKS, AKS, GKE |
Go deeper
Related to this question
About these practice questions
Courseiva writes every SAP-C02 question from scratch — 1,660 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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.