AWS Certified SysOps Administrator – Associate (SOA-C03) — Question 56

A company runs an application on Amazon EC2 instances. The application stores and retrieves data from an Amazon Aurora PostgreSQL database. A developer accidentally drops a table from the database, which causes application errors. Two hours later, a CloudOps engineer needs to recover the data and make the application function again.
Which solution will meet this requirement?

Answer options

• A. Use the Aurora Backtrack feature to rewind the database to a specified time, 2 hours in the past.
• B. Perform a point-in-time recovery on the existing database to restore the database to a specified point in time, 2 hours in the past.
• C. Perform a point-in-time recovery and create a new database to restore the database to a specified point in time, 2 hours in the past. Reconfigure the application to use a new database endpoint.
• D. Create a new Aurora cluster. Choose the Restore data from S3 bucket option. Choose log files up to the failure time 2 hours in the past.

Correct answer: C

Explanation

The correct answer is C because it allows for the creation of a new database with the restored data, ensuring the application can connect to a functioning database endpoint. While option A offers a rewind feature, it may not adequately address the deletion of the table. Options B and D do not provide the necessary steps to adjust the application to the newly restored data effectively.