AWS Certified Database – Specialty — Question 231

A company needs to troubleshoot its Amazon Aurora Serverless MySQL database. The company selected a db.t3, medium instance class for the database's initial deployment. The database experienced light usage, and performance was normal.

As the number of client connections increases, the application that is connected to the database is experiencing higher latency and occasional lost connections. A database specialist determines that the database needs to support a maximum of 2,000 simultaneous connections.

Which solution will meet these requirements MOST cost-effectively?

Answer options

• A. Modify the instance class to db.r3.xlarge. Apply the changes immediately.
• B. Edit the default parameter group for the MySQL engine that the database uses. Change the max_connections value to 2,000. Reboot the DB instance to apply the new value.
• C. Create a new parameter group for the MySQL engine that the database uses. Set the max_connections value to 2,000. Assign the parameter group to the DB instance. Apply the changes immediately.
• D. Modify the instance class to db.t3.large. Apply the changes immediately.

Correct answer: C

Explanation

The correct answer is C because creating a new parameter group allows for the specific adjustment of the max_connections setting without altering the instance class, which is a more cost-effective solution. Options A and D involve changing the instance class, which could incur higher costs without directly addressing the connection limit. Option B modifies the default parameter group but requires a reboot, which can lead to downtime, making it less desirable than option C.