AWS Certified Solutions Architect Associate SAA-C03 Practice Question
An architect must devise a solution that allows a fleet of ephemeral compute instances to efficiently open and maintain connections to a relational database during unpredictable traffic spikes. Which service should the architect employ to ensure scalable and resilient database connectivity?
You selected this option
Create additional read replicas to distribute the load across multiple instances.
You selected this option
Initiate a Multi-AZ deployment strategy for the database to ensure connectivity.
You selected this option
Increase the compute capacity of the database instance to handle more connections.
You selected this option
Deploy a fully managed database proxy service for connection pooling.
Using a fully managed database proxy service allows ephemeral compute instances, like AWS Lambda functions, to efficiently manage database connections. This service can absorb the variability in concurrent connections, smoothing out spikes in traffic and preserving backend database stability. It achieves this through connection pooling and multiplexing, which enhances application scalability and resilience without exhausting connections. While other options may improve availability (Multi-AZ) or read performance (Read Replica), they do not offer the specific benefits of a managed proxy service when it comes to connection pooling. Scaling the compute engine vertically would not directly solve the problem of efficiently managing a large number of connections and could lead to resource exhaustion under high traffic conditions.
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.
What is a database proxy service and how does it work?
Open an interactive chat with Bash
What is connection pooling and why is it important?
Open an interactive chat with Bash
What are the benefits of using a fully managed service compared to self-hosting a proxy?