DBS-C01 Question #347: Real Exam Question with Answer & Explanation

Question

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?

Options

• AMigrate the Aurora MySQL database to Amazon Aurora Serverless by restoring a snapshot.
• BMigrate the Aurora MySQL database to Amazon DynamoDB tables by using AWS Database
• CCreate an Amazon EventBridge rule that invokes a Lambda function. Code the function to iterate
• DIncrease the instance class for the Aurora database with more memory. Set a larger value for the

Explanation

To handle unpredictable traffic surges and database connection overloads for an Aurora MySQL database with API Gateway and Lambda, migrating to Aurora Serverless is the most cost-effective and scalable solution, offering automatic capacity scaling and resilience.

Common mistakes.

• B. Migrating from a relational Aurora MySQL database to a NoSQL Amazon DynamoDB table would involve significant schema redesign and application code changes for the Lambda functions, making it a complex and time-consuming solution, not "as quickly as possible" or "most cost-effectively" in terms of immediate implementation.
• C. Creating an Amazon EventBridge rule to invoke a Lambda function to iterate through and kill idle connections is a reactive and complex operational task that does not inherently prevent connection surges or provide proactive scaling for the database, and is not a scalable solution for the core problem.
• D. Increasing the instance class and max_connections for the existing Aurora database might temporarily alleviate some connection issues, but it's a fixed capacity solution that does not automatically scale with unpredictable surges and can lead to over-provisioning and higher costs during low traffic, making it less cost-effective than Serverless.

Concept tested. Aurora Serverless for variable workloads

Reference. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.how-it-works.html

No community discussion yet for this question.