AWS Certified Solutions Architect – ProfessionalDesign for New SolutionsMedium
A large e-commerce company is designing a new product catalog service that will serve millions of users globally. The service requires extremely low latency reads and writes, high availability across multiple AWS regions, and the ability to scale to handle unpredictable traffic spikes during peak shopping seasons. Data consistency is eventually consistent for most reads, but strong consistency is required for critical updates. Which database solution should a solutions architect recommend?
- AAmazon Redshift with cross-region snapshots
- BAmazon DynamoDB Global Tables
- CAmazon RDS for MySQL with cross-region replication
- DAmazon Aurora Global Database
Show answer & explanationAnswer & explanation
Correct answer: B. Amazon DynamoDB Global Tables
DynamoDB Global Tables provide active-active replication across multiple regions for extremely low-latency reads and writes, global scalability, and high availability. It supports both eventual and strong consistency, fitting the mixed consistency requirements for a global product catalog.
Why the other options are wrong
- A. Amazon Redshift is a data warehouse solution designed for analytical workloads, not for operational transactional workloads requiring extremely low-latency reads and writes for a product catalog service.
- C. RDS for MySQL with cross-region replication is typically asynchronous and offers read replicas for scaling reads, but it doesn't provide the active-active write capabilities or the extreme low-latency global write performance and scalability of DynamoDB Global Tables.
- D. Aurora Global Database provides fast cross-region replication for relational databases but might not scale to the 'millions of users globally' with 'extremely low latency reads and writes' as efficiently as DynamoDB for this use case, especially with unpredictable traffic spikes.
DynamoDB Global Tables
A fully managed, multi-region, multi-master database that provides fast, local read and write performance for globally distributed applications, offering active-active replication across chosen AWS regions.
- Multi-master, active-active replication across regions.
- Extremely low-latency reads/writes for global users.
- Massive scalability and high availability.
- Supports both eventual and strongly consistent reads.
Memory trick: DynamoDB Global Tables make data instantly accessible everywhere, like a global lightning bolt.