DVA-C02 Question 74
Select 2You are developing an e-commerce application on AWS. The application needs to store product catalog information, which includes structured data such as product IDs, names, and prices, as well as customer reviews, which are unstructured and vary in length and format. The application also requires low-latency read access to the product catalog and the ability to scale elastically during high traffic events such as sales. Which combination of AWS database services would be the most appropriate to fulfill these requirements?
- A
Amazon RDS for storing the product catalog and DynamoDB for storing customer reviews
- B
Amazon DynamoDB for storing the product catalog and Amazon S3 for storing customer reviews
- C
Amazon Aurora for storing the product catalog and Amazon DynamoDB for storing customer reviews
- D
Amazon Redshift for storing the product catalog and Amazon S3 for storing customer reviews
- E
Amazon DynamoDB for both the product catalog and customer reviews
Show answer and explanation
Correct answers: A, C
Explanation
The correct choice involves using a relational database (Amazon RDS or Amazon Aurora) for the product catalog due to its structured nature and query requirements, and a NoSQL database (Amazon DynamoDB) for customer reviews because of its unstructured format and scalability needs. These combinations meet the key requirements of low-latency access, scalability, and handling both structured and unstructured data efficiently.
- A. Correct.
Amazon RDS is a relational database service suitable for structured data like the product catalog, and DynamoDB is a NoSQL database well-suited for unstructured data like customer reviews. This combination ensures scalability and low-latency access.
- B. Incorrect.
DynamoDB is excellent for low-latency and scalability, but using S3 for customer reviews might not be optimal as S3 is an object storage service and doesn't provide query capabilities for unstructured data.
- C. Correct.
Amazon Aurora is a high-performance relational database that works well for structured data like the product catalog, and DynamoDB is ideal for unstructured data like customer reviews. This combination is efficient for the described use case.
- D. Incorrect.
Amazon Redshift is a data warehouse designed for analytics, not for low-latency operational use cases like the product catalog. S3 is not a database, so it is not appropriate for storing customer reviews.
- E. Incorrect.
While DynamoDB can handle both structured and unstructured data, using it for the product catalog may not be ideal as relational databases like RDS or Aurora provide better query capabilities for this type of data.