SAA-C03 Question 309
Single answerAn e-commerce company needs a database solution to handle product catalog data that includes hierarchical relationships (e.g., categories and subcategories), supports rapid scalability, and ensures low-latency access to frequently queried data. Which AWS database service would be the most appropriate for this use case?
- A
Amazon DynamoDB
- B
Amazon RDS for MySQL
- C
Amazon ElastiCache
- D
Amazon Redshift
Show answer and explanation
Correct answer: A
Explanation
The e-commerce product catalog requires a database that can handle hierarchical relationships, scale easily, and provide low-latency performance. Amazon DynamoDB is a non-relational database designed for such use cases, offering features like flexible schema design, high throughput, and serverless scalability. While RDS, ElastiCache, and Redshift are powerful tools, they are not optimized to meet the specific requirements of this scenario.
- A. Correct.
Amazon DynamoDB is a non-relational, serverless database that is highly scalable and designed for low-latency access, making it ideal for use cases involving hierarchical or unstructured data like product catalogs.
- B. Incorrect.
Amazon RDS for MySQL is a managed relational database service, which is well-suited for structured data and complex queries but may not be the best fit for hierarchical data or scenarios requiring high scalability and low latency.
- C. Incorrect.
Amazon ElastiCache is an in-memory data store used for caching and improving application performance. It is not designed to handle hierarchical data or serve as a primary database for product catalogs.
- D. Incorrect.
Amazon Redshift is a data warehousing solution optimized for analytical workloads and large-scale queries, not for operational or transactional workloads like a product catalog.