SAA-C03 Question 278
Single answerA company is running a high-traffic e-commerce application that requires low-latency database responses and the ability to handle millions of requests per second during sales events. The application also requires real-time session management for logged-in users. Which database solution should you recommend to provide the best performance for these requirements?
- A
Amazon RDS using MySQL in a Multi-AZ deployment
- B
Amazon DynamoDB with on-demand capacity mode and DynamoDB Accelerator (DAX)
- C
Amazon Aurora PostgreSQL with read replicas
- D
Amazon Redshift with enhanced VPC routing enabled
Show answer and explanation
Correct answer: B
Explanation
For high-traffic applications requiring low-latency database responses and real-time session management, Amazon DynamoDB with on-demand capacity mode is the best fit due to its ability to automatically scale to handle millions of requests per second. Adding DynamoDB Accelerator (DAX) further optimizes read performance by caching responses, ensuring low latency even during peak traffic events. Relational databases like Amazon RDS and Aurora are better suited for traditional transactional workloads, while Amazon Redshift is optimized for analytic queries rather than operational use cases.
- A. Incorrect.
Amazon RDS using MySQL in a Multi-AZ deployment provides high availability and fault tolerance, but it may not handle millions of requests per second with low latency as effectively as DynamoDB. It is better suited for relational workloads with moderate traffic.
- B. Correct.
Amazon DynamoDB with on-demand capacity mode and DynamoDB Accelerator (DAX) is a highly scalable NoSQL solution that is designed to handle millions of requests per second with low latency. DAX further reduces read latency, making it an ideal choice for high-traffic applications with real-time requirements.
- C. Incorrect.
Amazon Aurora PostgreSQL with read replicas provides excellent performance for relational databases and read-heavy workloads. However, it may not scale as seamlessly as DynamoDB for millions of requests per second, and the session management use case may not be as efficient.
- D. Incorrect.
Amazon Redshift is a data warehouse solution optimized for analytical workloads, not transactional or high-traffic operational workloads. It is unsuitable for handling millions of requests per second or real-time session management.