SAA-C03 Question 293
Single answerA company is building a new application that requires a database to store and retrieve data. The access patterns for the application show that it will be highly read-intensive, with occasional writes. Additionally, the application must scale seamlessly during traffic spikes without requiring manual intervention. Which AWS solution is the most cost-effective and suitable for these requirements?
- A
Amazon RDS with a Multi-AZ deployment
- B
Amazon DynamoDB with on-demand capacity mode
- C
Amazon Aurora with read replicas
- D
Amazon ElastiCache for Redis
Show answer and explanation
Correct answer: C
Explanation
The application requires a database optimized for highly read-intensive workloads and seamless scaling. Amazon Aurora with read replicas meets these requirements by offering high performance for read-heavy traffic with up to 15 read replicas. It also provides automatic scaling and cost-effectiveness compared to other solutions. While other options are useful in different scenarios, they are not the most suitable choice for this specific access pattern and requirement.
- A. Incorrect.
Amazon RDS with a Multi-AZ deployment is designed for high availability and disaster recovery but is not optimized for highly read-intensive workloads. While it offers read replicas, the cost and management effort make it less suitable compared to other options.
- B. Incorrect.
Amazon DynamoDB with on-demand capacity mode can handle read and write-intensive workloads, but it is better suited for unpredictable and low-latency requirements. For highly read-intensive workloads, other solutions like Aurora with read replicas or ElastiCache may be more cost-effective and performant.
- C. Correct.
Amazon Aurora with read replicas is highly suitable for read-intensive workloads. Aurora allows for automatic scaling and supports up to 15 read replicas, making it cost-effective and performant for such use cases.
- D. Incorrect.
Amazon ElastiCache for Redis is highly optimized for caching and can improve read performance, but it is not a database solution. Since the application needs a primary database for writes and storage, this option alone is insufficient.