AWS Certified Solutions Architect – ProfessionalDesign for New SolutionsEasy
A global e-commerce company is designing a new real-time inventory management system. The system must process millions of transactions per second, provide sub-millisecond latency for both reads and writes, and be globally distributed to serve customers worldwide with high availability. Data consistency is paramount. Which AWS database solution is most appropriate for this scenario?
- AAmazon DynamoDB Global Tables
- BAmazon RDS for MySQL with cross-Region replication
- CAmazon Redshift with multi-AZ deployment
- DAmazon Aurora PostgreSQL with read replicas
Show answer & explanationAnswer & explanation
Correct answer: A. Amazon DynamoDB Global Tables
Amazon DynamoDB Global Tables provide a fully managed, multi-Region, multi-master database that delivers sub-millisecond latency and high availability for globally distributed applications, satisfying the requirements for real-time inventory and global distribution with high consistency.
Why the other options are wrong
- B. Amazon RDS for MySQL with cross-Region replication provides disaster recovery and read scaling, but not multi-master, sub-millisecond, globally distributed write capabilities required for this use case.
- C. Amazon Redshift is a data warehouse solution optimized for analytical queries, not transactional processing with sub-millisecond latency.
- D. Amazon Aurora PostgreSQL with read replicas improves read scalability but does not inherently provide multi-master write capabilities across regions with sub-millisecond latency for writes.
DynamoDB Global Tables
A fully managed, multi-Region, multi-master database that provides fast, local performance for globally distributed applications.
- Automatic replication across chosen AWS regions.
- Provides sub-millisecond read and write latency.
- Supports multi-master writes, ensuring high availability and consistency.
Memory trick: Globally Distributed Data Needs DynamoDB's Dynamic Speed and Scale.