Exam AWS Certified Database - Specialty topic 1 question 310 discussion

In Amazon Aurora Serverless, the performance of the database is controlled by the instance class. In the current situation, an increase in client connections is causing delays and potential connection loss in the database. To support a maximum of 2,000 concurrent connections, it is necessary to upgrade to a higher-performance instance class. The db.r3.xlarge instance class offers better performance compared to db.t3. Therefore, making this change will improve the performance of the database. By applying the changes immediately, you can resolve issues such as delays and connection losses. Hence, the most cost-effective solution that meets the requirements is to change the instance class to db.r3.xlarge and apply the changes immediately.

C First, the question is obviously wrong. In Serverless, you have no instance class or size. However, since most of the question and the answers talk about specific instance sizes, I will ignore the "Serverless" keyword. Therefore, "C" is the most cost-effective solution. It may not be the most performant or even stable, but it is cost-effective.

the question is wrong? does aurora server less has instance type? it says its running on t3 medium

Defnitely C: The maximum number of connections allowed to an Aurora MySQL DB instance is determined by the max_connections parameter in the instance-level parameter group for the DB instance. The following table lists the resulting default value of max_connections for each DB instance class available to Aurora MySQL. You can increase the maximum number of connections to your Aurora MySQL DB instance by scaling the instance up to a DB instance class with more memory, or by setting a larger value for the max_connections parameter in the DB parameter group for your instance, up to 16,000. The db.t3.medium has a default value of 90. So setting the max_connections = 2000 (by creating a new parameter group) should fit the bill. Remember we are looking for a solution that keeps our costs as low as possible. Changing the instance class to db.r3.xlarge would also work but it will cost you more. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.Performance.html

None of the answer fulfil the requirements. - Aurora Serverless db only support min ACUs to max ACUs. No db class available. - Change parameter group required reboot. In short, to meet requirements, we need to: 1. Change maxACUs to 16 2. Create new parameter group, change max_connection to 2000, apply, and reboot See: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless-v2.setting-capacity.html#aurora-serverless-v2.parameter-groups For legacy Aurora, we need to: 1. Change Aurora db server class to db.r3.xlarge 2. Create new parameter group, change max_connection to 2000, and apply https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.Performance.html Just keep in mind where to go in case AWS fix this questions during the real exam.

I'm not sure if we can modify the instance class for Aurora Serverless. So I think A and D are not right. We can not edit the default parameter group. This only leaves C possible. So We will go with C.

Why not D?