SAA-C03 Question 474
Single answerA company needs to design a cost-optimized database solution for their e-commerce application. The workload involves frequent read and write operations, with unpredictable traffic spikes during sales events. Data must be highly available and durable, and the company wants to minimize costs by selecting the most appropriate database service. Which solution is the most cost-effective and meets the requirements?
- A
Use Amazon RDS with Multi-AZ deployment and provisioned capacity.
- B
Use Amazon DynamoDB with on-demand capacity mode.
- C
Use Amazon Aurora Serverless v2 with read replicas.
- D
Use Amazon Redshift with reserved nodes.
Show answer and explanation
Correct answer: B
Explanation
For unpredictable traffic spikes with frequent read/write operations, Amazon DynamoDB with on-demand capacity mode is the most cost-effective solution. It provides automatic scaling that aligns with the e-commerce application's workload, ensuring no overprovisioning or underutilization. Additionally, DynamoDB's durability and high availability features meet the requirements for the application.
- A. Incorrect.
Amazon RDS with Multi-AZ deployment provides high availability and durability but may not be cost-effective for workloads with unpredictable traffic spikes because it relies on provisioned capacity, which can lead to underutilization or overprovisioning.
- B. Correct.
Amazon DynamoDB with on-demand capacity mode is cost-effective for workloads with unpredictable traffic spikes. It automatically scales up or down based on traffic and charges only for the read and write operations performed, meeting the requirements for both cost optimization and scalability.
- C. Incorrect.
Amazon Aurora Serverless v2 is a good choice for scalable and cost-efficient workloads, but it is better suited for infrequent or intermittent workloads, not for frequent read and write operations as required in this scenario.
- D. Incorrect.
Amazon Redshift is a data warehouse solution optimized for analytical queries, not transactional workloads. It is not suitable for frequent read and write operations typical of an e-commerce application.