SAP-C02 Question #281: Real Exam Question with Answer & Explanation

Question

An application is using an Amazon RDS for MySQL Multi-AZ DB instance in the us-east-1 Region. After a failover test, the application lost the connections to the database and could not re- establish the connections. After a restart of the application, the application re-established the connections. A solutions architect must implement a solution so that the application can re- establish connections to the database without requiring a restart. Which solution will meet these requirements?

Options

• ACreate an Amazon Aurora MySQL Serverless v1 DB instance. Migrate the RDS DB instance to
• BCreate an RDS proxy. Configure the existing RDS endpoint as a target. Update the connection
• CCreate a two-node Amazon Aurora MySQL DB cluster. Migrate the RDS DB instance to the
• DCreate an Amazon S3 bucket. Export the database to Amazon S3 by using AWS Database

Explanation

Creating an RDS Proxy and configuring the existing RDS endpoint as a target, and then updating the connection settings in the application to point to the RDS proxy endpoint will meet the requirement of the application being able to re-establish connections to the database without requiring a restart. Amazon RDS Proxy is a fully managed, highly available database proxy for Amazon RDS that makes applications more scalable, more resilient to database failures, and more secure. With RDS Proxy, applications can pool and share connections to RDS databases, reducing the number of connections each RDS instance needs to handle. This can improve the performance and scalability of the application. In the event of a failover or interruption, RDS Proxy automatically redirects connections to the new primary instance, so the application can continue to function without interruption. RDS Proxy also provides connection pooling, which reduces the number of connections to the primary RDS instance, so the primary instance can handle more traffic. Here is an example of how to set up an RDS proxy and configure it to work with an existing RDS instance: 1.Create an RDS proxy in the AWS Management Console, and configure it to use the existing RDS instance as a target. Update the connection settings in the application to use the RDS proxy endpoint instead of the RDS instance endpoint. https://aws.amazon.com/rds/proxy/ https://aws.amazon.com/blogs/database/using-amazon-rds-proxy-with-amazon-rds-for-mysql- and-amazon-aurora-mysql-to-improve-app-scalability-and-availability/

No community discussion yet for this question.