SAP-C02 Question 320
Select 1A company is designing a new e-commerce platform and has identified the need for a database solution that can handle the following requirements:
- High-speed, low-latency access to session data for users currently shopping on the platform.
- A scalable, distributed solution for storing and querying product catalog metadata with complex relationships (e.g., categories, brands, related products).
- A highly consistent and durable system for processing online orders and storing transactional data.
Which combination of AWS purpose-built database services should the company implement to meet these requirements?
- A
Amazon DynamoDB for session data, Amazon Neptune for product catalog metadata, Amazon RDS for transactional data
- B
Amazon ElastiCache for session data, Amazon DynamoDB for product catalog metadata, Amazon Aurora for transactional data
- C
Amazon ElastiCache for session data, Amazon Neptune for product catalog metadata, Amazon Aurora for transactional data
- D
Amazon DynamoDB for session data, Amazon Aurora for product catalog metadata, Amazon RDS for transactional data
- E
Amazon ElastiCache for session data, Amazon Neptune for product catalog metadata, Amazon Redshift for transactional data
Show answer and explanation
Correct answer: C
Explanation
AWS provides purpose-built databases to address specific application requirements. Amazon ElastiCache is ideal for low-latency, in-memory caching, making it a perfect choice for session data. Amazon Neptune is specifically designed for graph-based applications, such as managing a product catalog with hierarchical relationships. Amazon Aurora is a relational database that provides high consistency, scalability, and durability, making it suitable for transactional workloads like order processing. Combining these services ensures the e-commerce platform meets its diverse database requirements efficiently.
- A. Incorrect.
Amazon DynamoDB is not the most appropriate solution for session data because low-latency in-memory caching is better handled by Amazon ElastiCache. While Amazon Neptune is suitable for product catalog metadata with complex relationships, and Amazon RDS provides strong consistency for transactional data, this option has an incorrect choice for session data.
- B. Incorrect.
Although Amazon ElastiCache is suitable for session data and Amazon Aurora can handle transactional data effectively, Amazon DynamoDB is not an ideal choice for product catalog metadata that involves complex relationships. Amazon Neptune would be more appropriate for such use cases.
- C. Correct.
This is the correct answer. Amazon ElastiCache provides low-latency access to session data, Amazon Neptune is designed for storing and querying data with complex relationships (e.g., a product catalog), and Amazon Aurora is a highly consistent and scalable solution for transactional workloads such as order processing.
- D. Incorrect.
Amazon Aurora is not suitable for storing product catalog metadata involving complex relationships, as it is primarily a relational database solution. Amazon Neptune is a better fit for this requirement.
- E. Incorrect.
Amazon Redshift is not designed for transactional workloads; it is optimized for analytical querying and data warehousing. Hence, this option is not suitable for the transactional data requirement.