Amazon RDS Backup Retention: Configuring Automated Backups for PITR
A company is using Amazon RDS for MySQL and needs to automate backups with a retention period of 35 days. They also want to be able to restore to any point within the retention period. Which configuration should be used?
Quick Answer
The correct configuration is to set the backup retention period to 35 days and enable automatic backups. This works because Amazon RDS for MySQL uses automated backups to capture daily snapshots and transaction logs, which together enable point-in-time recovery (PITR) to any second within the retention window. By setting the retention period to 35 days, you ensure that both the daily snapshots and the transaction log backups are retained for the full duration, allowing restoration to any point within that 35-day window. On the AWS Certified Data Engineer Associate DEA-C01 exam, this concept tests your understanding of how automated backup retention directly enables PITR, and a common trap is confusing manual snapshots (which do not support PITR) with automated backups. Remember that automated backups are the only way to achieve second-level recovery, while manual snapshots only restore to the snapshot time. A helpful memory tip: think of automated backups as a "continuous tape" that records every change, while manual snapshots are just single photographs.
⚠ Common exam trap
Many candidates confuse manual snapshots (which are retained indefinitely but do not support PITR) with automated backups (which support PITR but have a maximum retention of 35 days), leading them to choose Option A or C, thinking manual snapshots can extend the PITR window.
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
✓
Set the backup retention period to 35 days and enable automatic backups.
Amazon RDS for MySQL supports automated backups with a configurable retention period of up to 35 days. By setting the backup retention period to 35 days and enabling automatic backups, RDS automatically performs daily snapshots and transaction log backups, enabling point-in-time recovery (PITR) to any second within the retention window. This meets the requirement for both a 35-day retention and full PITR capability without manual intervention.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Enable manual snapshots daily and retain for 35 days.
Why it's wrong here
Manual snapshots capture only the moment taken, so no continuous transaction log replay exists to reach an arbitrary point between snapshots. It tempts because snapshots do satisfy a 35-day retention, and would suffice if the requirement were periodic recovery points rather than point-in-time restore.
- ✓
Set the backup retention period to 35 days and enable automatic backups.
Why this is correct
Automatic backups capture daily snapshots plus continuous transaction logs, enabling point-in-time recovery to any second within the retention window. Setting retention to 35 days satisfies the stated requirement exactly, since RDS permits 0–35 days for MySQL. Manual snapshots alone cannot deliver point-in-time restore.
- ✗
Set the backup retention period to 7 days and create daily manual snapshots.
Why it's wrong here
Automated backups beyond seven days are deleted, and manual snapshots add no transaction-log replay, so restores cannot target arbitrary points across 35 days. It tempts because layering snapshots onto a short retention appears to extend coverage, and would work if only daily restore points were needed.
- ✗
Disable automated backups and rely on Multi-AZ for recovery.
Why it's wrong here
Multi-AZ maintains a synchronous standby for failover, not historical copies, so disabling automated backups removes every point-in-time restore capability. It tempts because Multi-AZ sounds like a data-protection mechanism, and it would be the right choice for availability during an AZ outage rather than backup.
Go deeper
Related to this question
About these practice questions
One of 1,321 original DEA-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
2 more ways this is tested on DEA-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 is using Amazon RDS for MySQL and wants to automate backups for point-in-time recovery. Which TWO actions should be taken? (Choose TWO.)
easy- ✓ A.Enable automated backups with a retention period.
- B.Use AWS Backup to schedule backups.
- ✓ C.Set the backup retention period to the desired number of days.
- D.Enable Multi-AZ deployment.
- E.Take manual snapshots daily.
Why A: Option A is correct because enabling automated backups on an Amazon RDS for MySQL instance is what activates the continuous, automatic backup of the DB instance and its transaction logs, which is the foundation for point-in-time recovery (PITR). Option C is correct because the backup retention period (set in days, from 1 to 35) defines the window within which you can restore to any specific second using PITR; setting it to the desired number of days ensures the required recovery range is available. Together, enabling automated backups and configuring the retention period are the two required actions to automate backups for PITR on RDS MySQL. Option B is not required because AWS Backup is an optional centralized service and does not by itself enable RDS native PITR. Option D is not correct because Multi-AZ provides high availability via a synchronous standby, not the backup/PITR mechanism. Option E is not correct because manual snapshots are user-initiated, do not capture continuous transaction logs, and therefore do not support point-in-time recovery.
Variation 2. Which TWO AWS services can be used to automatically back up an Amazon RDS for SQL Server DB instance? (Choose TWO.)
easy- A.AWS Database Migration Service (DMS)
- B.AWS Data Pipeline
- ✓ C.Amazon RDS automated backups
- D.Amazon S3
- ✓ E.AWS Backup
Why C: Amazon RDS automated backups (C) are a native RDS feature that automatically takes daily snapshots of the DB instance during the backup window and continuously archives transaction logs, enabling point-in-time recovery for RDS for SQL Server. AWS Backup (E) is a fully managed, policy-driven backup service that supports RDS as a protected resource, allowing you to define backup plans with schedules and retention rules that trigger automated RDS snapshots. AWS DMS (A) is a replication and migration service, not a backup mechanism, so it does not create restorable backups. AWS Data Pipeline (B) is an orchestration service for data movement and transformation, not a backup tool for RDS. Amazon S3 (D) is object storage that can hold exported backups, but it does not itself automatically back up an RDS for SQL Server DB instance.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DEA-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 DEA-C01 exam.