SOA-C02 Reliability and Business Continuity Practice Question
Network Topology
Refer to the exhibit. A SysOps administrator needs to restore the database 'mydb' to the most recent restorable time shown. However, the administrator cannot restore to that time. What is the MOST likely reason?
⚠ Common exam trap
Many candidates assume the most recent restorable time is always available or confuse the backup window with the ability to perform PITR, when in fact the root cause is that automated backups are disabled entirely.
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
✓
Automated backups are disabled (BackupRetentionPeriod is 0).
Automated backups must be enabled with a BackupRetentionPeriod greater than 0 for point-in-time recovery (PITR) to be available. When BackupRetentionPeriod is set to 0, automated backups are disabled, and the database cannot be restored to any point in time within the retention window. The exhibit shows that the most recent restorable time is not available because no automated backups exist to support PITR.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The database engine does not support point-in-time recovery.
Why it's wrong here
Point-in-time recovery is fully supported on Amazon RDS for MySQL when automated backups are enabled, so the engine is not the blocker. PITR relies on automated backups and transaction logs, and MySQL's engine natively supports the binary logs required for this feature. Therefore, the inability to restore here must stem from the backup configuration, not from a database engine limitation.
- ✓
Automated backups are disabled (BackupRetentionPeriod is 0).
Why this is correct
With BackupRetentionPeriod set to 0, automated backups are completely disabled, meaning RDS never takes daily snapshots and does not retain transaction logs for PITR. Without any automated backup or retained log, there is no recovery point available to restore from, which directly explains why the restore fails. Manual snapshots could still be used if they were created separately, but the scenario indicates no usable backup exists for restoration.
- ✗
The backup window has already passed.
Why it's wrong here
The backup window defines the daily time frame when RDS takes its automatic backup, but it does not constrain when you can perform a restore. Restores can be initiated at any point during the retention period, regardless of the backup window start or end time. Even if the backup window has already passed, that merely means the most recent automated snapshot was already taken; it does not remove your ability to restore to an earlier point.
- ✗
The database is not Multi-AZ.
Why it's wrong here
Multi-AZ deployment is an availability feature that provides failover to a standby replica in another Availability Zone, and it has no bearing on the restore process. RDS can restore backups and perform point-in-time recovery on single-AZ instances just as easily as on Multi-AZ instances. The absence of Multi-AZ only impacts high availability, not the existence or accessibility of backup data.
Go deeper
Related to this question
About these practice questions
This SOA-C02 question is part of Courseiva's 1,169-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 SOA-C02 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 SOA-C02 exam.