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?
Click on the arrows to vote for the correct answer
A. B. C. D.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.htmlThe optimal solution for this scenario is A. Amazon Aurora Global Database.
Explanation:
A. Amazon Aurora Global Database is designed to provide fast, local reads and writes across multiple regions. With Aurora Global Database, a single Aurora database can span multiple AWS regions, allowing for low latency global reads and writes. In this scenario, the data storage is required in three AWS regions deployed in an active-active configuration, which means the database should be accessible from all three regions and writes should be replicated to all regions simultaneously. Aurora Global Database meets this requirement as it replicates data automatically to secondary regions with typical replication latency of less than a second.
B. Amazon DynamoDB with global tables is also a good option for multi-region deployments. DynamoDB global tables provide a fully managed, multi-region, multi-master database solution that enables you to replicate data across regions for low-latency global access. However, DynamoDB global tables do not offer the same level of consistency as Aurora Global Database, which is required for a business-critical application.
C. Amazon Athena with Amazon S3 cross-region replication is not an appropriate solution for this scenario. Athena is a serverless interactive query service that allows you to query data stored in Amazon S3. Amazon S3 can be replicated across regions using cross-region replication, but this solution is not designed for active-active database synchronization.
D. Amazon RDS with Multi-AZ is not an appropriate solution for this scenario. Multi-AZ is a high-availability solution that provides automatic failover to a replica instance in the same region in the event of a primary instance failure. While Multi-AZ can provide read replicas in the same region, it does not provide active-active database synchronization across regions.
Therefore, the best solution for this scenario is A. Amazon Aurora Global Database, as it provides low-latency global access and automatic data synchronization across regions.