How should a database specialist recover the database to the most recent point before corruption?
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.
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.
Restore using the latest automated backup. Change the application connection string to the new, restored DB instance.
Restore using the appropriate automated backup. No changes to the application connection string are required.
Explanations:
Point-in-time restore requires changing the application connection string to the restored DB instance.
Point-in-time restore is the correct way to recover to a specific time before corruption. The application connection string must be updated to reflect the new DB instance.
Restoring from the latest automated backup does not allow for precise recovery to a point in time before the corruption. It will restore to the most recent backup, which may include corruption.
Restoring using an automated backup does not provide the ability to restore to a specific time before the corruption, which is required in this scenario.
As far as I can tell, the answer is:
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.