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

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

Question #: 464
Topic #: 1

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

A company hosts an online shopping application that stores all orders in an Amazon RDS for PostgreSQL Single-AZ DB instance. Management wants to eliminate single points of failure and has asked a solutions architect to recommend an approach to minimize database downtime without requiring any changes to the application code.

Which solution meets these requirements?

A. Convert the existing database instance to a Multi-AZ deployment by modifying the database instance and specifying the Multi-AZ option.
B. Create a new RDS Multi-AZ deployment. Take a snapshot of the current RDS instance and restore the new Multi-AZ deployment with the snapshot.
C. Create a read-only replica of the PostgreSQL database in another Availability Zone. Use Amazon Route 53 weighted record sets to distribute requests across the databases.
D. Place the RDS for PostgreSQL database in an Amazon EC2 Auto Scaling group with a minimum group size of two. Use Amazon Route 53 weighted record sets to distribute requests across instances.

Show Suggested Answer

Suggested Answer: A 🗳️

by nosense at May 16, 2023, 8:10 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

Guru4Cloud

Highly Voted 1 year, 4 months ago

Selected Answer: A

A. Convert the existing database instance to a Multi-AZ deployment by modifying the database instance and specifying the Multi-AZ option

upvoted 6 times

...

TariqKipkemei

Highly Voted 1 year, 6 months ago

Selected Answer: A

Eliminate single points of failure = Multi-AZ deployment

upvoted 5 times

...

awsgeek75

Most Recent 11 months, 2 weeks ago

Selected Answer: A

A is correct but reason need to be clarified: https://aws.amazon.com/blogs/database/best-practices-for-converting-a-single-az-amazon-rds-instance-to-a-multi-az-instance/ The instance doesn't automatically convert to Multi-AZ immediately. By default it will convert at next maintenance window but you can convert it immediately. Compared to B this is much better. CD are too many changes overall so unsuitable.

upvoted 3 times

...

antropaws

1 year, 6 months ago

Selected Answer: A

A) https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.MultiAZSingleStandby.html#Concepts.MultiAZ.Migrating

upvoted 2 times

...

Abrar2022

1 year, 7 months ago

"minimize database downtime" so why create a new DB just modify the existing one so no time is wasted.

upvoted 5 times

...

cloudenthusiast

1 year, 7 months ago

Selected Answer: A

Compared to other solutions that involve creating new instances, restoring snapshots, or setting up replication manually, converting to a Multi-AZ deployment is a simpler and more streamlined approach with lower overhead. Overall, option A offers a cost-effective and efficient way to minimize database downtime without requiring significant changes or additional complexities.

upvoted 3 times

...