Answer-first summary for fast verification
Answer: 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.
Amazon Aurora supports Point-In-Time Recovery (PITR), which allows you to restore your database to any specific second during the retention period. When you perform a PITR, Amazon Aurora always restores the data to a newly created DB cluster rather than modifying the existing one. Because a new cluster is created, it will have a new endpoint, and the application must be updated to use this new endpoint. Note: Aurora Backtrack is only supported for Aurora MySQL, not Aurora PostgreSQL.
Author: Ritesh Yadav
Ultimate access to all questions.
Question #55
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?
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.
No comments yet.