AWS Certified Database – Specialty — Question 279
A company's application team needs to select an AWS managed database service to store application and user data. The application team is familiar with MySQL but is open to new solutions. The application and user data is stored in 10 tables and is de-normalized. The application will access this data through an API layer using a unique ID in each table. The company expects the traffic to be light at first, but the traffic will increase to thousands of transactions each second within the first year. The database service must support active reads and writes in multiple AWS Regions at the same time. Query response times need to be less than 100 ms.
Which AWS database solution will meet these requirements?
Answer options
- A. Deploy an Amazon RDS for MySQL environment in each Region and leverage AWS Database Migration Service (AWS DMS) to set up a multi-Region bidirectional replication.
- B. Deploy an Amazon Aurora MySQL global database with write forwarding turned on.
- C. Deploy an Amazon DynamoDB database with global tables.
- D. Deploy an Amazon DocumentDB global cluster across multiple Regions.
Correct answer: C
Explanation
Amazon DynamoDB with global tables is the ideal solution because it supports true active-active replication across multiple AWS Regions, allowing local reads and writes with single-digit millisecond latency. The de-normalized table structure and access pattern via a unique ID fit perfectly with DynamoDB's NoSQL key-value design. Other options, such as Amazon Aurora MySQL global databases and Amazon DocumentDB global clusters, do not support native active-active multi-region writes, and using AWS DMS with Amazon RDS for bidirectional replication is overly complex and not designed for high-throughput active-active production workloads.