DBS-C01 Monitoring and Troubleshooting Practice Question
A company is running an Amazon RDS for MySQL Multi-AZ DB instance. They notice that the application is experiencing increased latency during peak hours. The DB instance's CPU utilization is consistently above 80%, and the Read Latency metric is high. Which action would most effectively reduce the latency without requiring application changes?
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
✓
Create a read replica and direct read queries to it.
Creating a read replica offloads read queries from the primary DB instance, reducing read latency and CPU utilization without requiring application changes. Option B is incorrect because disabling Multi-AZ removes the standby instance, reducing availability and not addressing read latency. Option C is incorrect because increasing the instance class may improve performance but does not specifically offload read traffic; read replicas are more targeted for read-heavy workloads. Option D is incorrect because the instance already has Multi-AZ enabled; enabling it again has no effect and does not reduce read latency.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Create a read replica and direct read queries to it.
Why this is correct
Correct. Offloading read queries to a read replica reduces load on the primary instance and lowers read latency.
- ✗
Disable Multi-AZ to free up resources.
Why it's wrong here
Incorrect. Disabling Multi-AZ reduces availability and does not improve read latency.
- ✗
Increase the DB instance class to a larger size.
Why it's wrong here
Incorrect. While this may improve performance, it does not specifically address read latency and may cost more without optimizing read operations.
- ✗
Enable Multi-AZ on the DB instance.
Why it's wrong here
Incorrect. The instance is already Multi-AZ; enabling it again has no effect. Multi-AZ does not reduce read latency.
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.