SAP-C02 Question 317
Select 2A company is building a new application for a global e-commerce platform. The application requires a database that can handle highly consistent, low-latency transactions for order processing, while also needing a separate database to store and analyze large volumes of historical user activity data. Which combination of purpose-built databases is the most suitable for this use case?
- A
Amazon DynamoDB for order processing and Amazon Redshift for user activity analysis
- B
Amazon RDS using MySQL for order processing and Amazon Neptune for user activity analysis
- C
Amazon Aurora for order processing and Amazon Redshift for user activity analysis
- D
Amazon ElastiCache for order processing and Amazon Timestream for user activity analysis
- E
Amazon Keyspaces (for Apache Cassandra) for order processing and Amazon Neptune for user activity analysis
Show answer and explanation
Correct answers: A, C
Explanation
For this scenario, the application requires a purpose-built database for transactional order processing and another for analyzing historical user activity data. Amazon DynamoDB and Amazon Aurora are both suitable for transactional workloads, depending on whether the workload is NoSQL or SQL-based. For analyzing historical data, Amazon Redshift is the best choice as it is designed for large-scale data warehousing and analytics. Other options, such as Amazon Neptune, Timestream, and ElastiCache, are not appropriate for the specified requirements.
- A. Correct.
Amazon DynamoDB is a NoSQL database optimized for low-latency, highly consistent transactions, making it a good choice for order processing. Amazon Redshift is a data warehouse designed for large-scale analytics, making it appropriate for analyzing historical user activity data.
- B. Incorrect.
Amazon RDS with MySQL offers relational database capabilities for transactional workloads, but Amazon Neptune is a graph database and is not suitable for analyzing large-scale historical user activity data.
- C. Correct.
Amazon Aurora is a relational database that provides high availability and low-latency transactions, making it suitable for order processing. Amazon Redshift is well-suited for analyzing historical user activity data due to its data warehousing capabilities.
- D. Incorrect.
Amazon ElastiCache is designed for caching and is not suitable for transactional workloads like order processing. Amazon Timestream is optimized for time-series data and is not ideal for analyzing large-scale historical user activity data.
- E. Incorrect.
Amazon Keyspaces is a managed service for Apache Cassandra, which is useful for NoSQL workloads but is not optimal for transactional workloads requiring strong consistency. Additionally, Amazon Neptune is a graph database and is not appropriate for analyzing historical user activity data.