SAA-C03 Question 516
Single answerA company is building an e-commerce application that requires high availability, low-latency reads and writes, and the ability to scale seamlessly as traffic increases. The application needs to store product catalog data, which includes details such as product IDs, names, descriptions, and inventory levels. Which AWS database service is the most suitable for this use case?
- A
Amazon RDS with MySQL
- B
Amazon Aurora
- C
Amazon DynamoDB
- D
Amazon Redshift
Show answer and explanation
Correct answer: C
Explanation
Amazon DynamoDB is the most suitable choice for this use case because it provides a fully managed NoSQL database solution that supports low-latency, high-throughput operations. This makes it ideal for storing product catalog data in an e-commerce application, where quick access and scalability are critical. Other options like Amazon RDS or Aurora are better suited for relational workloads, while Amazon Redshift is designed for analytics and not for real-time transactional use cases.
- A. Incorrect.
Amazon RDS with MySQL is a managed relational database service, which provides high availability and scalability for structured data. However, it is not optimal for low-latency, high-throughput workloads, especially for non-relational data like the product catalog.
- B. Incorrect.
Amazon Aurora is a relational database service designed for high availability and performance. While it is suitable for transactional workloads, it may not be as cost-effective or scalable as DynamoDB for a highly dynamic, non-relational use case like a product catalog.
- C. Correct.
Amazon DynamoDB is a fully managed NoSQL database service that is optimized for low-latency, high-throughput workloads. It is ideal for a use case like a product catalog, where data access patterns involve high-speed reads and writes, and horizontal scalability is required.
- D. Incorrect.
Amazon Redshift is a data warehouse service optimized for analytic queries and large-scale data processing. It is not suitable for transactional workloads or low-latency requirements like those in an e-commerce product catalog.