SAA-C03 Question 513
Single answerA retail company needs to implement a database solution to handle their online store's transactional data. They require strong consistency for their financial transactions, complex querying capabilities, and support for foreign key constraints. Which AWS database service is the most suitable for their needs?
- A
Amazon Aurora
- B
Amazon DynamoDB
- C
Amazon Redshift
- D
Amazon ElastiCache
Show answer and explanation
Correct answer: A
Explanation
For a retail company's transactional data, a relational database is the best choice as it supports strong consistency, complex queries, and relational features like foreign key constraints. Amazon Aurora, as a relational database service, fulfills all these requirements, making it the most suitable solution in this scenario. DynamoDB, Redshift, and ElastiCache do not meet the stated requirements for handling transactional data with strong consistency and relational features.
- A. Correct.
Amazon Aurora is a relational database service that supports strong consistency, complex SQL queries, and features such as foreign key constraints, making it ideal for transactional applications like an online store.
- B. Incorrect.
Amazon DynamoDB is a non-relational (NoSQL) database that is designed for low-latency and high scalability but does not support features like foreign key constraints or complex SQL queries, making it unsuitable for this use case.
- C. Incorrect.
Amazon Redshift is a data warehousing solution optimized for analytical queries and not suitable for transactional workloads that require strong consistency and complex querying capabilities.
- D. Incorrect.
Amazon ElastiCache is an in-memory caching service designed to improve application performance by caching frequently accessed data. It is not a database solution for transactional workloads.