Exam AWS Certified Database - Specialty topic 1 question 338 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 338
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company has a web application that uses Amazon API Gateway to route HTTPS requests to AWS Lambda functions. The application uses an Amazon Aurora MySQL database for its data storage. The application has experienced unpredictable surges in traffic that overwhelm the database with too many connection requests. The company needs to implement a scalable solution that is more resilient to database failures as quickly as possible.

Which solution will meet these requirements MOST cost-effectively?

A. Migrate the Aurora MySQL database to Amazon Aurora Serverless by restoring a snapshot. Change the endpoint in the Lambda functions to use the new database.
B. Migrate the Aurora MySQL database to Amazon DynamoDB tables by using AWS Database Migration Service (AWS DMS). Change the endpoint in the Lambda functions to use the new database.
C. Create an Amazon EventBridge rule that invokes a Lambda function. Code the function to iterate over all existing connections and to call MySQL queries to end any connections in the sleep state.
D. Increase the instance class for the Aurora database with more memory. Set a larger value for the max_connections parameter.

Show Suggested Answer

Suggested Answer: D 🗳️

by narvaez at Nov. 23, 2023, 3:28 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

grekh001

1 year, 2 months ago

Answer is D Increase the maximum connections to your DB instance Increase the maximum number of connections to your DB instance using the following methods: Scale the instance up to a DB instance class with more memory. Note: Scaling the DB instance class causes an outage. Set a larger value for the max_connections parameter using a custom instance-level parameter group. Increasing the max_connections parameter doesn't cause an outage, but if your DB instance is using a default parameter group, then change the parameter group to a custom parameter group. Changing the parameter group causes an outage. For more information, see Working with DB parameter groups. https://repost.aws/knowledge-center/aurora-mysql-max-connection-errors

upvoted 1 times

...

tsangckl

1 year, 2 months ago

Selected Answer: A

Amazon Aurora Serverless is an on-demand, auto-scaling version of Amazon Aurora, where the database will automatically start up, shut down, and scale capacity up or down based on your application’s needs. It enables you to run your database in the cloud without managing any database instances. It’s a simple, cost-effective option for infrequent, intermittent, or unpredictable workloads. Given the unpredictable surges in traffic that overwhelm the database with too many connection requests, a serverless database would be able to handle the variability in demand more effectively. Additionally, Aurora Serverless is more resilient to database failures as it automatically scales compute capacity and can quickly recover from physical storage failures.

upvoted 1 times

...