Home › AWS Solutions Architect Associate › cloudcomputing › highperformingarchitectures › An OLTP workload has a relational schema, needs …
An OLTP workload has a relational schema, needs single-digit-ms latency at the 99th percentile, and 100k+ writes/sec sustained. Which AWS database BEST fits?
AAmazon Glacier Instant Retrieval
BAmazon CloudWatch Logs
CAmazon S3 Standard with hand-written SQL parsers
DAmazon Aurora (MySQL- or PostgreSQL-compatible) with read replicas and Aurora's purpose-built storage
Answer & Solution
Correct answer: D. Amazon Aurora (MySQL- or PostgreSQL-compatible) with read replicas and Aurora's purpose-built storage
Aurora delivers MySQL/Postgres semantics with up to 5×/3× throughput on the underlying engines via its log-structured storage, replicas, and global database options. S3 isn't a transactional store; CloudWatch Logs isn't a DB; Glacier is archival.
Related questions
Which AWS service provides a managed, query-on-demand interface to analyse data already siWhich combination most efficiently runs spiky containerised workloads at the lowest operatWhich architecture pattern handles a sudden 10× write burst from millions of IoT devices wA workload needs millisecond reads at any scale on a key-value access pattern with predictWhich AWS service routes user traffic at the IP layer with anycast addressing and Region fWhich combination accelerates static content delivery to global users in front of an origiAn application's RDS for MySQL primary is CPU-bound under read traffic. Without changing tWhich compute option scales to zero between requests and bills per invocation millisecond,