AWS Certified Solutions Architect Associate SAA-C03 Practice Question
A company is designing a new web application that will be read-heavy most of the year but faces brief, intense write spikes during seasonal events. The application must maintain consistently low-latency reads while accommodating these burst writes with little operational overhead. Which AWS database service and configuration best meets these requirements?
Use Amazon RDS for MySQL in a single-instance deployment without read replicas
Implement Amazon Redshift as the primary transactional database
Deploy the database on Amazon Aurora with multiple read replicas
Leverage Amazon DynamoDB with strongly consistent reads enabled for all requests
Amazon Aurora with multiple read replicas is designed for applications that need very high read throughput and low replica lag. Up to 15 Aurora Replicas share the cluster's distributed storage, so read traffic is off-loaded from the primary writer instance with single-digit-millisecond latency. Aurora's storage automatically grows in 10 GB increments up to 128 TiB, letting the cluster absorb sporadic but significant write surges without manual re-provisioning. By contrast, a single RDS MySQL instance lacks horizontal read scaling, DynamoDB with strongly consistent reads can handle the traffic but requires a non-relational data model and higher read-unit costs, and Amazon Redshift is optimized for analytical rather than transactional workloads.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
Why are read replicas important in Amazon Aurora?
Open an interactive chat with Bash
What is the difference between Amazon Aurora and Amazon RDS?
Open an interactive chat with Bash
What are the benefits of using Amazon Aurora for handling sporadic write loads?