Which solution will meet these requirements with the LOWEST recovery time objective (RTO)?
Use an Amazon Aurora global database with a pilot light deployment.
Use an Amazon Aurora global database with a warm standby deployment.
Use an Amazon RDS Multi-AZ DB instance with a pilot light deployment.
Use an Amazon RDS Multi-AZ DB instance with a warm standby deployment.
Explanations:
While an Amazon Aurora global database with a pilot light deployment allows for cross-region replication, it doesn’t provide the required low-latency, real-time updates across regions. Pilot light deployments are not fully operational in the DR region until activated, which increases RTO.
An Amazon Aurora global database with a warm standby deployment allows for continuous low-latency replication across regions. In the event of a failure, the DR region can quickly scale to full capacity, providing the lowest possible RTO for the database.
Amazon RDS Multi-AZ DB instances are designed for high availability in a single region. While it supports failover to a standby instance, it doesn’t extend to cross-region replication and cannot provide the low-latency, up-to-date database in the DR region.
Amazon RDS Multi-AZ DB instances with a warm standby deployment are not cross-region solutions. They only replicate within a single region and do not meet the requirement for low-latency, real-time updates in the DR region.
I rate that the answer is:
Use an Amazon Aurora global database with a warm standby deployment.