A company is developing a business-critical application.Their RTO and RPO requirements call for a database with data storage in three AWS regions deployed in an active-active configuration.The application requires data synchronization across regions.What is the optimal solution for these requirements?

Answer options:

A.Amazon Aurora Global Database
B.Amazon DynamoDB with global tables
C.Amazon Athena with Amazon S3 cross-region replication
D.Amazon RDS with Multi-AZ

Answer: B
Option A is incorrect because Amazon Aurora Global Database does not offer the active-active capability.Amazon Aurora Global Database secondary regions are read-only.
Option B is CORRECT because Amazon DynamoDB global tables provide a fully managed solution for deploying a multi-region, multi-master database.When a DynamoDB global table is created, it consists of multiple replica tables (one per Region) that DynamoDB treats as a single unit. When an application writes data to a replica table in one Region, DynamoDB propagates the write to the other replica tables in the other AWS Regions automatically.
Option C is incorrect because Amazon Athena is used for querying data stored in S3.
Option D is incorrect because Amazon RDS with Multi-AZ does not meet the multi-region requirement or the active-active configuration requirement.Amazon RDS Multi-AZ deploys secondary instances within the same region.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/AmazonRDS/latest/AuroraUserGuide/aurora-global-database.html