SAA-C03 Question 276
Single answerA company is building a high-traffic e-commerce platform and needs to choose a high-performing database solution for their product catalog. The catalog consists of a highly structured dataset with millions of rows, requires fast queries for product searches, and must support complex joins and aggregations. Which database solution should the company choose?
- A
Amazon RDS for MySQL
- B
Amazon DynamoDB
- C
Amazon Neptune
- D
Amazon Redshift
Show answer and explanation
Correct answer: A
Explanation
The key requirements of the scenario include handling structured data, performing fast queries, and supporting complex joins and aggregations. These characteristics align with the capabilities of relational databases like Amazon RDS for MySQL. Other options, such as DynamoDB, Neptune, and Redshift, are designed for specific use cases like NoSQL workloads, graph data, or analytical processing, making them less suitable for this scenario.
- A. Correct.
Amazon RDS for MySQL is a relational database solution well-suited for structured data, supporting complex joins and aggregations. It is a high-performing option for transactional workloads like an e-commerce product catalog.
- B. Incorrect.
Amazon DynamoDB is a NoSQL database designed for high scalability and performance but is not ideal for use cases requiring complex joins and aggregations, which are better supported by relational databases.
- C. Incorrect.
Amazon Neptune is a graph database designed for applications like social networks or recommendation engines. It is not suitable for structured data requiring relational operations like joins and aggregations.
- D. Incorrect.
Amazon Redshift is a data warehousing solution optimized for analytical workloads rather than transactional workloads like an e-commerce product catalog.