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:
Amazon Aurora global database provides low-latency replication across AWS Regions, but a pilot light deployment means minimal infrastructure is provisioned in the DR Region, resulting in a slower scaling process in case of disaster. The RTO will not be the lowest.
Amazon Aurora global database with a warm standby deployment ensures that the database is continuously synchronized with the DR Region. This provides low-latency replication and allows the infrastructure to scale as needed, offering the lowest possible RTO.
Amazon RDS Multi-AZ DB instances provide automatic failover, but they are designed for high availability within a single Region. A pilot light deployment in a second Region would lead to slower recovery times and higher latency, failing to meet the RTO requirements.
Amazon RDS Multi-AZ DB instances are designed for failover within a single Region, and a warm standby deployment in a DR Region would not provide the same level of low-latency replication as Aurora global databases, leading to a higher RTO than the correct solution.
I chart that the answer is:
Use an Amazon Aurora global database with a warm standby deployment.
From my point of view, the answer is:
Use an Amazon Aurora global database with a warm standby deployment.