← SOA-C02·Amazon Web Services

Question 1,483 of 1,546

Reliability and Business Continuity →hardMultiple ChoiceObjective-mapped

Quick Answer

The correct solution is to increase the DB instance size to a larger class and implement an Amazon ElastiCache cluster to cache frequent database queries. This directly addresses the root cause of high CPU and connection limits on RDS by providing more compute capacity while ElastiCache offloads read traffic, reducing the number of direct database connections and alleviating read replica lag. On the AWS Certified SysOps Administrator Associate SOA-C02 exam, this scenario tests your understanding that scaling a database vertically (larger instance) combined with caching is the fastest way to fix performance bottlenecks without re-architecting the application. A common trap is choosing to add more read replicas or scale the ASG, but those increase connection overhead and replication lag rather than solving the CPU and connection cap. Remember the mnemonic “Scale Up, Cache Out” — when CPU and connections max out, first scale the instance up, then add a cache layer to reduce the load.

SOA-C02 Reliability and Business Continuity Practice Question

This SOA-C02 practice question tests your understanding of reliability and business continuity. Examine the command output carefully: the correct answer depends on what the output actually shows, not on general recall alone. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.

A company runs a production web application on AWS using Auto Scaling groups (ASGs) behind an Application Load Balancer (ALB). The application state is stored in an Amazon RDS for MySQL Multi-AZ DB instance. The application experiences periodic traffic spikes, and the current ASG uses a simple scaling policy based on average CPU utilization. Recently, during a spike, the application became unresponsive for several minutes. The CloudWatch metrics show that the CPU utilization on the RDS instance peaked at 80%, and the DB Connections metric reached the maximum allowed. The read replica lag increased to over 10 seconds during the spike. The web servers are stateless and scale out quickly. The operations team needs to improve the reliability and performance of the application to handle future spikes. Which solution should the team implement?

Question 1hardmultiple choice

Full question →

A
Increase the desired capacity of the ASG and add more read replicas to distribute the database load.
Why wrong: Increasing ASG size adds more web servers, which increases database connections and may worsen the issue. More read replicas increase replication overhead and do not reduce write load.
B
Increase the DB instance size to a larger instance class and implement an Amazon ElastiCache cluster to cache frequent database queries.
Larger DB instance provides more CPU and connections. ElastiCache reduces read load on the database by caching results, lowering CPU and connection usage.
C
Migrate the database to Amazon DynamoDB with auto scaling and rewrite the application to use a serverless architecture with AWS Lambda.
Why wrong: This is a major architectural change, not an incremental improvement, and may not be feasible for existing MySQL workloads.
D
Reduce the maximum connections parameter on the RDS instance to prevent connection exhaustion and modify the application code to reduce the number of database queries.
Why wrong: Reducing MaxConnections will cause connection errors for legitimate traffic. Modifying code is a longer-term solution and not immediate.

Full breakdown with real-world context →

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

✓

Increase the DB instance size to a larger instance class and implement an Amazon ElastiCache cluster to cache frequent database queries.

Option B is correct because increasing the DB instance size provides more CPU and memory capacity to handle the load, and caching with ElastiCache reduces read load on the database by serving frequent queries from cache. This directly addresses high CPU and connection limits on RDS, and reduces read replica lag. Option A is wrong because increasing ASG size and adding more read replicas may increase database load further due to more connections and replication overhead. Option C is wrong because switching to DynamoDB and Lambda would require significant application changes and DynamoDB may not be suitable for complex queries. Option D is wrong because reducing MaxConnections on RDS would make the problem worse, and modifying application code to reduce queries is not a quick fix.

Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
Increase the desired capacity of the ASG and add more read replicas to distribute the database load.
Why it's wrong here
Increasing ASG size adds more web servers, which increases database connections and may worsen the issue. More read replicas increase replication overhead and do not reduce write load.
✓
Increase the DB instance size to a larger instance class and implement an Amazon ElastiCache cluster to cache frequent database queries.
Why this is correct
Larger DB instance provides more CPU and connections. ElastiCache reduces read load on the database by caching results, lowering CPU and connection usage.
Related concept
Read the scenario before looking for a memorised answer.
✗
Migrate the database to Amazon DynamoDB with auto scaling and rewrite the application to use a serverless architecture with AWS Lambda.
Why it's wrong here
This is a major architectural change, not an incremental improvement, and may not be feasible for existing MySQL workloads.
✗
Reduce the maximum connections parameter on the RDS instance to prevent connection exhaustion and modify the application code to reduce the number of database queries.
Why it's wrong here
Reducing MaxConnections will cause connection errors for legitimate traffic. Modifying code is a longer-term solution and not immediate.

Common exam traps

Common exam trap: answer the scenario, not the keyword

Many certification questions include familiar terms but test a specific constraint. Read the exact wording before choosing an answer that is generally true but wrong for this case.

Detailed technical explanation

How to think about this question

This question should be treated as a scenario, not a definition check. Identify the problem, the constraint and the best action. Then compare each option against those facts.

KKey Concepts to Remember

Read the scenario before looking for a memorised answer.
Find the constraint that changes the correct option.
Eliminate answers that are true in general but not in this case.
Use explanations to understand the rule behind the answer.

TExam Day Tips

Underline the problem statement mentally.
Watch for words such as best, first, most likely and least administrative effort.
Review why wrong options are wrong, not only why the correct option is correct.

Key takeaway

Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Real-world example

How this comes up in practice

An e-commerce site experiences heavy traffic on Black Friday and near-zero traffic during off-peak weeks. Rather than provisioning permanent large VMs, the team uses auto-scaling groups that add capacity automatically under load and reduce it overnight. Questions like this test whether you understand elasticity, availability zones, and cloud compute scaling patterns.

What to study next

Got this wrong? Here's your next step.

Identify which SOA-C02 exam domain this question belongs to, then review the specific concept being tested. Practise related questions in that domain and focus on understanding why each wrong answer is tempting — not just why the correct answer is right.

Related SOA-C02 practice-question pages

Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.

Monitoring, Logging, and Remediation practice questions

Practise SOA-C02 questions linked to Monitoring, Logging, and Remediation.

Reliability and Business Continuity practice questions

Practise SOA-C02 questions linked to Reliability and Business Continuity.

Deployment, Provisioning, and Automation practice questions

Practise SOA-C02 questions linked to Deployment, Provisioning, and Automation.

Security and Compliance practice questions

Practise SOA-C02 questions linked to Security and Compliance.

Networking and Content Delivery practice questions

Practise SOA-C02 questions linked to Networking and Content Delivery.

Cost and Performance Optimization practice questions

Practise SOA-C02 questions linked to Cost and Performance Optimization.

SOA-C02 fundamentals practice questions

Practise SOA-C02 questions linked to SOA-C02 fundamentals.

SOA-C02 scenario practice questions

Practise SOA-C02 questions linked to SOA-C02 scenario.

SOA-C02 troubleshooting practice questions

Practise SOA-C02 questions linked to SOA-C02 troubleshooting.

Practice this exam

Start a free SOA-C02 practice session

Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.

10 questions 20 questions 30 questions 50 questions Timed 30

SOA-C02 practice-test guide →Study guide →Browse all practice tests

FAQ

Questions learners often ask

What does this SOA-C02 question test?

Reliability and Business Continuity — This question tests Reliability and Business Continuity — Read the scenario before looking for a memorised answer..

What is the correct answer to this question?

The correct answer is: Increase the DB instance size to a larger instance class and implement an Amazon ElastiCache cluster to cache frequent database queries. — Option B is correct because increasing the DB instance size provides more CPU and memory capacity to handle the load, and caching with ElastiCache reduces read load on the database by serving frequent queries from cache. This directly addresses high CPU and connection limits on RDS, and reduces read replica lag. Option A is wrong because increasing ASG size and adding more read replicas may increase database load further due to more connections and replication overhead. Option C is wrong because switching to DynamoDB and Lambda would require significant application changes and DynamoDB may not be suitable for complex queries. Option D is wrong because reducing MaxConnections on RDS would make the problem worse, and modifying application code to reduce queries is not a quick fix.

What should I do if I get this SOA-C02 question wrong?

What is the key concept behind this question?

Read the scenario before looking for a memorised answer.

About these practice questions

Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Keep practising

Question Discussion

Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.

Loading comments…

This SOA-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 SOA-C02 exam.