SOA-C02 Question 334
Select 3You are managing an Amazon RDS MySQL database instance that has recently experienced high CPU utilization, leading to performance degradation during peak workloads. You want to optimize the database's performance and ensure efficient connection handling. Which combination of actions should you take to address the issue?
- A
Enable RDS Performance Insights to identify SQL queries consuming excessive CPU resources.
- B
Enable RDS Proxy to improve application scalability and manage database connections efficiently.
- C
Upgrade the RDS instance type to a larger instance class for better CPU and memory resources.
- D
Increase the maximum number of database connections in the RDS parameter group.
- E
Enable Multi-AZ deployment to improve the database's read performance.
Show answer and explanation
Correct answers: A, B, C
Explanation
To optimize the performance of an Amazon RDS instance experiencing high CPU utilization, enabling RDS Performance Insights helps diagnose the root cause of the issue, such as inefficient SQL queries. Using RDS Proxy improves connection handling and scalability, reducing CPU overhead caused by frequent connection management. Additionally, upgrading the instance class provides more resources to handle high workloads. Simply increasing database connections or enabling Multi-AZ does not directly address high CPU utilization or performance efficiency in this scenario.
- A. Correct.
Enabling RDS Performance Insights helps identify problematic SQL queries or workloads that are consuming excessive CPU or resources, allowing you to optimize performance effectively.
- B. Correct.
RDS Proxy helps improve application scalability by pooling and sharing database connections, reducing the CPU load caused by frequent connection establishment and termination.
- C. Correct.
Upgrading the RDS instance to a larger instance class provides more CPU and memory resources, which can help handle peak workloads more efficiently.
- D. Incorrect.
Increasing the maximum number of database connections may lead to resource contention and does not directly address the high CPU utilization issue.
- E. Incorrect.
Multi-AZ deployment improves database availability and failover capability but does not directly enhance read or performance efficiency in this scenario.