ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

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

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C03 exam
Go to 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 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 (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
alexandercamachop
Highly Voted 1 year, 6 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
1 year, 4 months 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
...
...
ugaga
Most Recent 6 months, 1 week 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
11 months, 3 weeks 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 3 times
...
ftaws
1 year 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
11 months, 3 weeks 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
3 months, 1 week ago
I would never have thought about DNS records in this question. Nice catch!
upvoted 2 times
...
pentium75
11 months, 3 weeks 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 ago
Selected Answer: B
they are using Aurora, RDS proxy dont work here Answer B
upvoted 2 times
pentium75
11 months, 3 weeks ago
Wrong: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/rds-proxy.html
upvoted 2 times
...
pentium75
11 months, 3 weeks 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, 4 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
1 year, 4 months ago
point is Aurora Multi-Master Set up a secondary Aurora PostgreSQL cluster in the *same* AWS Region
upvoted 2 times
hachiri
1 year, 4 months ago
I mean correct is B
upvoted 1 times
...
...
TariqKipkemei
1 year, 5 months 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
11 months, 3 weeks 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
...
wizcloudifa
7 months, 3 weeks ago
that will only account for the read operation part of it, we are concerned with the write operations here
upvoted 2 times
...
pentium75
11 months, 3 weeks ago
Failover is faster with RDS proxy
upvoted 2 times
...
...
AshishRocks
1 year, 6 months ago
Set up an Amazon RDS proxy for the database. Update the application to use the proxy endpoint. D is the answer
upvoted 4 times
...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago