Q86 — AWS SOA-C02 Ch.1

Question 86 of 100 | ← Chapter 1

A company is running production workloads that use a Multi-AZ deployment of an Amazon RDS for MySQL db.m6g.xlarge (general purpose) standard DB instance. Users report that they are frequently encountering a “too many connections” error. A SysOps administrator observes that the number of connections on the database is high. The SysOps administrator needs to resolve this issue while keeping code changes to a minimum. Which solution will meet these requirements MOST cost-effectively?

• A. Modify the RDS for MySQL DB instance to a larger instance size.
• B. Modify the RDS for MySQL DB instance to Amazon DynamoDB.
• C. Configure RDS Proxy. Modify the application configuration file to use the RDS Proxy endpoint. ✓
• D. Modify the RDS for MySQL DB instance to a memory optimized DB instance.

Correct Answer: C. Configure RDS Proxy. Modify the application configuration file to use the RDS Proxy endpoint.

Explanation

该题考察对AWS数据库连接管理的理解。RDS Proxy是AWS提供的一项服务，主要用于管理数据库连接池，减少因过多连接导致的性能问题。当应用程序频繁创建数据库连接时，RDS Proxy可以通过复用现有连接来降低数据库实例的连接压力。使用RDS Proxy仅需修改应用程序的数据库终端节点指向代理，无需大规模重构代码。相比升级实例规格（选项A、D）或更换数据库类型（选项B），RDS Proxy在成本和代码改动方面更具优势。AWS官方文档指出，RDS Proxy适用于需要高效处理突发连接数的场景，帮助避免“too many connections”错误。