CloudGuild · Blog · Cheat sheets · Lessons · Certifications
AWS Certified Data Engineer - Associate Exam Question Walkthrough: Recovery with RDS
Explore a critical AWS RDS question to sharpen your exam prep. Understand recovery options and avoid common pitfalls.
Many candidates struggle with data recovery options in AWS RDS. The nuances between automated and manual methods can trip you up. Understanding these features is essential for success on the DEA-C01 exam.
The question
A company is using Amazon RDS for their application database. They want to ensure that they can quickly recover their data in case of accidental deletion. Which feature should they enable to achieve this?
A. Read Replicas
B. Automated Backups
C. Multi-AZ Deployments
D. Database Snapshots
Think before you scroll
Consider the purpose of each option. Focus on how they relate to data recovery, especially in the context of accidental deletions. Some features enhance performance or availability, but do not provide recovery capabilities.
The answer
The correct option is B. Automated Backups. This feature allows you to recover your database to any point in time within the backup retention period. This is critical for recovering from accidental deletions, making it the best choice in this scenario.
Why the other options lose
A. Read Replicas: While useful for scaling read operations and reducing load on the primary database, they do not assist in data recovery from accidental deletions. They replicate data but do not provide point-in-time recovery.
C. Multi-AZ Deployments: This feature enhances availability and disaster recovery by automatically failing over to a standby instance in another Availability Zone. However, it does not enable point-in-time recovery from accidental deletions.
D. Database Snapshots: Snapshots are manual backups and do not provide automated recovery options. Although they can be used for recovery, they require manual intervention and do not allow for point-in-time recovery like Automated Backups do.
The concept behind it
The underlying principle here is the difference between automated and manual backup methods. Automated Backups provide continuous, scheduled backups that can restore your database to any specific time, making them ideal for quick recovery from accidental data loss. In contrast, manual snapshots require user action and do not operate on the same schedule.
Exam trap to remember
Remember: Automated Backups are essential for point-in-time recovery, while Snapshots are manual and less reliable for quick restores.