DBS-C01 Workload-Specific Database Design Practice Question
A company runs a critical PostgreSQL database on Amazon RDS and needs to implement point-in-time recovery (PITR) with a recovery window of the last 35 days. Currently, automated backups are set to retain for 35 days. The database size is 500 GB. What additional configuration is required?
⚠ Common exam trap
Many exam-takers think PITR requires additional components like manual snapshots or replication slots, but RDS automated backups already include the necessary transaction logs for PITR when the retention period is set appropriately.
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
✓
No additional configuration is required; automated backups enable PITR
Amazon RDS for PostgreSQL automated backups include transaction logs, which are required for point-in-time recovery. With automated backups retained for 35 days, RDS can restore the database to any second within that retention period by replaying transaction logs against a full backup. No additional configuration is needed because PITR is an inherent feature of automated backups when the retention period is set to 35 days.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
No additional configuration is required; automated backups enable PITR
Why this is correct
RDS automatically supports PITR with automated backups.
- ✗
Enable manual snapshots every hour
Why it's wrong here
Manual snapshots are not needed for PITR.
- ✗
Set up a replication slot and stream transaction logs to S3
Why it's wrong here
Not needed; RDS handles transaction logs internally.
- ✗
Enable Multi-AZ deployment
Why it's wrong here
Multi-AZ does not affect PITR.
Go deeper
Related to this question
About these practice questions
This DBS-C01 question is part of Courseiva's 1,663-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 DBS-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 DBS-C01 exam.