SOA-C02 Question 336
Select 3Your organization is experiencing high database connection latency and performance issues with an Amazon RDS for MySQL instance. You have been asked to monitor and optimize the database performance. Upon reviewing Performance Insights, you notice a high number of database connections and inefficient query execution. What actions can you take to improve performance efficiency?
- A
Enable RDS Proxy to pool and manage database connections.
- B
Scale the RDS instance to a higher instance class with more CPU and memory.
- C
Enable Multi-AZ for the RDS instance to reduce latency.
- D
Review slow query logs and optimize inefficient queries.
- E
Disable Performance Insights to reduce overhead on the RDS instance.
Show answer and explanation
Correct answers: A, B, D
Explanation
To address performance issues in Amazon RDS, you can take actions such as enabling RDS Proxy to optimize connection pooling, scaling the instance class to handle higher workloads, and analyzing slow queries to optimize inefficient database operations. These steps help improve performance efficiency, whereas enabling Multi-AZ or disabling Performance Insights does not directly address performance optimization in this scenario.
- A. Correct.
Enabling RDS Proxy helps manage and pool database connections, significantly improving performance for applications with a high number of connections or short-lived transactions.
- B. Correct.
Scaling the RDS instance to a higher instance class with more CPU and memory is a valid approach to handle increased workload and improve overall database performance.
- C. Incorrect.
Enabling Multi-AZ is primarily for high availability and disaster recovery, not for reducing latency or improving performance efficiency.
- D. Correct.
Reviewing slow query logs and optimizing inefficient queries is a critical step to improve query performance and overall database efficiency.
- E. Incorrect.
Disabling Performance Insights is not recommended; instead, Performance Insights provides valuable insights to identify and troubleshoot performance bottlenecks.