AWS Certified Solutions Architect – ProfessionalDesign for New SolutionsMedium
A global e-commerce company is designing a new real-time inventory management system. The system must support millions of concurrent users, handle extremely high read and write throughput (millions of requests per second), and provide single-digit millisecond latency for inventory updates and queries globally. Data consistency is paramount, and the system needs to be highly available across multiple AWS regions. Which AWS database solution is best suited to meet these requirements?
- AAmazon Aurora MySQL with Aurora Global Database.
- BAmazon Redshift with materialized views for real-time analytics.
- CAmazon RDS for PostgreSQL with read replicas across regions.
- DAmazon DynamoDB Global Tables.
Show answer & explanationAnswer & explanation
Correct answer: D. Amazon DynamoDB Global Tables.
DynamoDB Global Tables are specifically designed for globally distributed applications, providing single-digit millisecond latency, high throughput, and automatic multi-region replication. This meets the stringent requirements for millions of concurrent users and global low-latency access with strong consistency.
Why the other options are wrong
- A. Aurora Global Database provides fast cross-region replication for disaster recovery and read scaling, but it's not a multi-master solution for global writes with single-digit millisecond latency across regions like DynamoDB Global Tables.
- B. Amazon Redshift is an analytical data warehouse, not designed for real-time transactional inventory management with millions of concurrent writes and single-digit millisecond latency.
- C. RDS for PostgreSQL with read replicas offers regional read scaling but lacks the global write capabilities and consistent low latency of DynamoDB Global Tables.
DynamoDB Global Tables
DynamoDB Global Tables provide a fully managed, multi-region, multi-master database that enables you to build globally distributed applications with low-latency data access for users worldwide.
- Automatic replication of data across multiple AWS regions.
- Provides fast, local read and write performance.
- Designed for internet-scale applications requiring high availability and global reach.
Memory trick: DynamoDB's Global Reach Ensures Instant Data Everywhere.