Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Amazon SOA-C03 Exam - Topic 4 Question 15 Discussion

A company runs an application on Amazon EC2 that connects to an Amazon Aurora PostgreSQL database. A developer accidentally drops a table from the database, causing application errors. Two hours later, a CloudOps engineer needs to recover the data and make the application functional again.Which solution will meet this requirement?
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.
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.
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.

Amazon SOA-C03 Exam - Topic 4 Question 15 Discussion

Actual exam question for Amazon's SOA-C03 exam
Question #: 15
Topic #: 4
[All SOA-C03 Questions]

A company runs an application on Amazon EC2 that connects to an Amazon Aurora PostgreSQL database. A developer accidentally drops a table from the database, causing application errors. Two hours later, a CloudOps engineer needs to recover the data and make the application functional again.

Which solution will meet this requirement?

Show Suggested Answer Hide Answer
Suggested Answer: C

In the AWS Cloud Operations and Aurora documentation, when data loss occurs due to human error such as dropped tables, Point-in-Time Recovery (PITR) is the recommended method for restoration. PITR creates a new Aurora cluster restored to a specific time before the failure.

The restored cluster has a new endpoint that must be reconfigured in the application to resume normal operations. AWS does not support performing PITR directly on an existing production database because that would overwrite current data.

Aurora Backtrack (Option A) applies only to Aurora MySQL, not PostgreSQL. Option B is incorrect because PITR cannot be executed in place. Option D refers to an import process from S3, which is unrelated to time-based recovery.

Hence, Option C is correct and follows the AWS CloudOps standard recovery pattern for PostgreSQL workloads.


Contribute your Thoughts:

0/2000 characters
Jamal
2 days ago
I feel like option C might be the safest choice, but I’m not confident about reconfiguring the application to point to a new database.
upvoted 0 times
...
Javier
7 days ago
I think point-in-time recovery is what we practiced in class, but I can't recall if it requires a new database or not.
upvoted 0 times
...
Mammie
12 days ago
I remember studying the Aurora Backtrack feature, but I’m not entirely sure if it can handle this situation since the table was dropped.
upvoted 0 times
...

Save Cancel