AWS Certified SysOps Administrator – Associate — Question 238

An application team uses an Amazon Aurora MySQL DB cluster with one Aurora Replica. The application team notices that the application read performance degrades when user connections exceed 200. The number of user connections is typically consistent around 180, with occasional sudden increases above 200 connections. The application team wants the application to automatically scale as user demand increases or decreases.

Which solution will meet these requirements?

Answer options

• A. Migrate to a new Aurora multi-master DB cluster. Modify the application database connection string.
• B. Modify the DB cluster by changing to serverless mode whenever user connections exceed 200.
• C. Create an auto scaling policy with a target metric of 195 DatabaseConnections.
• D. Modify the DB cluster by increasing the Aurora Replica instance size.

Correct answer: C

Explanation

The correct option is C, as creating an auto scaling policy with a target metric allows the application to automatically adjust based on the number of database connections. Option A requires a migration that does not directly address the scaling issue. Option B suggests switching to serverless mode, which may not be the best solution for handling spikes in connections. Option D would merely increase capacity but not address automatic scaling based on demand.