DBS-C01 Monitoring and Troubleshooting Practice Question

Correct answer & explanation

Enabling the slow query log allows the database specialist to identify long-running or inefficient queries that contribute to high CPU utilization and increased database connections, leading to connection timeouts during peak hours. Option A is incorrect because Enhanced Monitoring provides additional metrics (e.g., OS-level metrics) but does not directly address the root cause of the timeouts; it is useful for deeper analysis but not the primary troubleshooting action. Option C is incorrect because creating a read replica and redirecting read traffic reduces load on the primary for read operations, but the issue likely involves write-intensive or poorly optimized queries affecting the primary; while it might alleviate some load, it is not a direct troubleshooting step to identify the cause. Option D is incorrect because failing over to the standby instance is for high availability and disaster recovery, not for resolving performance issues; it would restart the database but not fix the underlying queries or resource contention.