SAA-C03 Question 275
Single answerA company is running an e-commerce platform that experiences unpredictable traffic spikes during flash sales. The database workload involves frequent read and write operations, and the company needs a highly scalable and high-performing solution to handle these spikes. Which of the following is the MOST appropriate database solution for this use case?
- A
Amazon RDS with Multi-AZ deployment
- B
Amazon Aurora with Auto Scaling
- C
Amazon DynamoDB with on-demand capacity mode
- D
Amazon Redshift
Show answer and explanation
Correct answer: C
Explanation
The e-commerce platform requires a database solution that can handle unpredictable traffic spikes and frequent read/write operations. Amazon DynamoDB with on-demand capacity mode is the most suitable choice as it provides instant scalability, high performance, and the ability to handle sudden traffic changes without pre-provisioned capacity. Other options like Amazon RDS and Aurora are effective for relational database workloads but require more planning for scalability. Amazon Redshift is designed for analytical workloads and is not suitable for transactional use cases.
- A. Incorrect.
Amazon RDS with Multi-AZ deployment is a good option for high availability, but it is not designed to handle unpredictable traffic spikes with the same level of scalability as DynamoDB.
- B. Incorrect.
Amazon Aurora with Auto Scaling is a highly performant relational database solution, but it may not be the best fit for workloads that require instant scalability to handle unpredictable spikes.
- C. Correct.
Amazon DynamoDB with on-demand capacity mode is the best choice for this scenario because it automatically scales to handle sudden spikes in traffic, ensuring high performance and availability without requiring capacity planning.
- D. Incorrect.
Amazon Redshift is optimized for analytical workloads and data warehousing, not for handling frequent read and write operations in a transactional e-commerce platform.