Answer-first summary for fast verification
Answer: Create an auto scaling policy targeting 195 for the DatabaseConnections metric.
Aurora Auto Scaling can add replicas based on DatabaseConnections metric, set target around 195 to scale before hitting 200. Vertical scale not auto for spikes, serverless is for ACU not replicas necessarily, multi-writer is for Aurora Serverless v2 or specific.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
An Aurora MySQL DB cluster has one replica. Read performance degrades above 200 user connections; load is consistently ~180 but spikes above 200. A solution must auto-scale as demand changes. Which solution meets this?
A
Increase the Aurora Replica instance size.
B
Change to serverless mode when connections exceed 200.
C
Migrate to an Aurora DB cluster with multiple writer instances.
D
Create an auto scaling policy targeting 195 for the DatabaseConnections metric.
No comments yet.