ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified SysOps Administrator - Associate All Questions

View all questions & answers for the AWS Certified SysOps Administrator - Associate exam
Go to Exam

Exam AWS Certified SysOps Administrator - Associate topic 1 question 475 discussion

Exam question from Amazon's AWS Certified SysOps Administrator - Associate
Question #: 475
Topic #: 1
[All AWS Certified SysOps Administrator - Associate Questions]

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.
  • 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.
  • D. Create an auto scaling policy that has a target value of 195 for the DatabaseConnections metric.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by Aamee at Oct. 29, 2024, 6:34 p.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
numark
5 months, 1 week ago
D and chatGPT agrees>>>>To address the read performance degradation and ensure the application scales automatically based on user demand, the SysOps administrator should optimize the Amazon Aurora MySQL DB cluster for scaling. Here's the solution:Navigate to the Aurora DB cluster. Under the "Read Replicas" section, enable Auto Scaling. Define scaling policies (e.g., target CPU utilization or custom CloudWatch metrics such as DatabaseConnections).
upvoted 1 times
numark
4 months, 2 weeks ago
Amazon Aurora supports auto scaling of read replicas based on the actual workload. By setting an auto scaling policy that targets a metric like the DatabaseConnections metric, you ensure that additional read replicas are added when the number of connections approaches the specified threshold (in this case, 195). When the number of user connections decreases, the auto scaling policy can also remove replicas to reduce costs. This approach allows the database to handle increases or decreases in demand automatically.
upvoted 1 times
...
...
Aamee
5 months, 4 weeks ago
Selected Answer: D
D makes most sense here..
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago