SOA-C03 · Question #120
A company stores critical information in an Amazon RDS for PostgreSQL database. The company notices degraded performance, high CPU utilization, increased query latency, and connection timeouts…
The correct answer is A. Use Amazon RDS Performance Insights to analyze the SQL queries that most affect database E. Implement RDS Proxy with connection pooling. Performance Insights helps identify the top wait events and most resource-intensive queries so you can optimize or index them, directly reducing CPU utilization and query latency. RDS Proxy manages and pools database connections, smoothing out connection spikes and reducing…
Question
A company stores critical information in an Amazon RDS for PostgreSQL database. The company notices degraded performance, high CPU utilization, increased query latency, and connection timeouts during peak shopping hours. The company also identifies surges in user connections during peak hours. The connection surges affect the read performance of the database. The company wants to resolve the database performance issues. Which combination of steps will meet this requirement? (Choose two.)
Options
- AUse Amazon RDS Performance Insights to analyze the SQL queries that most affect database
- BUse Amazon CloudWatch Logs Insights to analyze the database queries and identify
- CUse Amazon RDS for PostgreSQL with a single Availability Zone.
- DDisable connection pooling entirely to ensure that all user connections are treated equally, even
- EImplement RDS Proxy with connection pooling.
How the community answered
(27 responses)- A81% (22)
- B4% (1)
- C11% (3)
- D4% (1)
Explanation
Performance Insights helps identify the top wait events and most resource-intensive queries so you can optimize or index them, directly reducing CPU utilization and query latency. RDS Proxy manages and pools database connections, smoothing out connection spikes and reducing overhead on the database during surges, which improves performance and reduces
Topics
Community Discussion
No community discussion yet for this question.