DBS-C01 · Question #283
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…
The correct answer is B. Navigate to RDS Performance Insights. Select the database that is associated with the. To identify which SQL statements are consuming the most load on an Amazon RDS for MySQL database that is performing slowly under load, use RDS Performance Insights.
Question
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?
Options
- ANavigate to RDS Performance Insights. Select the database that is associated with the
- BNavigate to RDS Performance Insights. Select the database that is associated with the
- CNavigate to Amazon CloudWatch. Select the metrics for the appropriate DB instance. Review the
- DNavigate to Amazon CloudWatch. Find the log group for the application's database. Review the
How the community answered
(37 responses)- A14% (5)
- B76% (28)
- C5% (2)
- D5% (2)
Why each option
To identify which SQL statements are consuming the most load on an Amazon RDS for MySQL database that is performing slowly under load, use RDS Performance Insights.
The choice is incomplete, but focuses on RDS Performance Insights, which is the correct tool.
Amazon RDS Performance Insights provides a visual dashboard that directly breaks down database load by SQL statements, waits, hosts, and users, making it the most effective tool for identifying the top-consuming SQL queries responsible for performance bottlenecks. It offers granular, real-time data specifically for diagnosing database performance issues.
Amazon CloudWatch metrics provide high-level operational data like CPU utilization and IOPS, but they do not offer granular insight into individual SQL statement performance or specific queries causing the load.
While database logs in Amazon CloudWatch Logs (e.g., slow query logs) can provide some information about slow SQL statements, analyzing them to aggregate and determine 'most load consuming' queries requires manual effort or additional tooling, whereas Performance Insights provides this information readily in a dashboard.
Concept tested: Identifying slow SQL queries with RDS Performance Insights
Source: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.PI.html
Topics
Community Discussion
No community discussion yet for this question.