AWS Certified Database – Specialty — Question 253

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?

Answer options

• 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.

Correct answer: A

Explanation

Answer A is correct because it provides a proactive approach to automatically detect and diagnose performance issues using Performance Insights and Amazon DevOps Guru, which are designed for monitoring and improving database performance. Options B and C are reactive measures that do not address the root cause of the performance issues, while option D, although useful for analysis, does not provide automatic detection or resolution capabilities.