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 72 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Professional SAP-C02

Question #: 72
Topic #: 1

[All AWS Certified Solutions Architect - Professional SAP-C02 Questions]

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?

A. Create an Amazon Aurora MySQL Serverless v1 DB instance. Migrate the RDS DB instance to the Aurora Serverless v1 DB instance. Update the connection settings in the application to point to the Aurora reader endpoint.
B. Create an RDS proxy. Configure the existing RDS endpoint as a target. Update the connection settings in the application to point to the RDS proxy endpoint.
C. Create a two-node Amazon Aurora MySQL DB cluster. Migrate the RDS DB instance to the Aurora DB cluster. Create an RDS proxy. Configure the existing RDS endpoint as a target. Update the connection settings in the application to point to the RDS proxy endpoint.
D. Create an Amazon S3 bucket. Export the database to Amazon S3 by using AWS Database Migration Service (AWS DMS). Configure Amazon Athena to use the S3 bucket as a data store. Install the latest Open Database Connectivity (ODBC) driver for the application. Update the connection settings in the application to point to the Athena endpoint

Show Suggested Answer

Suggested Answer: B 🗳️

by masetromain at Jan. 14, 2023, 5:16 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

God_Is_Love

Highly Voted 2 years, 5 months ago

Selected Answer: B

Amazon RDS Proxy is a fully managed database proxy service for Amazon Relational Database Service (RDS) that makes applications more scalable, resilient, and secure. It allows applications to pool and share connections to an RDS database, which can help reduce database connection overhead, improve scalability, and provide automatic failover and high availability.

upvoted 10 times

...

zhangyu20000

Highly Voted 2 years, 7 months ago

B is correct. C: Aurora is useless, Proxy is pointing to existing RDS

upvoted 7 times

...

princajen

Most Recent 1 month ago

Selected Answer: B

To ensure application connections automatically re-establish after an Amazon RDS Multi-AZ failover without requiring an app restart, use Amazon RDS Proxy. It manages and maintains connections to the database, handling transient interruptions like failovers gracefully.

upvoted 1 times

...

amministrazione

11 months, 3 weeks ago

B. Create an RDS proxy. Configure the existing RDS endpoint as a target. Update the connection settings in the application to point to the RDS proxy endpoint.

upvoted 1 times

...

pangchn

1 year, 4 months ago

Selected Answer: B

C is wrong since RDS proxy for Aurora cluster only support reader endpoint, where in question it doesn't mention the read-only as requirement

upvoted 1 times

...

ninomfr64

1 year, 7 months ago

Selected Answer: B

A = using Aurora MySQL Serverless will not fix the issue, also serverless V1 is not great with HA. If you are running a single instance (no read replicas) it will attempt to create a new DB Instance in the same AZ B = correct (RDS Proxy in addition to pooling connections, makes applications more resilient to database failures by automatically connecting to a standby DB instance while preserving application connections and detects failover and routes requests to standby instance up to 66% faster failover time) C = Creating and migrating to Aurora cluster is not needed, RDS Proxy is enough D = this requires a lot of work

upvoted 5 times

...

NikkyDicky

2 years, 1 month ago

Selected Answer: B

it's a B

upvoted 1 times

...

SkyZeroZx

2 years, 2 months ago

Selected Answer: B

keyword = RDS proxy

upvoted 1 times

...

mfsec

2 years, 4 months ago

Selected Answer: B

Create an RDS proxy.

upvoted 1 times

...

klog

2 years, 6 months ago

Selected Answer: B

proxy will be a buffer

upvoted 1 times

...

masetromain

2 years, 7 months ago

Selected Answer: B

The correct solution is B. Create an RDS proxy. Configure the existing RDS endpoint as a target. Update the connection settings in the application to point to the RDS proxy endpoint. An RDS proxy is a service that allows you to pool and share connections to an RDS database. By using an RDS proxy, your application can automatically reconnect to the database after a failover event, without the need to restart the application. Solution A, migrating to Aurora Serverless, may not solve the problem because Aurora Serverless does not support Multi-AZ. Solution C and D are not the correct solutions because it does not solve the problem of reconnecting to the database after a failover event.

upvoted 4 times