Q63 — AWS SOA-C02 Ch.1

Question 63 of 100 | ← Chapter 1

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?

• 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. Create an auto scaling policy with a target metric of 195 DatabaseConnections.

Explanation

Amazon Aurora Auto Scaling允许根据指定指标（如数据库连接数）自动调整Aurora副本数量。当用户连接数接近设定阈值（195），Auto Scaling会增加副本以分摊读取负载，确保性能稳定。选项C通过配置目标跟踪策略，基于DatabaseConnections指标自动扩展副本实例数，符合自动扩缩容需求。其他选项涉及架构变更、手动调整或仅修改实例大小，无法动态响应连接数变化。参考AWS文档中关于Aurora Auto Scaling部分，明确支持基于连接数指标进行自动扩展。