A global company is developing an application across multiple AWS Regions. The company needs a database solution with low latency in each Region and automatic disaster recovery. The database must be…

Amazon RDS with cross-Region read replicas typically supports active-passive architectures for disaster recovery and read scaling, but building an active-active write solution with RDS across regions is complex and may not offer the lowest overall latency compared to DynamoDB global tables.

Amazon DynamoDB global tables provide a fully managed, multi-Region, active-active database that automatically replicates data across specified AWS Regions, offering single-digit millisecond latency for reads and writes globally and robust disaster recovery capabilities.

Amazon Aurora global database offers fast cross-region replication for disaster recovery and low-latency reads from secondary regions, but for fully active-active writes across multiple regions with the absolute lowest latency, DynamoDB Global Tables often have an architectural advantage due to their NoSQL, distributed design.

Amazon Athena and Amazon S3 with S3 Cross Region Replication form a data lake and analytics solution, not a transactional database solution with active-active writes and low-latency access for an application.