CloudGuild · Blog · Cheat sheets · Lessons · Certifications
Understanding AWS RDS Backup Strategies for the DEA-C01 Exam
Master the backup strategies for AWS RDS databases by exploring a real exam question and its correct answer.
A common challenge for candidates is choosing the right backup strategy for Amazon RDS databases. Many options exist, and each has its own implications. Understanding which option provides the most reliable solution is key to passing the AWS Certified Data Engineer - Associate exam.
The question
A data engineer is tasked with creating a backup strategy for an Amazon RDS database. Which of the following options would provide the most reliable backup solution?
A. Create manual snapshots of the database every week.
B. Enable automated backups for the RDS instance.
C. Export the database to Amazon S3.
D. Use AWS CloudTrail to log database activities.
Think before you scroll
Consider the reliability and frequency of backups. Some options may seem straightforward but lack the consistency needed for a solid backup strategy. Weigh the ability to recover data at specific points in time against the risk of data loss.
The answer
The correct option is B. Enable automated backups for the RDS instance. This approach provides continuous backup and point-in-time recovery, ensuring that you can restore the database to any moment within the retention period.
Why the other options lose
A. Create manual snapshots of the database every week. While this method can work, it relies on human intervention. Snapshots may be missed or delayed, leading to potential data loss.
C. Export the database to Amazon S3. Exporting may seem like a backup, but it does not account for point-in-time recovery. It’s more of a data transfer than a backup strategy.
D. Use AWS CloudTrail to log database activities. CloudTrail is useful for auditing and monitoring, but it does not provide any data backup functionality. It tracks changes and activities, not the actual data.
The concept behind it
The principle of automated backups in Amazon RDS ensures your data is continuously protected. It allows for point-in-time recovery, meaning you can restore your database to any time within the designated retention period. Understanding this concept helps with various questions about data safety in AWS environments.
Exam trap to remember
The two-question rule applies: if a question asks for the most reliable option, look for solutions that provide automation and point-in-time recovery. Manual processes are often less reliable.