AWS Certified Database – Specialty – Question184

A financial company is hosting its web application on AWS. The application's database is hosted on Amazon RDS for MySQL with automated backups enabled. The application has caused a logical corruption of the database, which is causing the application to become unresponsive. The specific time of the corruption has been identified, and it was within the backup retention period.
How should a database specialist recover the database to the most recent point before corruption?

A.
Use the point-in-time restore capability to restore the DB instance to the specified time. No changes to the application connection string are required.
B. Use the point-in-time restore capability to restore the DB instance to the specified time. Change the application connection string to the new, restored DB instance.
C. Restore using the latest automated backup. Change the application connection string to the new, restored DB instance.
D. Restore using the appropriate automated backup. No changes to the application connection string are required.

Correct Answer: A

Explanation: