DEA-C01 Data Store Management Practice Question
A company runs an Amazon RDS for PostgreSQL instance for an OLTP application. The database size is 500 GB. The company wants to minimize downtime during backups and ensure point-in-time recovery (PITR) for the last 7 days. Which TWO features should the company use? (Choose TWO.)
⚠ Common exam trap
Watch out — candidates often confuse read replicas or manual snapshots with backup and recovery features, failing to recognize that only automated backups with a retention period enable point-in-time recovery, and that Multi-AZ is required to minimize downtime during backups by offloading them to the standby 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
✓
Enable Multi-AZ deployment for high availability.
Multi-AZ deployment for Amazon RDS provides high availability by automatically provisioning and maintaining a synchronous standby replica in a different Availability Zone. This minimizes downtime during backups by allowing automated backups to be taken from the standby instance, eliminating I/O suspension on the primary. Option C is correct because enabling automated backups with a retention period of 7 days enables point-in-time recovery (PITR) within that window, restoring the database to any second within the retention period using transaction logs.
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 Multi-AZ deployment for high availability.
Why this is correct
Multi-AZ reduces downtime during automated backups by taking backups from the standby.
- ✗
Create a read replica in a different Availability Zone.
Why it's wrong here
Read replicas are for offloading reads, not for backup or PITR.
- ✓
Enable automated backups with a retention period of 7 days.
Why this is correct
Automated backups enable PITR within the retention window.
- ✗
Create daily manual snapshots and copy them to another region.
Why it's wrong here
Manual snapshots are unnecessary if automated backups are enabled with sufficient retention.
- ✗
Enable Enhanced Monitoring to track backup progress.
Why it's wrong here
Enhanced Monitoring provides metrics, not backup functionality.
Visual reference
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.