nerdexam
AmazonAmazon

SOA-C02 · Question #486

SOA-C02 Question #486: Real Exam Question with Answer & Explanation

Sign in or unlock SOA-C02 to reveal the answer and full explanation for question #486. The question stem and answer options stay visible for context.

Submitted by fatima_kr· Mar 30, 2026

Question

A company hosts a production MySQL database on an Amazon Aurora single-node DB cluster. The database is queried heavily for reporting purposes. The DB cluster is experiencing periods of performance degradation because of high CPU utilization and maximum connections errors. A SysOps administrator needs to improve the stability of the database. Which solution will meet these requirements?

Options

  • ACreate an Aurora Replica node. Create an Auto Scaling policy to scale replicas based on CPU
  • BCreate a second Aurora MySQL single-node DB cluster in a second Availability Zone. Ensure that
  • CCreate an AWS Lambda function that caches reporting requests. Ensure that all reporting
  • DCreate a multi-node Amazon ElastiCache cluster. Ensure that all reporting requests use the

Unlock SOA-C02 to see the answer

You've previewed enough free SOA-C02 questions. Unlock SOA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full SOA-C02 PracticeBrowse All SOA-C02 Questions