AWS Certified Solutions Architect Associate SAA-C03 Practice Question
Your application architecture requires the ability to handle an unpredictable write load on the database that might cause performance bottlenecks. To address this challenge while enabling the database to scale independently, which of the following should you implement?
Introduce Amazon Simple Queue Service (SQS) to buffer write operations to the database.
Provision additional Amazon EC2 instances to handle the increased database load.
Store the data directly in Amazon S3 to leverage its scalability.
Migrate the database to a larger instance size with more CPU and memory.
Using Amazon Simple Queue Service (Amazon SQS) introduces a message queue between the application and the database (queue-based load leveling). The application places each write request on the queue, and a consumer process dequeues and writes to the database at a controlled rate. This decouples traffic spikes from the database layer, buffers bursts, and lets the database scale or recover independently. Adding more EC2 instances or vertically scaling the database might provide temporary capacity but does not decouple the components or absorb sudden spikes. Amazon S3 is object storage and does not support low-latency, transactional writes required for a database workload.
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.
How does Amazon SQS buffer write operations to a database?
Open an interactive chat with Bash
What is queue-based load leveling, and why is it important?
Open an interactive chat with Bash
Why is Amazon SQS suitable for handling database performance bottlenecks instead of Amazon S3?