Exam AWS Certified Database - Specialty topic 1 question 80 discussion

Going with D for now https://aws.amazon.com/premiumsupport/knowledge-center/rds-required-maintenance/ To minimize downtime, modify the Amazon RDS DB instance to a Multi-AZ deployment. For Multi-AZ deployments, OS maintenance is applied to the secondary instance first, then the instance fails over, and then the primary instance is updated. The downtime is during failover. For more information, see Maintenance for Multi-AZ Deployments. https://aws.amazon.com/rds/faqs/ The availability benefits of Multi-AZ also extend to planned maintenance. For example, with automated backups, I/O activity is no longer suspended on your primary during your preferred backup window, since backups are taken from the standby. In the case of patching or DB instance class scaling, these operations occur first on the standby, prior to automatic fail over. As a result, your availability impact is limited to the time required for automatic failover to complete.

Ans: D https://aws.amazon.com/premiumsupport/knowledge-center/rds-required-maintenance/

A is a diverter. B + C are only for reading, that doesn't help a Production database to avoid downtime. D is documented to help reduce downtime during OS patch cycles. https://aws.amazon.com/premiumsupport/knowledge-center/rds-required-maintenance/

D. Enable an Amazon RDS for MySQL Multi-AZ configuration

For OS maintenance ("AWS operating system patches are applied "), OS maintenance is applied to the secondary instance first, then the instance fails over, and then the primary instance is updated. https://repost.aws/knowledge-center/rds-required-maintenance

https://repost.aws/knowledge-center/rds-required-maintenance

Obviously D is correct.

C is the answer if the workload is read-only. D is the answer to do the maintenance for R+W workload with reduced outage

D is correct: "Single-AZ deployments are unavailable for a few minutes. Multi-AZ deployments are unavailable for the time it takes the instance to failover (usually about 60 seconds) if the Availability Zone is affected by the maintenance. If only the secondary Availability Zone is affected, then there is no failover or downtime. " https://aws.amazon.com/premiumsupport/knowledge-center/rds-required-maintenance/

D for sure.

Ans: D

-Ans: D

A. Migrate the workloads from Amazon RDS for MySQL to Amazon DynamoDB DynamoDB is not appropriate to take over RDS workload. B. Enable cross-Region read replicas and direct read traffic to then when Amazon RDS is down What about writes ? why do you need cross-region when you can have read-replicas in same region C. Enable a read replicas and direct read traffic to it when Amazon RDS is down What about write workload ? D. Enable an Amazon RDS for MySQL Multi-AZ configuration Helps in reducing the outage required for the maintenance(just a failover) C is the answer if the workload is read-only. D is the answer to do the maintenance for R+W workload with reduced outage

Yes it is D

Ans is D

Answer is D

Yes D is correct