AWS Certified Solutions Architect – Associate (SAA-C03)Design High-Performing ArchitecturesMedium
A media company wants to analyze user behavior on their website in real-time to personalize content and recommend products. They need a database that can handle millions of requests per second, store semi-structured data (user profiles, clickstream data), provide single-digit millisecond latency, and scale globally. The data model is flexible and evolving.
- AAmazon Aurora PostgreSQL
- BAmazon RDS for MySQL
- CAmazon Redshift
- DAmazon DynamoDB
Show answer & explanationAnswer & explanation
Correct answer: D. Amazon DynamoDB
Amazon DynamoDB is a fully managed, serverless NoSQL database service that provides fast and flexible single-digit millisecond performance at any scale. It's ideal for use cases requiring high throughput, low latency, and flexible schema for semi-structured data like user profiles and clickstream events, and it offers global tables for multi-region replication.
Why the other options are wrong
- A. Amazon Aurora PostgreSQL is a relational database, offering high performance but not the flexible schema or extreme scalability of DynamoDB for this specific use case.
- B. RDS for MySQL is a relational database; it struggles with the scale of 'millions of requests per second' and flexible schema requirements compared to NoSQL.
- C. Amazon Redshift is a data warehouse optimized for analytical queries on large datasets, not for real-time transactional reads/writes of individual events or flexible data models.
Amazon DynamoDB
Amazon DynamoDB is a fully managed, serverless, key-value, and document database that delivers single-digit millisecond performance at any scale.
- NoSQL database, flexible schema.
- High throughput and low latency at any scale.
- Fully managed, no servers to provision or manage.
- Supports global tables for multi-region replication.
Memory trick: DynamoDB: Dynamic Data, Dizzying Speed.