ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 469 - SAP-C02 discussion

Report
Export

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
Answers
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
Answers
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
Answers
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
Answers
D.
Migrate the database to Amazon Aurora and add an Aurora Replica Configure Amazon RDS Proxy to manage database connection pools
Suggested answer: D

Explanation:

Migrate to Amazon Aurora:

Amazon Aurora is a MySQL-compatible, high-performance database designed to provide higher throughput than standard MySQL. Migrating the database to Aurora will enhance the performance and scalability of the database, especially under heavy workloads.

Add Aurora Replica:

Aurora Replicas provide read scalability and improve availability. Adding an Aurora Replica allows read operations to be distributed, thereby reducing the load on the primary instance and improving response times during peak periods.

Configure Amazon RDS Proxy:

Amazon RDS Proxy acts as an intermediary between the application and the Aurora database, managing connection pools efficiently. RDS Proxy reduces the overhead of opening and closing database connections, thus maintaining fewer active connections to the database and handling surges in database connections from the Lambda functions more effectively.

This configuration reduces the database's resource usage and improves its ability to handle high volumes of concurrent connections.

Reference

AWS Database Blog on RDS Proxy (Amazon Web Services, Inc.).

AWS Compute Blog on Using RDS Proxy with Lambda (Amazon Web Services, Inc.).

asked 16/09/2024
Tomas Ojeda
41 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first