SAA-C03 Design Resilient Architectures Practice Question
A Multi-AZ Amazon RDS database experiences incorrect writes at 10:15 UTC due to a buggy release. The team detects the problem at 10:25 UTC. They want to restore the data to a known-good point around 10:15 UTC, and validate the recovered data, without taking the current production instance offline during the recovery process. What is the most appropriate AWS action?
⚠ Common exam trap
Candidates often assume a reboot or Read Replica can undo bad writes, but neither provides a rollback mechanism; only PITR or a manual restore from a snapshot can recover to a specific point in time without affecting the live instance.
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 (PITR) to a new DB instance using a restore time around 10:15 UTC, then test the restored instance before cutting over.
Amazon RDS point-in-time recovery (PITR) allows you to restore a DB instance to any second within the backup retention period, creating a new, independent DB instance. This lets you validate the recovered data without affecting the current production instance, which remains online and serving traffic. The team can then cut over to the restored instance after confirming it is clean.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Immediately reboot the RDS instance and rely on the reboot to roll back the bad writes.
Why it's wrong here
Rebooting an Amazon RDS instance primarily restarts the underlying operating system and database engine processes. While it can resolve some operational issues by clearing memory caches and reinitializing services, it does not provide a mechanism to logically roll back committed transactions or undo incorrect writes that have already been persisted to storage. Committed data remains durable across reboots, making this action ineffective for recovering from application-level data corruption.
- ✓
Perform a point-in-time restore (PITR) to a new DB instance using a restore time around 10:15 UTC, then test the restored instance before cutting over.
Why this is correct
PITR restores to a specific timestamp using backups and transaction logs. Importantly, it creates a recovered copy (typically a new DB instance), which allows validation and cutover decisions without stopping or directly impacting the existing production instance.
- ✗
Create a new Read Replica from the current primary and use it as the recovered database after applying reverse migrations.
Why it's wrong here
A read replica copies the current state, including the bad writes. Reverse migrations are an application-level strategy and are not equivalent to restoring to an earlier transaction time (and may not correctly undo all effects).
- ✗
Temporarily disable Multi-AZ to speed up storage rollback, then re-enable Multi-AZ.
Why it's wrong here
Disabling Multi-AZ for an Amazon RDS instance is a configuration change that removes the synchronous standby replica, reducing high availability and failover capabilities. Multi-AZ is designed for disaster recovery and automatic failover in case of an Availability Zone outage or primary instance failure, not for data recovery from logical errors like incorrect writes. There is no "storage rollback" feature associated with Multi-AZ, and disabling it would only increase downtime risk without addressing the data corruption.
Go deeper
Related to this question
About these practice questions
This SAA-C03 question is part of Courseiva's 302-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.