Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Amazon Discussions

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 Hide 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

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
alexandercamachop
Highly Voted 1 year 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 10 times
nilandd44gg
11 months, 1 week 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 4 times
...
...
ugaga
Most Recent 2 weeks, 3 days 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 1 times
...
pentium75
6 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 1 times
...
ftaws
6 months, 2 weeks 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 2 times
pentium75
6 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 1 times
pentium75
6 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 1 times
...
...
...
Cyberkayu
6 months, 2 weeks ago
Selected Answer: B
they are using Aurora, RDS proxy dont work here Answer B
upvoted 2 times
pentium75
6 months ago
Wrong: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/rds-proxy.html
upvoted 1 times
...
pentium75
6 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 1 times
...
...
Guru4Cloud
10 months, 2 weeks ago
Selected Answer: D
D. Set up an Amazon RDS proxy for the database. Update the application to use the proxy endpoint.
upvoted 2 times
...
hachiri
10 months, 3 weeks ago
point is Aurora Multi-Master Set up a secondary Aurora PostgreSQL cluster in the *same* AWS Region
upvoted 2 times
hachiri
10 months, 3 weeks ago
I mean correct is B
upvoted 1 times
...
...
TariqKipkemei
11 months, 2 weeks 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
wizcloudifa
2 months ago
that will only account for the read operation part of it, we are concerned with the write operations here
upvoted 1 times
...
pentium75
6 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 1 times
...
pentium75
6 months ago
Failover is faster with RDS proxy
upvoted 1 times
...
...
AshishRocks
1 year, 1 month ago
Set up an Amazon RDS proxy for the database. Update the application to use the proxy endpoint. D is the answer
upvoted 3 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
ex Want to SAVE BIG on Certification Exam Prep?
close
ex Unlock All Exams with ExamTopics Pro 75% Off
  • arrow Choose From 1000+ Exams
  • arrow Access to 10 Exams per Month
  • arrow PDF Format Available
  • arrow Inline Discussions
  • arrow No Captcha/Robot Checks
Limited Time Offer
Ends in

Claim Offer Now
286 people claimed it in the last 6 hours