The answer is to restore the database to the specified point in time into a new DB instance. This is correct because Amazon RDS for PostgreSQL supports Point-in-Time Recovery (PITR), which uses automated backups and transaction logs to restore a database to any second within the backup retention period, up to the last five minutes. Since the accidental deletion occurred about 90 minutes ago, you can specify that exact timestamp, and RDS will replay the logs to recreate the database state just before the data was lost. On the SAA-C03 exam, this scenario tests your understanding that PITR always creates a new DB instance rather than modifying the existing one—a common trap is selecting an option that attempts to roll back the current instance. Remember the memory tip: "PITR creates a clone, not a cure," meaning you always restore to a new instance to avoid overwriting the original.
SAA-C03 Design Resilient Architectures Practice Question
This SAA-C03 practice question tests your understanding of design resilient architectures. Read the scenario carefully and evaluate each option against the stated constraints before committing to an answer. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
Exhibit
Amazon RDS settings
DBInstanceIdentifier: prod-orders
Engine: postgres
MultiAZ: false
BackupRetentionPeriod: 7 days
Latest automated backup: 2026-04-28T08:00:00Z
Incident log
2026-04-28T10:42:17Z: DELETE FROM orders WHERE order_date < '2026-01-01';
2026-04-28T10:43:05Z: Mistake discovered
Recovery objective
Restore to 2026-04-28T10:35:00Z, the last safe point before the deletion.
Based on the exhibit, an administrator accidentally deleted data from Amazon RDS for PostgreSQL about 90 minutes ago. Which recovery approach best restores the database to the exact required point in time?
Clue words in this question
Noticing these words before you look at the options changes how you read each choice.
Clue: "best"
Why it matters: Signals that multiple options may be partially correct. Choose the option that most directly solves the exact problem described, not the one that sounds most complete.
Amazon RDS settings
DBInstanceIdentifier: prod-orders
Engine: postgres
MultiAZ: false
BackupRetentionPeriod: 7 days
Latest automated backup: 2026-04-28T08:00:00Z
Incident log
2026-04-28T10:42:17Z: DELETE FROM orders WHERE order_date < '2026-01-01';
2026-04-28T10:43:05Z: Mistake discovered
Recovery objective
Restore to 2026-04-28T10:35:00Z, the last safe point before the deletion.
A
Restore the latest automated snapshot back onto the existing DB instance.
Why wrong: A snapshot restore returns the database to the time the snapshot was taken, not to an exact minute before the incident. It also cannot preserve later valid changes that occurred after the snapshot and before the mistaken delete.
B
Restore the database to the specified point in time into a new DB instance.
Point-in-time restore uses automated backups plus transaction logs to recreate the database at a specific moment. For accidental deletion, this is the correct RDS recovery method because it can recover the database to just before the bad change while preserving all legitimate data up to that point.
C
Create a read replica and promote it after the deletion is noticed.
Why wrong: A read replica continuously applies changes from the source database, including the accidental delete. Promoting it would not roll the data back and would simply make the deleted state the new primary.
D
Enable Multi-AZ so the database can automatically undo application mistakes.
Why wrong: Multi-AZ improves availability during infrastructure failure, but it does not protect against logical corruption or user error. The same bad DELETE would be replicated to the standby.
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Restore the database to the specified point in time into a new DB instance.
Amazon RDS for PostgreSQL supports Point-in-Time Recovery (PITR), which allows you to restore a DB instance to any second within the backup retention period, up to the last five minutes. Since the deletion occurred approximately 90 minutes ago, you can restore to that exact point in time by specifying the timestamp, and RDS will create a new DB instance from automated backups and transaction logs. This is the only option that recovers the exact state before the accidental deletion.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
✗
Restore the latest automated snapshot back onto the existing DB instance.
Why it's wrong here
A snapshot restore returns the database to the time the snapshot was taken, not to an exact minute before the incident. It also cannot preserve later valid changes that occurred after the snapshot and before the mistaken delete.
✓
Restore the database to the specified point in time into a new DB instance.
Why this is correct
Point-in-time restore uses automated backups plus transaction logs to recreate the database at a specific moment. For accidental deletion, this is the correct RDS recovery method because it can recover the database to just before the bad change while preserving all legitimate data up to that point.
Clue confirmation
The clue word "best" in the question point toward this answer.
Related concept
Read the scenario before looking for a memorised answer.
✗
Create a read replica and promote it after the deletion is noticed.
Why it's wrong here
A read replica continuously applies changes from the source database, including the accidental delete. Promoting it would not roll the data back and would simply make the deleted state the new primary.
✗
Enable Multi-AZ so the database can automatically undo application mistakes.
Why it's wrong here
Multi-AZ improves availability during infrastructure failure, but it does not protect against logical corruption or user error. The same bad DELETE would be replicated to the standby.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates confuse automated snapshots with point-in-time recovery, assuming a snapshot restore can target a specific time, when in fact snapshots are point-in-time captures and cannot replay transaction logs to reach an arbitrary second.
Detailed technical explanation
How to think about this question
RDS PITR works by replaying transaction logs (WAL segments in PostgreSQL) against a base snapshot to reconstruct the database at any specified second within the backup retention window. The retention period defaults to 7 days but can be configured up to 35 days; as long as the deletion occurred within that window and the logs are intact, PITR can restore to the exact second. Note that RDS does not allow restoring to a point in time on the same existing DB instance; it always creates a new instance, which you can then rename or use to replace the original.
KKey Concepts to Remember
Read the scenario before looking for a memorised answer.
Find the constraint that changes the correct option.
Eliminate answers that are true in general but not in this case.
TExam Day Tips
→Watch for words such as best, first, most likely and least administrative effort.
→Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
How this comes up in practice
A cloud solutions architect for a retail company is evaluating services for a new workload. The correct answer here reflects best practice for the specific scenario described — not a general cloud recommendation. Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option. Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.
What to study next
Got this wrong? Here's your next step.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Design Resilient Architectures — This question tests Design Resilient Architectures — Read the scenario before looking for a memorised answer..
What is the correct answer to this question?
The correct answer is: Restore the database to the specified point in time into a new DB instance. — Amazon RDS for PostgreSQL supports Point-in-Time Recovery (PITR), which allows you to restore a DB instance to any second within the backup retention period, up to the last five minutes. Since the deletion occurred approximately 90 minutes ago, you can restore to that exact point in time by specifying the timestamp, and RDS will create a new DB instance from automated backups and transaction logs. This is the only option that recovers the exact state before the accidental deletion.
What should I do if I get this SAA-C03 question wrong?
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Are there clue words in this question I should notice?
Yes — watch for: "best". Signals that multiple options may be partially correct. Choose the option that most directly solves the exact problem described, not the one that sounds most complete.
What is the key concept behind this question?
Read the scenario before looking for a memorised answer.
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 →
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 developer accidentally corrupts part of a production Amazon RDS database, and the issue is discovered 45 minutes later. The team needs to restore the database to the state immediately before the change. Which two actions should be part of the recovery plan? Select two.
easy
✓ A.Enable automated backups with a retention period that covers the recovery window.
✓ B.Perform a point-in-time restore to a new database instance.
C.Convert the database to a single-AZ deployment for faster restores.
D.Delete the corrupted rows manually and continue without restoring.
E.Use a read replica as the only recovery source for all deletions.
Why A: Option A is correct because automated backups must be enabled to allow point-in-time recovery (PITR) within the retention window. Since the corruption occurred 45 minutes ago, the retention period must cover at least that duration to restore to the state immediately before the change. Option B is correct because PITR restores the database to a specified time (down to the second) within the backup retention period, creating a new DB instance that reflects the state just before the corruption.
Variation 2. A team accidentally updates critical rows in an Amazon RDS for PostgreSQL database. Automated backups are enabled. They need to recover the data to the exact state as of 90 minutes ago.
They also cannot risk interrupting the current production database instance while investigators validate the restored data.
Which recovery strategy best meets these constraints?
medium
✓ A.Use point-in-time recovery (PITR) to restore to a new RDS DB instance as of 90 minutes ago, then validate and cut over after approval.
B.Restore a manual snapshot and overwrite the existing production DB instance so the data matches exactly 90 minutes ago.
C.Wait for the next automated backup window and then restart the current DB instance to roll back changes automatically.
D.Use cross-region read replicas to rewind changes and promote the replica to become the writer immediately.
Why A: Point-in-time recovery (PITR) for Amazon RDS allows you to restore a DB instance to any second within the backup retention period, using automated backups and transaction logs. By restoring to a new RDS instance as of 90 minutes ago, you create an isolated copy for validation without affecting the production database. This meets both the recovery point objective (RPO) of 90 minutes and the constraint of no interruption to the current production instance.
Variation 3. A production team accidentally deletes critical rows in an Amazon RDS for PostgreSQL database. The deletion occurred about 6 hours ago. The team wants to recover to a specific point in time with minimal disruption.
Assuming automated backups are enabled, which approach provides the best resilience outcome?
medium
A.Restore the current DB instance in place by overwriting it with only the latest automated backup.
✓ B.Use point-in-time recovery (PITR) to restore a new DB instance to a timestamp shortly before the deletion, then switch application traffic to the restored instance.
C.Create a manual snapshot and restore from it only if the snapshot date exactly matches today.
D.Perform a database-level rollback using transaction logs from the application server without using RDS restore features.
Why B: Point-in-time recovery (PITR) allows you to restore a new DB instance to any second within the automated backup retention period, which includes transaction logs. By restoring to a timestamp just before the deletion, you recover the lost rows without affecting the current production instance, then switch traffic to the new instance for minimal disruption.
Variation 4. A developer accidentally deletes important rows in an RDS database. The mistake is discovered 45 minutes later. The database has automated backups enabled with a retention period of 7 days. What is the best way to restore the database to a point just before the deletion?
medium
A.Restore the latest manual snapshot and then run SQL scripts to revert the deletion.
✓ B.Use point-in-time restore (PITR) to restore the database to a specific timestamp before the deletion, based on automated backups.
C.Promote an existing read replica to be the primary and then copy the missing rows from logs.
D.Recreate the instance using the most recent CloudWatch metric alarm snapshot of storage metrics.
Why B: Point-in-time restore (PITR) allows you to restore an RDS DB instance to any second within the automated backup retention period (here, 7 days). Since the deletion occurred 45 minutes ago, you can specify a timestamp just before the deletion, and RDS will replay the transaction logs to bring the database to that exact state. This is the most precise and efficient recovery method for accidental data modifications.
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.
This SAA-C03 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 SAA-C03 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.