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 require manual effort and do not support point-in-time recovery.
- ✓
Set the backup retention period to 35 days and enable automatic backups.
Why this is correct
Automated backups allow point-in-time recovery within the retention period.
- ✗
Set the backup retention period to 7 days and create daily manual snapshots.
Why it's wrong here
7 days is insufficient and manual snapshots lack point-in-time recovery.
- ✗
Disable automated backups and rely on Multi-AZ for recovery.
Why it's wrong here
Multi-AZ provides failover, not backups.
Go deeper
Related to this question
About these practice questions
One of 1,711 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: Enabling automated backups in Amazon RDS for MySQL allows point-in-time recovery (PITR) to any second within the retention period. Option C is correct because setting the backup retention period to the desired number of days (1–35 days) defines how far back you can perform PITR, and it must be explicitly configured to enable automated backups.
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 are a built-in feature of RDS that automatically creates daily snapshots of the DB instance and backs up transaction logs every 5 minutes, enabling point-in-time recovery to any second within the retention period. This is the native, no-cost mechanism for backing up an RDS for SQL Server DB instance without additional configuration beyond setting the backup retention window.
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.