AWS Certified Database – Specialty — Question 143

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?

Answer options

• 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: B

Explanation

The correct answer is B because using the point-in-time restore capability allows for recovery to a specific moment before the corruption, ensuring minimal data loss. Changing the application connection string is necessary to connect to the newly restored DB instance. Options A, C, and D are incorrect as they either do not leverage point-in-time recovery effectively or neglect the need to update the connection string after restoration.