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 349 discussion

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

A company hosts a production MySQL database on an Amazon Aurora single-node DB cluster. The database is queried heavily for reporting purposes. The DB cluster is experiencing periods of performance degradation because of high CPU utilization and maximum connections errors. A SysOps administrator needs to improve the stability of the database.

Which solution will meet these requirements?

  • A. Create an Aurora Replica node. Create an Auto Scaling policy to scale replicas based on CPU utilization. Ensure that all reporting requests use the read-only connection string
  • B. Create a second Aurora MySQL single-node DB cluster in a second Availability Zone. Ensure that all reporting requests use the connection string for this additional node
  • C. Create an AWS Lambda function that caches reporting requests. Ensure that all reporting requests call the Lambda function
  • D. Create a multi-node Amazon ElastiCache cluster. Ensure that all reporting requests use the ElastiCache cluster. Use the database if the data is not in the cache.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by Sourav8602 at June 29, 2023, 9:18 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
jlmadvig
Highly Voted 1 year, 9 months ago
Selected Answer: A
Creating an Aurora Replica node will offload the reporting workload from the primary DB instance, reducing the CPU utilization and improving stability. By creating an Auto Scaling policy to scale replicas based on CPU utilization, you can automatically add or remove replicas as needed to handle the reporting workload. Ensuring that all reporting requests use the read-only connection string directs the reporting workload to the replica nodes, further reducing the load on the primary DB instance.
upvoted 5 times
...
james2033
Most Recent 9 months, 3 weeks ago
Selected Answer: A
reporting --> replica
upvoted 1 times
...
suiseiroha
1 year, 9 months ago
Selected Answer: A
AAAAAAAAAAAAAAAA
upvoted 4 times
...
[Removed]
1 year, 9 months ago
AAAAAAAAAAAAA
upvoted 3 times
...
guau
1 year, 10 months ago
A, read degradation = read replica + reader endpoint
upvoted 3 times
...
Sourav8602
1 year, 10 months ago
A is the correct answer
upvoted 3 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