AWS Certified Solutions Architect - Associate

Get started today

Ultimate access to all questions.

Explanation:

Correct answer — B: Amazon Aurora

Aurora is a relational, ACID-compliant database (MySQL/PostgreSQL compatible) designed for high performance and availability. It supports up to 15 low-latency read replicas, making it ideal for read‑intensive applications that also require full ACID transactions (e.g., banking or order systems where consistency and many concurrent reads matter).

Why the others are wrong

A: Amazon DynamoDB — a highly scalable NoSQL store that now supports transactions, but it’s key‑value/document oriented and tuned for different access patterns; it’s not a traditional relational ACID database and has different transactional and query semantics.
C: Amazon Redshift — a data warehouse for analytics (OLAP), not meant for transactional (OLTP) ACID workloads.
D: AWS Glue — an ETL service, not a database.

Think critically: choose based on data model (relational vs. key‑value), consistency needs, latency, and read/write patterns.

Explanation:

Correct answer — B: Amazon Aurora

Aurora is a relational, ACID-compliant database (MySQL/PostgreSQL compatible) designed for high performance and availability. It supports up to 15 low-latency read replicas, making it ideal for read‑intensive applications that also require full ACID transactions (e.g., banking or order systems where consistency and many concurrent reads matter).

Why the others are wrong

A: Amazon DynamoDB — a highly scalable NoSQL store that now supports transactions, but it’s key‑value/document oriented and tuned for different access patterns; it’s not a traditional relational ACID database and has different transactional and query semantics.
C: Amazon Redshift — a data warehouse for analytics (OLAP), not meant for transactional (OLTP) ACID workloads.
D: AWS Glue — an ETL service, not a database.

Think critically: choose based on data model (relational vs. key‑value), consistency needs, latency, and read/write patterns.

Comments (1)

asd ewfasJan 30, 2026 2:04 PM

Which AWS database service is best suited for a read‑intensive workload that requires SQL/ACID transactions ?

Simulated

Last updated: January 31, 2026 at 11:46

Amazon DynamoDB

18.7%

Amazon Aurora

64.8%

Amazon Redshift

12.1%

AWS Glue

4.4%

Powered ByGPT 5.4 powered

I guess the question here is wrong. Which AWS database service is best suited for read-intensive workloads? -> Amazon DynamoDB is correct -> Amazon Aurora is correct The AI explains why DynamoDB is not correct: "The question’s reference explanation highlights “up to 15 read replicas,” which points to an RDS-style relational engine. DynamoDB does not use the same read-replica model (it scales via partitioning, global tables, and optional caching), so it’s not the answer the exam item expects." No, the question does not reference "up to 15 read replicas". If so Aurora is correct answer so the question seems to be missing the hint to 15 read replica. "Which AWS database service is best suited for read-intensive workloads?" Frustrating.

LeetQuiz .Jan 31, 2026 11:44 AM

Thanks for pointing out. You're right. Both Aurora and DynamoDB can be excellent for read-heavy workloads. Which one is "best" depends on the workload’s characteristics. To eliminate the ambiguity, we've updated the question that require requires SQL/ACID transactions. Thank you for your feedback. It really help us keep improving the quality of questions that shared with other.