Exam AWS Certified Solutions Architect - Associate SAA-C03 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C03 exam

Exam AWS Certified Solutions Architect - Associate SAA-C03 topic 1 question 526 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C03

Question #: 526
Topic #: 1

[All AWS Certified Solutions Architect - Associate SAA-C03 Questions]

A solutions architect is reviewing the resilience of an application. The solutions architect notices that a database administrator recently failed over the application's Amazon Aurora PostgreSQL database writer instance as part of a scaling exercise. The failover resulted in 3 minutes of downtime for the application.

Which solution will reduce the downtime for scaling exercises with the LEAST operational overhead?

A. Create more Aurora PostgreSQL read replicas in the cluster to handle the load during failover.
B. Set up a secondary Aurora PostgreSQL cluster in the same AWS Region. During failover, update the application to use the secondary cluster's writer endpoint.
C. Create an Amazon ElastiCache for Memcached cluster to handle the load during failover.
D. Set up an Amazon RDS proxy for the database. Update the application to use the proxy endpoint.

Show Suggested Answer

Suggested Answer: D 🗳️

by AshishRocks at June 6, 2023, 9:15 a.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

alexandercamachop

Highly Voted 2 years, 2 months ago

Selected Answer: D

D is the correct answer. It is talking about the write database. Not reader. Amazon RDS proxy allows you to automatically route write request to the healthy writer, minimizing downtime.

upvoted 12 times

nilandd44gg

2 years ago

One of the benefits of Amazon RDS Proxy is that it can improve application recovery time after database failovers. While RDS Proxy supports both MySQL as well as PostgreSQL engines, in this post, we will use a MySQL test workload to demonstrate how RDS Proxy reduces client recovery time after failover by up to 79% for Amazon Aurora MySQL and by up to 32% for Amazon RDS for MySQL. https://aws.amazon.com/blogs/database/improving-application-availability-with-amazon-rds-proxy/ https://aws.amazon.com/rds/proxy/faqs/

upvoted 6 times

...

bora4motion

Most Recent 3 months, 2 weeks ago

Selected Answer: D

I'm going with D. It will reduce the failover time between DBs.

upvoted 1 times

...

ugaga

1 year, 2 months ago

AWS EXAM is also an AWS promotion... RDS Proxy really does not reduce recovery time if you don't have alternative RDS instance. You will see if you understand what proxy is. But this is exam (= promotion) of AWS, D could be an answer, because some AWS document says so.

upvoted 2 times

...

pentium75

1 year, 7 months ago

Selected Answer: D

"RDS Proxy reduces client recovery time after failover by up to 79% for Amazon Aurora MySQL " https://aws.amazon.com/de/blogs/database/improving-application-availability-with-amazon-rds-proxy/

upvoted 4 times

...

ftaws

1 year, 8 months ago

Selected Answer: B

RDS Proxy is used for DB timeout not downtime. How to reduce downtime with RDS Proxy? There is no change downtime if we use RDS Proxy.

upvoted 3 times

pentium75

1 year, 7 months ago

"How to reduce downtime with RDS Proxy", by eliminating the need for the application to retrieve the new DNS record after the old one times out.

upvoted 4 times

MatAlves

11 months, 1 week ago

I would never have thought about DNS records in this question. Nice catch!

upvoted 2 times

...

pentium75

1 year, 7 months ago

"RDS Proxy reduces client recovery time after failover by up to 79% for Amazon Aurora MySQL " https://aws.amazon.com/de/blogs/database/improving-application-availability-with-amazon-rds-proxy/

upvoted 3 times

...

Cyberkayu

1 year, 8 months ago

Selected Answer: B

they are using Aurora, RDS proxy dont work here Answer B

upvoted 2 times

pentium75

1 year, 7 months ago

Wrong: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/rds-proxy.html

upvoted 2 times

...

pentium75

1 year, 7 months ago

"RDS Proxy reduces client recovery time after failover by up to 79% for Amazon Aurora MySQL " https://aws.amazon.com/de/blogs/database/improving-application-availability-with-amazon-rds-proxy/

upvoted 2 times

...

Guru4Cloud

1 year, 12 months ago

Selected Answer: D

D. Set up an Amazon RDS proxy for the database. Update the application to use the proxy endpoint.

upvoted 3 times

...

hachiri

2 years ago

point is Aurora Multi-Master Set up a secondary Aurora PostgreSQL cluster in the *same* AWS Region

upvoted 2 times

hachiri

2 years ago

I mean correct is B

upvoted 1 times

...

TariqKipkemei

2 years ago

Selected Answer: C

Availability is the main requirement here. Even if RDS proxy is used, it will still find the writer instance unavailable during the scaling exercise. Best option is to create an Amazon ElastiCache for Memcached cluster to handle the load during the scaling operation.

upvoted 1 times

pentium75

1 year, 7 months ago

"RDS Proxy reduces client recovery time after failover by up to 79% for Amazon Aurora MySQL " https://aws.amazon.com/de/blogs/database/improving-application-availability-with-amazon-rds-proxy/

upvoted 2 times

...