DVA-C02 Question 75
Select 2A development team is building an e-commerce application on AWS. The application requires a database to manage user profiles, product catalog details, and order transactions. The user profiles and product catalog details rarely change, but the order transactions require low-latency writes and frequent updates. The team needs a cost-effective solution that supports these requirements. Which combination of databases should the team use?
- A
Amazon RDS for user profiles and product catalog, Amazon DynamoDB for order transactions
- B
Amazon DynamoDB for user profiles and product catalog, Amazon RDS for order transactions
- C
Amazon Aurora for user profiles and product catalog, Amazon DynamoDB for order transactions
- D
Amazon ElastiCache for user profiles and product catalog, Amazon DynamoDB for order transactions
- E
Amazon DynamoDB for all data (user profiles, product catalog, and order transactions)
Show answer and explanation
Correct answers: A, C
Explanation
The use of a combination of databases aligns with the strengths of relational and non-relational databases. Amazon RDS or Aurora is well-suited for user profiles and product catalog due to their relational data structure and support for complex queries. Amazon DynamoDB excels in handling low-latency writes and frequent updates, making it ideal for the order transactions. Choosing the right database for each use case ensures cost-effectiveness and performance optimization.
- A. Correct.
Amazon RDS is a relational database suitable for structured data like user profiles and product catalog, which rarely change. Amazon DynamoDB is suited for low-latency writes and frequent updates, making it a good fit for order transactions.
- B. Incorrect.
Amazon DynamoDB is not ideal for user profiles and product catalog since these datasets are better suited to a relational database like RDS, which supports complex queries and relationships.
- C. Correct.
Amazon Aurora (a relational database) is suitable for user profiles and product catalog due to its scalability and support for structured data. Amazon DynamoDB is optimal for order transactions requiring low-latency writes.
- D. Incorrect.
Amazon ElastiCache is designed for in-memory caching rather than long-term storage of structured or semi-structured data, making it a poor fit for user profiles or product catalog. However, Amazon DynamoDB is still a good choice for order transactions.
- E. Incorrect.
While Amazon DynamoDB can handle all datasets, it is not cost-effective or optimal for user profiles and product catalog, which benefit from relational databases for query complexity and data relationships.