AWS Certified Database – Specialty — Question 161

A database specialist is responsible for designing a highly available solution for online transaction processing (OLTP) using Amazon RDS for MySQL production databases. Disaster recovery requirements include a cross-Region deployment along with an RPO of 5 minutes and RTO of 30 minutes.
What should the database specialist do to align to the high availability and disaster recovery requirements?

Answer options

• A. Use a Multi-AZ deployment in each Region.
• B. Use read replica deployments in all Availability Zones of the secondary Region.
• C. Use Multi-AZ and read replica deployments within a Region.
• D. Use Multi-AZ and deploy a read replica in a secondary Region.

Correct answer: D

Explanation

The correct choice is D because it combines Multi-AZ for high availability with a read replica in a secondary Region, ensuring both RPO and RTO requirements are met. Option A does not address cross-Region needs, B lacks Multi-AZ for high availability, and C is limited to a single Region without disaster recovery capabilities.