AWS Certified Database – Specialty — Question 204

A company is preparing to release a new application. During a load test on the application before launch, the company noticed that its Amazon RDS for MySQL database responded more slowly than expected. As a result, the application did not meet performance goals. A database specialist must determine which SQL statements are consuming the most load.

Which set of steps should the database specialist take to obtain this information?

Answer options

• A. Navigate to RDS Performance Insights. Select the database that is associated with the application. Update the counter metrics to show top_sql. Update the time range to when the load test occurred. Review the top SQL statements.
• B. Navigate to RDS Performance Insights. Select the database that is associated with the application. Update the time range to when the load test occurred. Change the slice to SQL. Review the top SQL statements.
• C. Navigate to Amazon CloudWatch. Select the metrics for the appropriate DB instance. Review the top SQL statements metric for the time range when the load test occurred. Create a CloudWatch dashboard to watch during future load tests.
• D. Navigate to Amazon CloudWatch. Find the log group for the application's database. Review the top-sql-statements log file for the time range when the load test occurred.

Correct answer: B

Explanation

The correct answer is B because it specifically directs the database specialist to set the time range for the load test and switch the slice to SQL, which is necessary for identifying the top SQL statements. Option A does not change the slice to SQL, which is crucial for the analysis. Options C and D do not utilize RDS Performance Insights, which is the best tool for analyzing SQL performance in this context.