DEA-C01 Data Store Management Practice Question
A company runs an Amazon RDS for PostgreSQL instance that stores financial data. The company requires point-in-time recovery (PITR) with a retention period of 35 days. Additionally, the company needs to create a new database from a specific snapshot every night for testing. Which combination of actions should the data engineer take to meet these requirements?
⚠ Common exam trap
Watch out — candidates often confuse the purpose of Multi-AZ standby instances (which are not directly usable for testing) or assume that manual snapshots alone can provide PITR, but automated backups are strictly required for point-in-time recovery in RDS.
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
✓
Enable automated backups with a 35-day retention period and create a manual snapshot each night for testing.
Automated backups in Amazon RDS for PostgreSQL support a maximum retention period of 35 days, which satisfies the PITR requirement. Additionally, creating a manual snapshot each night provides a stable, independent copy for testing without interfering with the automated backup schedule or the source database's performance.
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 automated backups with a 35-day retention period and create a manual snapshot each night for testing.
Why this is correct
Automated backups provide PITR; manual snapshots are independent and can be restored for testing.
- ✗
Create a read replica and promote it to a new instance for testing each night.
Why it's wrong here
Read replicas are for read scaling, not for creating consistent snapshots for testing.
- ✗
Enable Multi-AZ and use the standby instance for testing.
Why it's wrong here
Standby instance is not accessible for testing; Multi-AZ is for high availability.
- ✗
Disable automated backups to reduce storage costs and take manual snapshots with 35-day retention.
Why it's wrong here
Disabling automated backups removes PITR capability.
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 →
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.