AWS Certified SysOps Administrator – AssociateMonitoring, Logging, and RemediationHard
A SysOps administrator is managing an Amazon RDS for PostgreSQL database. They observe intermittent spikes in database load and slow queries during specific periods. They need a tool to quickly identify the root cause of these performance issues, including specific SQL queries, waiting events, and active sessions, without requiring extensive manual log analysis. Which AWS service should be used?
- AExport RDS logs to Amazon CloudWatch Logs and use CloudWatch Logs Insights for query analysis.
- BEnable RDS Performance Insights to monitor database load and analyze SQL queries.
- CUse Amazon CloudTrail to audit all API calls made to the RDS instance.
- DConfigure Amazon CloudWatch Alarms on RDS CPU Utilization and Database Connections metrics.
Show answer & explanationAnswer & explanation
Correct answer: B. Enable RDS Performance Insights to monitor database load and analyze SQL queries.
RDS Performance Insights is specifically designed to help analyze and troubleshoot database performance. It provides a visual dashboard of database load, identifies top SQL queries, waiting events, and active sessions, making it ideal for quickly pinpointing the root cause of intermittent performance spikes and slow queries in RDS.
Why the other options are wrong
- A. Exporting logs to CloudWatch Logs and using Logs Insights can analyze query logs, but it's less efficient and provides less context (like waiting events) compared to the specialized visualization and analysis offered by Performance Insights.
- C. CloudTrail audits API calls to the RDS service (e.g., `CreateDBInstance`), not internal database activity like SQL queries or waiting events.
- D. CloudWatch Alarms indicate a problem, but they don't provide the granular detail needed to identify specific SQL queries or waiting events causing the load.
RDS Performance Insights
Amazon RDS Performance Insights is a database performance monitoring feature that helps you quickly assess the load on your database and identify the SQL queries, hosts, or users that are contributing the most to the load.
- Provides a visual dashboard of database load.
- Identifies top SQL queries, waiting events, hosts, and users.
- Helps pinpoint root causes of performance issues.
- Available for various RDS database engines.
Memory trick: Performance Insights, reveals database plights.