DBS-C01 Management and Operations Practice Question
A company is running an Amazon RDS for MySQL DB instance with Multi-AZ. The company wants to perform a major version upgrade with minimal downtime. Which TWO actions should be taken? (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
✓
Use the AWS Management Console to modify the DB instance and apply the upgrade immediately.
The correct answers are B and D. Option B: Using the AWS Management Console to modify the DB instance and apply the upgrade immediately is a valid method to perform a major version upgrade, though it will cause some downtime. Option D: Creating a read replica, upgrading it first, and promoting it minimizes downtime because the primary remains available during the upgrade. Option A is incorrect because the --allow-major-version-upgrade flag is used with the AWS CLI, but it must be combined with a modification; however, simply using the flag is not sufficient. Option C is incorrect because automatic minor version upgrades do not affect major version upgrades. Option E is incorrect because restoring a snapshot does not upgrade the engine version.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use the AWS CLI to modify the DB instance with the --allow-major-version-upgrade flag.
Why it's wrong here
This is a valid way to initiate the upgrade, but it does not minimize downtime by itself.
- ✓
Use the AWS Management Console to modify the DB instance and apply the upgrade immediately.
Why this is correct
For Multi-AZ, this performs the upgrade on the standby first, then fails over, minimizing downtime.
- ✗
Enable automatic minor version upgrades on the DB instance.
Why it's wrong here
Automatic minor version upgrades do not apply to major version upgrades.
- ✓
Create a read replica, upgrade the replica to the new version, and promote it to become the primary.
Why this is correct
This approach allows testing and reduces downtime by switching over.
- ✗
Take a snapshot and restore to the new version.
Why it's wrong here
Restoring from snapshot causes significant downtime.
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.