SAP-C02 Continuous Improvement for Existing Solutions Practice Question
A company is using Amazon RDS for MySQL and notices that read replicas are falling behind the primary. The primary instance is experiencing high write traffic. What is the best solution to reduce replica lag?
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
✓
Increase the instance class of the read replica.
Increasing the instance class of the read replica provides it with more CPU and memory resources to apply write-ahead logs from the primary, directly addressing the replica lag caused by high write traffic. Enabling Multi-AZ on the primary (Option B) only ensures high availability and does not reduce replica lag. Disabling binary logging (Option C) would prevent replication entirely. Read replicas can be in the same region (Option D) and that does not solve lag due to resource constraints.
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 instance class of the read replica.
Why this is correct
Larger instance class can apply changes faster.
- ✗
Enable Multi-AZ on the primary instance.
Why it's wrong here
Multi-AZ is for high availability, not replica lag.
- ✗
Disable binary logging on the primary.
Why it's wrong here
Binary logging is required for replication.
- ✗
Move the read replica to the same AWS Region as the primary.
Why it's wrong here
Read replicas can be in different regions, but same region reduces lag.
Go deeper
Related to this question
About these practice questions
Courseiva writes every SAP-C02 question from scratch — 1,660 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This SAP-C02 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 SAP-C02 exam.