DBS-C01 Management and Operations Practice Question
A company is using Amazon RDS for MySQL with Multi-AZ deployment. The primary instance recently experienced an unexpected failover due to a hardware failure. The database is 2 TB in size and has high write throughput. Which TWO actions should the database administrator take to minimize recovery time and ensure data durability?
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 automated backups with a retention period of 1 day to allow point-in-time recovery.
Enabling automated backups with a retention period of 1 day allows for point-in-time recovery, which minimizes data loss and recovery time. Option E is correct because verifying that the failover completed successfully through the RDS event log and monitoring the new primary's status ensures data durability and confirms that the Multi-AZ deployment functioned properly. Option A is wrong because increasing the instance class does not directly reduce recovery time from a failover. Option B is wrong because disabling Multi-AZ reduces availability and does not prevent hardware failures. Option D is wrong because manual snapshots are not as immediate as automated backups for point-in-time recovery and would take longer to restore.
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 DB instance class to a larger size to handle the write load.
Why it's wrong here
Increasing instance size does not directly reduce failover time or improve recovery.
- ✗
Disable Multi-AZ and use a single-AZ deployment to avoid future failovers.
Why it's wrong here
Disabling Multi-AZ reduces availability, which is not recommended.
- ✓
Enable automated backups with a retention period of 1 day to allow point-in-time recovery.
Why this is correct
Automated backups enable point-in-time recovery, helping restore to the latest transaction.
- ✗
Take a manual snapshot of the DB instance immediately.
Why it's wrong here
Manual snapshots are useful but not as immediate as automated backups for point-in-time recovery.
- ✓
Verify that the failover completed successfully by checking the RDS event log and monitoring the new primary's status.
Why this is correct
Verifying failover ensures the new primary is operational and data is consistent.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DBS-C01 question from scratch — 1,663 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 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.