Your company is running a high-volume online e-commerce site. The main database is deployed in RDS MySQL configured with Multi-AZ and few read replicas. The main website runs on EC2 instances behind a load balancer, and the setup also includes a cluster of Redis to offload repeated queries from the main database. The backup window is set in the early morning when the traffic is usually very low. Due to the holiday season, the site is receiving a huge amount of traffic during the daytime. The development team has recently finished a critical feature and delivered it to the QA team for the final testing. The management has decided to perform the full-scale DR exercise around midnight before rolling out new features. The resources in one Availability Zone will be taken down during the test. Select the option which would restore the RDS database to the latest point.

Answer options:

A.Restore the database from the last automated snapshot onto the new database.
B.Restore the database by promoting the read-replica and modify the application to use the new DB instance as the database master.
C.Amazon RDS automatically switches to the standby replica in another Availability Zone.
D.Use the RDS Copy Database option to create a new database from an existing database.

Correct Answer: C
Option A is INCORRECT because restoring from the last automated snapshot will not be the latest data. As per the timeline mentioned, the backup window is around early morning, and the exercise time is around midnight. So the automated snapshot will be nearly a day old.
Option B is INCORRECT because it does not restore the database to the latest point.
Option C is CORRECT. Because as Multi-AZ is enabled, when the primary DB instance has an issue, it will automatically switch to the standby replica in another AZ.
Option D is INCORRECT because there is no Copy Database option available in the RDS.