How to Minimize Downtime When Recovering a Dropped Table with RDS Point-in-Time Restore
A company runs a production Amazon RDS for PostgreSQL database with automated backups enabled. A database administrator accidentally dropped a critical table. The administrator wants to restore the table from a point in time before the drop. The database is 1 TB in size and the recovery point objective (RPO) is 5 minutes. Which approach minimizes downtime?
Quick Answer
The correct approach is to use point-in-time restore to a new RDS DB instance from just before the table was dropped, then export the table with pg_dump and import it into production. This minimizes downtime because restoring to a new instance keeps the production database fully online, while the point-in-time recovery (PITR) feature leverages automated backups to hit the exact 5-minute RPO without manual intervention. On the AWS Certified Database Specialty DBS-C01 exam, this scenario tests your understanding that PITR cannot restore a single table directly—you must restore the entire instance, then extract the needed object. A common trap is assuming you can restore to the existing instance, which would cause significant downtime, or using a read replica, which lacks point-in-time precision. Remember the mnemonic: **New, then Dump**—always restore to a new instance first, then dump and import the table.
⚠ Common exam trap
Many exam-takers think a read replica or manual snapshot can recover a dropped table, but they fail to realize that the drop operation is replicated to the replica and that manual snapshots may not meet the required RPO.
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 point-in-time recovery feature to restore the database to a new DB instance at a time before the drop, then use pg_dump to export the table and import it into the production database.
Amazon RDS Point-in-Time Recovery (PITR) allows restoring to any second within the backup retention window, enabling a restore to just before the table was dropped. After restoring to a new DB instance, pg_dump can export the specific table, and then pg_restore or psql can import it into the production database. This minimizes downtime by avoiding a full database restore and only moving the single dropped table.
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 point-in-time recovery feature to restore the database to a new DB instance at a time before the drop, then use pg_dump to export the table and import it into the production database.
Why this is correct
PITR allows restore to any second within the backup retention period, minimizing data loss and downtime by restoring to a new instance.
- ✗
Restore the automated backup from S3 to a new EC2 instance running PostgreSQL, then export the table and import it into the production database.
Why it's wrong here
RDS automated backups are not directly accessible as files; this is not a supported method and would be complex.
- ✗
Restore the database from the most recent manual snapshot to a new instance, then use pg_dump to extract the table and import it into the production database.
Why it's wrong here
This is slower and not point-in-time; manual snapshots may not have the exact data before the drop.
- ✗
Create a read replica from the production database, stop replication, and use pg_dump to extract the table from the replica and import it into the production database.
Why it's wrong here
A read replica may not have the exact data before the drop if replication lag exists, and this approach is not point-in-time.
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 →
Same concept, more angles
2 more ways this is tested on DBS-C01
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A company has an Amazon RDS for PostgreSQL DB instance with automated backups enabled. The retention period is set to 7 days. A developer accidentally performed a DROP TABLE operation on a critical table 2 days ago. How can the table be recovered with minimal data loss?
easy- ✓ A.Perform a point-in-time restore to a time just before the DROP TABLE operation.
- B.Use the pg_dump utility to create a manual backup and restore it.
- C.Create a read replica of the DB instance and promote it to a standalone instance.
- D.Restore the DB instance from the oldest automated snapshot.
Why A: The correct approach is to perform a point-in-time restore (PITR) to a time just before the DROP TABLE operation. RDS for PostgreSQL with automated backups enabled supports PITR within the backup retention period (7 days). Since the table was dropped 2 days ago, restoring the DB instance to a point in time just before the drop will recover the table with minimal data loss. Option B (pg_dump) is not a suitable recovery method because it requires a pre-existing backup; it cannot generate a backup retroactively. Option C (creating a read replica and promoting it) would create a copy of the current state, which already lacks the dropped table, so it does not help. Option D (restore from oldest automated snapshot) would revert the entire database to a 7-day-old state, losing all changes made in the last 7 days, including the table that was dropped only 2 days ago, resulting in greater data loss.
Variation 2. A company is using Amazon RDS for SQL Server with Multi-AZ and automated backups enabled. The database administrator needs to restore the database to a specific point in time that is within the retention period. What is the correct procedure?
easy- ✓ A.Use the RDS console to perform a point-in-time recovery to the desired time
- B.Restore from a manual snapshot taken at the desired time
- C.Use the native SQL Server backup and restore functionality
- D.Restore from the latest automated snapshot
Why A: The correct procedure for performing a point-in-time recovery within the retention period for an Amazon RDS for SQL Server instance with Multi-AZ and automated backups is to use the RDS console or API to specify the desired point in time. This restores the database to the specified time using the automated backup logs. Option B is incorrect because manual snapshots capture a specific point and cannot be used for arbitrary point-in-time recovery. Option C is incorrect because native SQL Server backup is not supported for RDS instances; AWS manages backups. Option D is incorrect because restoring from the latest automated snapshot does not give a specific point in time.
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.