SOA-C02 Question 333
Select 3Your team has reported slow query performance for an Amazon RDS MySQL instance during peak hours. After reviewing the metrics in Amazon CloudWatch, you observe high CPU utilization and a large number of database connections. To improve query performance and reduce connection overhead, which combination of actions should you take?
- A
Enable RDS Proxy to manage database connections more efficiently.
- B
Use Amazon RDS Performance Insights to analyze and optimize slow-running queries.
- C
Increase the instance size of your RDS database to a higher compute capacity.
- D
Enable Multi-AZ deployment to improve query performance.
- E
Modify the database storage type to Provisioned IOPS.
Show answer and explanation
Correct answers: A, B, C
Explanation
To address high CPU utilization and a large number of database connections, combining RDS Proxy for connection management, Performance Insights for query optimization, and scaling the instance size to increase compute capacity are the most effective actions. Multi-AZ deployment and Provisioned IOPS are valuable features but are not directly relevant to the performance issues described in this scenario.
- A. Correct.
Enabling RDS Proxy helps manage and pool database connections, reducing the overhead caused by frequent connection establishment and termination. This can significantly improve performance during high connection loads.
- B. Correct.
Amazon RDS Performance Insights provides detailed metrics and query performance analysis, enabling you to identify and optimize slow-running queries, which is critical for performance tuning.
- C. Correct.
Increasing the instance size provides more compute resources (CPU and memory), which can help handle high CPU utilization and improve overall database performance.
- D. Incorrect.
Enabling Multi-AZ deployment improves availability and fault tolerance but does not directly enhance query performance.
- E. Incorrect.
Modifying the storage type to Provisioned IOPS can improve storage performance but is not directly related to addressing high CPU utilization and database connection issues.