A company has launched an Amazon RDS for MySQL DB instance. Most of the connections to the database come from serverless applications. Application traffic to the database changes significantly at random intervals. At times of high demand, users report that their applications experience database connection rejection errors.Which solution will resolve this issue with the LEAST operational overhead?
Answer(s): A
R) A) RDS Proxy provides connection pooling and limits to handle sudden spikes from serverless apps, reducing connection churn and preventing connection rejection without changing application code. It offloads connection management from the database and pools connections to the DB instance.B) ElastiCache between apps and RDS is unnecessary for DB connection pooling and adds cache coherence complexity; it does not solve DB connection limits.C) Increasing instance class increases capacity but requires restart or downtime and more operational effort than proxy-based pooling; it may still face burst spikes.D) Multi-AZ improves availability, not connection scaling; switch-over logic adds complexity and does not address max concurrent connections.
A company recently deployed a new auditing system to centralize information about operating system versions, patching, and installed software for Amazon EC2 instances. A solutions architect must ensure all instances provisioned through EC2 Auto Scaling groups successfully send reports to the auditing system as soon as they are launched and terminated.Which solution achieves these goals MOST efficiently?
Answer(s): B
EC2 Auto Scaling lifecycle hooks provide events at launch and termination, allowing a custom script to run at both points and reliably send reports before instance transitions complete, ensuring timely auditing for all ASG-provisioned instances.A) Uses a scheduled Lambda and remote scripting; not guaranteed to catch every launch/termination promptly and adds complexity.C) User data runs only at launch, not at termination; cannot reliably execute on termination to report.D) Runs a script on the instance OS but lacks guaranteed execution for ASG lifecycle events and termination timing.B) Correct: lifecycle hooks ensure immediate, reliable execution during both launch and termination.
A company is developing a real-time multiplayer game that uses UDP for communications between the client and servers in an Auto Scaling group. Spikes in demand are anticipated during the day, so the game server platform must adapt accordingly. Developers want to store gamer scores and other non-relational data in a database solution that will scale without intervention.Which solution should a solutions architect recommend?
The correct answer is B.A) Route 53 handles DNS routing, not traffic distribution for real-time UDP games; it cannot provide server load balancing for the game tier. B) Network Load Balancer supports volatile UDP traffic and scales with Auto Scaling groups; DynamoDB on-demand provides scalable, non-relational storage with pay-per-request pricing and no capacity planning. C) Aurora Global Database is designed for RDBMS workloads and cross-region replication, not ideal for UDP game traffic or non-relational data; also adds complexity and cost. D) Application Load Balancer supports HTTP/HTTPS, not UDP, and DynamoDB global tables add cross-region replication but the mismatch with UDP and latency-sensitive game traffic makes it suboptimal.
A company hosts a frontend application that uses an Amazon API Gateway API backend that is integrated with AWS Lambda. When the API receives requests, the Lambda function loads many libraries. Then the Lambda function connects to an Amazon RDS database, processes the data, and returns the data to the frontend application. The company wants to ensure that response latency is as low as possible for all its users with the fewest number of changes to the company's operations.Which solution will meet these requirements?
Provisioned concurrency for the Lambda function (B) reduces cold-start latency and maintains steady, low latency for requests, especially when Lambda loads many libraries and connects to RDS. This minimizes startup delays without code changes.A is incorrect because bypassing API Gateway diverges from the architecture and introduces security and operational risks; it does not reduce Lambda cold starts or library load time, and still requires a frontend to reach the backend.C is incorrect since caching query results in S3 adds architectural complexity and may lead to stale data; S3 is not suitable as a low-latency, dynamic query cache for Lambda-RDS workloads.D is incorrect because simply resizing the database increases connections but does not address Lambda cold starts or per-request latency; it may also incur higher costs and complexity.
A company is migrating its on-premises workload to the AWS Cloud. The company already uses several Amazon EC2 instances and Amazon RDS DB instances. The company wants a solution that automatically starts and stops the EC2 instances and DB instances outside of business hours. The solution must minimize cost and infrastructure maintenance.Which solution will meet these requirements?
Answer(s): D
The correct approach uses serverless automation with scheduled invocation, minimizing maintenance and cost by avoiding running management infrastructure.A) Incorrect: Elastic resize and scaling DB instances to zero are not applicable or supported for RDS; RDS does not support zero-doc DB instances, and EC2 scaling is not a scheduled, fully managed solution.B) Incorrect: Relying on third-party Marketplace solutions introduces maintenance, licensing, and potential vendor risk; not as integrated or serverless as Lambda with EventBridge.C) Incorrect: Running a dedicated EC2 instance with cron scripts adds unmanaged infrastructure and ongoing maintenance.D) Correct: Lambda with EventBridge provides serverless, cost-efficient, scheduled start/stop across EC2 and RDS, with minimal maintenance.
Post your Comments and Discuss Amazon AWS-SOLUTION-ARCHITECT-ASSOCIATE exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the AWS-SOLUTION-ARCHITECT-ASSOCIATE content, but please register or login to continue.