DBS-C01 Monitoring and Troubleshooting Practice Question
A database team is troubleshooting a performance issue on an Amazon RDS for PostgreSQL instance. They notice that the 'DiskQueueDepth' metric is consistently high. Which TWO actions should the team take to resolve this issue? (Choose TWO.)
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Enable storage auto scaling.
Options B and C are correct. A high disk queue depth indicates an I/O bottleneck on the RDS instance. Enabling storage auto scaling (B) allows the storage to automatically scale up when I/O demand increases, which can reduce queue depth. Increasing provisioned IOPS (C) directly improves the I/O performance by providing more throughput. Option A is incorrect because increasing connections can increase I/O contention, not reduce it. Option D is incorrect because PostgreSQL does not support query caching in the same way as MySQL, and it is not a solution to an I/O bottleneck. Option E is incorrect because Multi-AZ provides high availability but does not directly improve I/O performance.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Increase the number of database connections.
Why it's wrong here
More connections can increase I/O contention.
- ✓
Enable storage auto scaling.
Why this is correct
Auto scaling can increase throughput and reduce queue depth.
- ✓
Increase the provisioned IOPS for the instance.
Why this is correct
More IOPS directly addresses the I/O bottleneck.
- ✗
Enable query caching in PostgreSQL.
Why it's wrong here
Query caching is not a standard PostgreSQL feature and does not directly resolve disk queue depth.
- ✗
Enable Multi-AZ deployment.
Why it's wrong here
Multi-AZ provides high availability, not I/O performance improvement.
Visual reference
Go deeper
Related to this question
About these practice questions
One of 1,663 original DBS-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DBS-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DBS-C01 exam.