Answer-first summary for fast verification
Answer: Use Amazon RDS Performance Insights to analyze the SQL queries that most affect database performance. Update the SQL queries based on the analysis findings., Implement RDS Proxy with connection pooling.
Amazon RDS Performance Insights is the ideal tool for monitoring database load and analyzing the specific SQL queries causing performance bottlenecks (A). To address the connection timeouts and surges in user connections, implementing Amazon RDS Proxy is the best solution. RDS Proxy provides connection pooling, which helps manage and multiplex thousands of concurrent connections efficiently to the database, reducing the overhead on the RDS instance (E).
Author: Ritesh Yadav
Ultimate access to all questions.
No comments yet.
Question #44 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.)
A
Use Amazon RDS Performance Insights to analyze the SQL queries that most affect database performance. Update the SQL queries based on the analysis findings.
B
Use Amazon CloudWatch Logs Insights to analyze the database queries and identify performance bottlenecks. Update the queries based on the analysis findings.
C
Use Amazon RDS for PostgreSQL with a single Availability Zone.
D
Disable connection pooling entirely to ensure that all user connections are treated equally, even during peak hours.
E
Implement RDS Proxy with connection pooling.