SAA-C03 Design Resilient Architectures Practice Question
A production Amazon RDS database has automated backups enabled. At 10:45 UTC, an issue is discovered. The team needs to restore the database to its state as of 10:30 UTC. Which capability should they use?
⚠ Common exam trap
Candidates often confuse Multi-AZ failover or read replicas with point-in-time recovery capabilities, leading candidates to think failover or replica promotion can roll back to a specific past state when they only provide high availability or read scaling.
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
✓
Point-in-time restore (PITR) using automated backups to a specific timestamp.
Amazon RDS automated backups enable point-in-time recovery (PITR) to any second within the backup retention period, restoring to a new DB instance. Since the issue was discovered at 10:45 UTC and the desired recovery point is 10:30 UTC, PITR can restore the database to that exact timestamp, provided it falls within the automated backup window and retention period.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Point-in-time restore (PITR) using automated backups to a specific timestamp.
Why this is correct
Point-in-time restore (PITR) leverages RDS's automated backups and transaction logs to create a new DB instance reflecting the exact state at 10:30 UTC, precisely within your retention window. The restore process spins up a separate instance, so you can validate the data and then redirect traffic or promote it without altering your current production database. This is the only option that explicitly rolls back committed transactions to a specific timestamp, satisfying the team's requirement.
- ✗
Perform a Multi-AZ manual failover of the standby to recover to the earlier timestamp.
Why it's wrong here
A Multi-AZ manual failover only flips the primary and standby roles for high availability, preserving the same, latest replicated data state. It does not revert to a prior timestamp; any transactions committed after 10:30 UTC remain present on the promoted standby. Failover addresses availability and resilience, not point-in-time data recovery, so it fails the stated recovery objective.
- ✗
Promote a cross-region replication target to replace the current database with the last-known good copy.
Why it's wrong here
Promoting a cross-region replication target provides disaster recovery by making the replica a standalone primary, but the data on that replica lags behind the source due to asynchronous replication. Nothing guarantees that the replica's state exactly matches 10:30 UTC, and promotion does not perform a timestamp-based rollback like PITR. It is a regional recovery mechanism, not a precise data-restore tool.
- ✗
Switch to a read replica to access an older view of data without restoring.
Why it's wrong here
Read replicas only mirror the primary's ongoing changes with replication lag and exist to offload read traffic; they do not offer a historical view at an earlier timestamp. They are not designed to serve as point-in-time restore targets, and switching to one still reflects near-current data, not a 10:30 UTC snapshot. Accessing an older view would require a separate restore action, not a read replica switch.
Go deeper
Related to this question
About these practice questions
This SAA-C03 question is part of Courseiva's 935-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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 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.