nerdexam
Amazon

SOA-C02 · Question #575

An application uses an Amazon Aurora MySQL DB cluster that includes one Aurora Replica. The application's read performance degrades when there are more than 200 user connections. The number of user…

The correct answer is D. Create an auto scaling policy that has a target value of 195 for the DatabaseConnections metric. See the full explanation below for the reasoning.

Submitted by neha2k· Mar 30, 2026Deployment, Provisioning, and Automation

Question

An application uses an Amazon Aurora MySQL DB cluster that includes one Aurora Replica. The application's read performance degrades when there are more than 200 user connections. The number of user connections is approximately 180 on a consistent basis. Occasionally, the number of user connections increases rapidly to more than 200. A SysOps administrator must implement a solution that will scale the application automatically as user demand increases or decreases. Which solution will meet these requirements?

Options

  • AModify the DB cluster by increasing the Aurora Replica instance size.
  • BModify the DB cluster by changing to serverless mode whenever the number of user connections
  • CMigrate to a new Aurora DB cluster that has multiple writer instances. Modify the application's
  • DCreate an auto scaling policy that has a target value of 195 for the DatabaseConnections metric.

How the community answered

(28 responses)
  • A
    14% (4)
  • B
    21% (6)
  • C
    7% (2)
  • D
    57% (16)

Topics

#Aurora Auto Scaling#Database Scaling#Read Replicas#Performance Optimization

Community Discussion

No community discussion yet for this question.

Full SOA-C02 Practice