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

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 337 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 337
Topic #: 1
[All AWS Certified Database - Specialty Questions]

An online bookstore uses Amazon Aurora MySQL as its backend database. After the online bookstore added a popular book to the online catalog, customers began reporting intermittent timeouts on the checkout page. A database specialist determined that increased load was causing locking contention on the database. The database specialist wants to automatically detect and diagnose database performance issues and to resolve bottlenecks faster.

Which solution will meet these requirements?

  • A. Turn on Performance Insights for the Aurora MySQL database. Configure and turn on Amazon DevOps Guru for RDS.
  • B. Create a CPU usage alarm. Select the CPU utilization metric for the DB instance. Create an Amazon Simple Notification Service (Amazon SNS) topic to notify the database specialist when CPU utilization is over 75%.
  • C. Use the Amazon RDS query editor to get the process ID of the query that is causing the database to lock. Run a command to end the process.
  • D. Use the SELECT INTO OUTFILE S3 statement to query data from the database. Save the data directly to an Amazon S3 bucket. Use Amazon Athena to analyze the files for long-running queries.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by narvaez at Nov. 24, 2023, 11:20 a.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
KikiNoviandi
1 year, 5 months ago
Selected Answer: A
Turn on Performance Insights for the Aurora MySQL database.
upvoted 3 times
...
Ram_xyz
1 year, 6 months ago
Selected Answer: A
https://aws.amazon.com/rds/performance-insights/
upvoted 3 times
...
marll88
1 year, 6 months ago
Not B. I think CPU utilization is irrelevant because of lock contention.
upvoted 2 times
...
narvaez
1 year, 6 months ago
perhaps C
upvoted 2 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