DBS-C01 Question #88: Real Exam Question with Answer & Explanation

Question

A company's customer relationship management application uses an Amazon RDS for PostgreSQL Multi-AZ database. The database size is approximately 100 GB. A Database Specialist has been tasked with developing a cost-effective disaster recovery plan that will restore the database in a different Region within 2 hours. The restored database should not be missing more than 8 hours of transactions. What is the MOST cost-effective solution that meets the availability requirements?

Options

• ACreate an RDS read replica in the second Region. For disaster recovery, promote the read
• BCreate an RDS read replica in the second Region using a smaller instance size. For disaster
• CSchedule an AWS Lambda function to create an hourly snapshot of the DB instance and another
• DCreate a new RDS Multi-AZ DB instance in the second Region. Configure an AWS DMS task for

Explanation

Backup and restore is the most cost-effective solution to provide a 2-hour RTO and 8-hour RPO. Manual hourly snapshots need to be copied to the second Region to be available for the creation of the new database. Taking the snapshots every hour will keep the incremental snapshot size low, reduce the time to copy the snapshot across Regions, and meet the RPO. Also, taking snapshots frequently does not impact the cost. A pair of AWS Lambda functions can be scheduled to take the snapshot and copy it to the second Region.

No community discussion yet for this question.