AWS Certified SysOps Administrator – Associate (SOA-C03) — Question 39

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.)

Answer options

• 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.

Correct answer: A, E

Explanation

Option A is correct because using Amazon RDS Performance Insights allows for a detailed analysis of the SQL queries that impact performance, enabling targeted optimizations. Option E is also correct as implementing RDS Proxy with connection pooling can efficiently manage database connections, reducing the overhead during peak times. The other options either do not directly address the performance issues or could exacerbate them.