
Answer-first summary for fast verification
Answer: Amazon Aurora
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.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which AWS database service is best suited for a read‑intensive workload that requires SQL/ACID transactions ?
A
Amazon DynamoDB
B
Amazon Aurora
C
Amazon Redshift
D
AWS Glue