Q62 — AWS SAA-C03 Ch.10

Question 62 of 100 | ← Chapter 10

Q662. 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?

Correct Answer: B. Use Amazon RDS Proxy in front of the Aurora database

Explanation

To meet the requirement of reducing failover time by 20% when a read replica is promoted to the primary writer in an Amazon Aurora MySQL database with multiple read replicas and DB instances across different Availability Zones, the solution that will meet this requirement is:B. Use Amazon RDS Proxy in front of the Aurora database.Here's the rationale behind this solution:Option B: Use Amazon RDS Proxy in front of the Aurora database Amazon RDS Proxy is a fully managed database proxy service provided by AWS. It helps improve scalability, connection management, and failover capabilities for applications accessing an RDS database. By using RDS Proxy with your Aurora MySQL database, you can reduce failover time when a read replica is promoted to the primary writer.RDS Proxy provides connection pooling, which allows for more efficient management of database connections. It can also help reduce connection errors by handling connection retries and server-side connection management. This can ultimately result in faster failover times when a replica is promoted to the primary writer.Option A: Switch from Aurora to Amazon RDS with Multi-AZ cluster deployment This option suggests switching from Aurora to Amazon RDS with Multi-AZ deployment. While Multi-AZ deployment provides high availability with synchronous replication and automatic failover, it does not specifically address the requirement of reducing failover time by 20% when a read replica is promoted to the primary writer.Option C: Switch to Amazon DynamoDB with DynamoDB Accelerator (DAX) for read connections Switching to Amazon DynamoDB with DynamoDB Accelerator (DAX) is not suitable for this scenario because DynamoDB is a NoSQL database service, while the current setup uses an Amazon Aurora MySQL database, which is a relational database.Option D: Switch to Amazon Redshift with relocation capability Amazon Redshift is a data warehousing service and is not designed to meet the requirements of reducing failover time for an Aurora MySQL database. It is not an appropriate solution for this scenario.Therefore, using Amazon RDS Proxy in front of the Aurora database (Option B) is the most suitable solution for reducing failover time when a read replica is promoted to the primary writer in the given scenario.