Question 1,233 of 1,663
DBS-C01 Management and Operations Practice Question
A developer accidentally deleted a critical table from an Amazon RDS for MySQL DB instance. Automated backups are enabled with a retention period of 7 days. The deletion occurred 3 hours ago. Which action can restore the table with minimal data loss?
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
✓
Perform a point-in-time restore to a time just before the deletion.
Amazon RDS point-in-time recovery (PITR) allows restoring a DB instance to any second within the backup retention period, enabling recovery to just before the table deletion, minimizing data loss. Option B is incorrect because AWS DMS is a migration tool, not a recovery mechanism for deleted data. Option C is incorrect because restoring from the latest automated snapshot would lose all changes made after that snapshot, including the 3 hours of data before deletion. Option D is incorrect because while MySQL binary logs can be used for point-in-time recovery, RDS manages this through its automated PITR feature; manually replaying binary logs is not a supported operation in RDS.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Perform a point-in-time restore to a time just before the deletion.
Why this is correct
Point-in-time recovery allows restoring to any second within the retention period.
- ✗
Use AWS Database Migration Service to replicate the table from another source.
Why it's wrong here
DMS is not a recovery tool for deleted data.
- ✗
Restore the DB instance from the latest automated snapshot.
Why it's wrong here
The latest snapshot may be hours old and not include recent changes.
- ✗
Use the MySQL binary log to replay transactions up to the deletion.
Why it's wrong here
Direct binlog replay is not possible; you need to restore the instance first.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jun 20, 2026
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.