AWS Certified Solutions Architect – Associate (SAA-C03)Design High-Performing ArchitecturesEasy
A financial services company processes millions of transactions daily, requiring a database that can handle extremely high read and write throughput with microsecond latency. Data consistency is paramount, and the database must scale effortlessly as transaction volumes increase. Which AWS database solution is best suited for this requirement?
- AAmazon RDS for PostgreSQL
- BAmazon Redshift
- CAmazon Aurora with MySQL compatibility
- DAmazon DynamoDB
Show answer & explanationAnswer & explanation
Correct answer: D. Amazon DynamoDB
Amazon DynamoDB is a fully managed, serverless NoSQL database service that delivers single-digit millisecond performance at any scale. It is ideal for applications requiring high throughput and low latency, making it perfect for financial transaction processing.
Why the other options are wrong
- A. Amazon RDS for PostgreSQL is a relational database and while it can scale, it typically cannot achieve the microsecond latency and extreme throughput of DynamoDB for highly concurrent, non-relational workloads.
- B. Amazon Redshift is a data warehousing service optimized for analytic queries over large datasets, not for transactional workloads requiring microsecond latency.
- C. Amazon Aurora is a high-performance relational database, but for non-relational, extremely high-throughput, microsecond-latency requirements, DynamoDB is generally a better fit.
Amazon DynamoDB
A fast, flexible NoSQL database service for all applications that need consistent, single-digit millisecond latency at any scale.
- Fully managed, serverless.
- Supports document and key-value data models.
- Ideal for high-throughput, low-latency applications.
Memory trick: Think fast, think flexible, think NoSQL for peak performance.