Which solution will meet these requirements with the LEAST amount of operational overhead?
Provision an Aurora Replica in a different Region.
Set up AWS DataSync for continuous replication of the data to a different Region.
Set up AWS Database Migration Service (AWS DMS) to perform a continuous replication of the data to a different Region.
Use Amazon Data Lifecycle Manager (Amazon DLM) to schedule a snapshot every 5 minutes.
Explanations:
Provisioning an Aurora Replica in a different Region provides cross-region replication with minimal operational overhead. It allows for automatic failover and ensures data consistency, meeting the requirement of no data loss in case of failure.
AWS DataSync is designed for transferring data between on-premises storage and AWS services or between AWS services, but it is not typically used for continuous replication of database data across regions. It may not provide the required data consistency or low-latency access.
AWS Database Migration Service (AWS DMS) can be used for continuous data replication, but it requires more management and configuration overhead compared to using an Aurora Replica. Additionally, it is primarily meant for one-time migrations and less for ongoing, seamless operational replication.
Using Amazon Data Lifecycle Manager (Amazon DLM) to schedule snapshots provides backup but does not offer continuous replication. Snapshots are not real-time and may lead to data loss between the last snapshot and the point of failure, violating the requirement of no data loss.
I rank that the answer is:
Provision an Aurora Replica in a different Region.