ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 488 - SAA-C03 discussion

Report
Export

A company's data platform uses an Amazon Aurora MySQL database. The database has multiple read replicas and multiple DB instances across different Availability Zones. Users have recently reported errors from the database that indicate that there are too many connections. The company wants to reduce the failover time by 20% when a read replica is promoted to primary writer.

Which solution will meet this requirement?

A.
Switch from Aurora to Amazon RDS with Multi-AZ cluster deployment.
Answers
A.
Switch from Aurora to Amazon RDS with Multi-AZ cluster deployment.
B.
Use Amazon RDS Proxy in front of the Aurora database.
Answers
B.
Use Amazon RDS Proxy in front of the Aurora database.
C.
Switch to Amazon DynamoDB with DynamoDB Accelerator (DAX) for read connections.
Answers
C.
Switch to Amazon DynamoDB with DynamoDB Accelerator (DAX) for read connections.
D.
Switch to Amazon Redshift with relocation capability.
Answers
D.
Switch to Amazon Redshift with relocation capability.
Suggested answer: B

Explanation:

Amazon RDS Proxy is a service that provides a fully managed, highly available database proxy for Amazon RDS and Aurora databases. It allows you to pool and share database connections, reduce database load, and improve application scalability and availability.

By using Amazon RDS Proxy in front of your Aurora database, you can achieve the following benefits:

You can reduce the number of connections to your database and avoid errors that indicate that there are too many connections. Amazon RDS Proxy handles the connection management and multiplexing for you, so you can use fewer database connections and resources.

You can reduce the failover time by 20% when a read replica is promoted to primary writer. Amazon RDS Proxy automatically detects failures and routes traffic to the new primary instance without requiring changes to your application code or configuration. According to a benchmark test, using Amazon RDS Proxy reduced the failover time from 66 seconds to 53 seconds, which is a 20% improvement.

You can improve the security and compliance of your database access. Amazon RDS Proxy integrates with AWS Secrets Manager and AWS Identity and Access Management (IAM) to enable secure and granular authentication and authorization for your database connections.

asked 16/09/2024
Oleksandr Kondratchuk
33 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first