A company is developing a business-critical application. Their RTO and RPO requirements call for a database with data storage in three AWS regions. The company wants to minimize the latency of all database operations. What is the optimal solution for these requirements?

Answer options:

A.Amazon Aurora Global Database
B.Amazon DynamoDB with global tables
C.Amazon Aurora Multi-Master Cluster
D.Amazon RDS with Multi-AZ

Answer: B
Option A is incorrect because write operations are issued directly to the primary DB instance in the primary AWS Region. This does not reduce the latency of write operations.
Option B is CORRECT because DynamoDB global tables automatically replicate data across two or more AWS Regions, with full support for multi-master writes.
Option C is incorrect because the Aurora Multi-Master cluster supports a maximum of two DB instances in a multi-master cluster. Additionally, all DB instances in a multi-master cluster must be in the same AWS Region. These limitations do not meet the three-region requirement.
Option D is incorrect because Amazon RDS with Multi-AZ does not meet the multi-region requirement.Also, these instances are used for automatic failover. However, they are not accessible during normal operation.
Reference:
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/V2globaltables_HowItWorks.html
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Streams.CrossRegionRepl.html
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database.html