ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 372 - SOA-C02 discussion

Report
Export

An application uses an Amazon Aurora MySQL DB cluster that Includes one Aurora Replica The application's read performance degrades when there are more than 200 user connections. The number of user connections is approximately 180 on a consistent basis Occasionally, the number of user connections increases rapidly to more than 200

A SysOps administrator must implement a solution that will scale the application automatically as user demand increases or decreases.

Which solution will meet these requirements?

A.
Modify the DB cluster by increasing the Aurora Replica instance size.
Answers
A.
Modify the DB cluster by increasing the Aurora Replica instance size.
B.
Modify the DB cluster by changing to serverless mode whenever the number of user connections exceeds 200.
Answers
B.
Modify the DB cluster by changing to serverless mode whenever the number of user connections exceeds 200.
C.
Migrate to a new Aurora DB cluster that has multiple writer instances. Modify the application's database connection string.
Answers
C.
Migrate to a new Aurora DB cluster that has multiple writer instances. Modify the application's database connection string.
D.
Create an auto scaling policy that has a target value of 195 for the DatabaseConnections metric.
Answers
D.
Create an auto scaling policy that has a target value of 195 for the DatabaseConnections metric.
Suggested answer: D

Explanation:

Aurora Auto Scaling:

Aurora Auto Scaling adjusts the number of Aurora Replicas in response to changes in connectivity or workload.

Steps:

Go to the AWS Management Console.

Navigate to RDS and select the Aurora cluster.

Under 'Actions,' choose 'Add Aurora Replica' to initially add replicas if needed.

Go to the 'Auto Scaling' section and create an auto scaling policy.

Set the target value for the DatabaseConnections metric to 195.

Define the minimum and maximum number of replicas.

Save the configuration.

This ensures that the Aurora cluster scales automatically when the number of connections approaches the threshold, improving read performance.

asked 16/09/2024
Paul Pinero
31 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first