exam questions

Exam AWS Certified Solutions Architect - Professional SAP-C02 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Professional SAP-C02 exam

Exam AWS Certified Solutions Architect - Professional SAP-C02 topic 1 question 424 discussion

A company runs a software-as-a-service (SaaS) application on AWS. The application consists of AWS Lambda functions and an Amazon RDS for MySQL Multi-AZ database. During market events, the application has a much higher workload than normal. Users notice slow response times during the peak periods because of many database connections. The company needs to improve the scalable performance and availability of the database.

Which solution meets these requirements?

  • A. Create an Amazon CloudWatch alarm action that triggers a Lambda function to add an Amazon RDS for MySQL read replica when resource utilization hits a threshold.
  • B. Migrate the database to Amazon Aurora, and add a read replica. Add a database connection pool outside of the Lambda handler function.
  • C. Migrate the database to Amazon Aurora, and add a read replica. Use Amazon Route 53 weighted records.
  • D. Migrate the database to Amazon Aurora, and add an Aurora Replica. Configure Amazon RDS Proxy to manage database connection pools.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
kejam
Highly Voted 1 year, 2 months ago
Selected Answer: D
Answer D: https://aws.amazon.com/blogs/compute/using-amazon-rds-proxy-with-aws-lambda/ https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/rds-proxy.html
upvoted 6 times
...
AzureDP900
Most Recent 5 months, 3 weeks ago
Option D meets all the requirements: Migrate the database to Amazon Aurora: This provides a more scalable and available database solution. Add an Aurora Replica: This allows for read-heavy workloads to be offloaded from the primary instance, reducing the load on the primary instance and improving overall performance. Configure Amazon RDS Proxy to manage database connection pools: Amazon RDS Proxy is a dedicated proxy service that can manage connections to your database, allowing you to maintain multiple active connections without overwhelming the database. This helps improve scalability and availability.
upvoted 1 times
...
VerRi
1 year, 1 month ago
Selected Answer: D
Moving database connection settings outside of the Lambda handler function may allow Lambda to reuse the connection, but RDS Proxy is better.
upvoted 3 times
...
career360guru
1 year, 1 month ago
Selected Answer: D
Option D
upvoted 1 times
...
HunkyBunky
1 year, 2 months ago
Selected Answer: D
D is a correct answer
upvoted 2 times
...
alexis123456
1 year, 2 months ago
correct Answer is D
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago