Discuss Amazon SOA-C03 Exam Topic 4 Question 15

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?

AUse the Aurora Backtrack feature to rewind the database to a specified time, 2 hours in the past.

BPerform a point-in-time recovery on the existing database to restore the database to a specified point in time, 2 hours in the past.

CPerform 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.

DCreate 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.

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.

Get Premium SOA-C03 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

20 comments · newest first

Sana Ahmed 5 days ago

Pretty sure it is C because PITR creates a restored cluster with a new endpoint, not in place, and the app must point to it.

Devora 21 days ago

I agree, B is the best balance of speed and safety.

Belen 26 days ago

But C takes longer to set up. B is straightforward.

Karma 1 month ago

I’d go with C. New endpoint means no old issues.

Hobert 1 month ago

A is fast, but B gives more control.

Elly 1 month ago

I feel like B is the most reliable. Point-in-time is solid.

German 2 months ago

Option D sounds complicated. S3 recovery? Too much hassle.

William 2 months ago

I like option C. New database, less risk of issues.

Lura 2 months ago

Good point. Option B seems safer for recovery.

Kati 2 months ago

Yeah, but what if the backtrack feature isn't enabled?

Ashley 2 months ago

I think option A is the quickest way to fix this.

Golda 2 months ago

Wait, can you really rewind a database like that?

Svetlana 3 months ago

D sounds like overkill for just a dropped table.

Hubert 3 months ago

C seems complicated, why create a new database?

Portia 3 months ago

B) Point-in-time recovery is the way to go, no doubt.

Kanisha 3 months ago

A) Aurora Backtrack is super handy for this!

Bev 3 months ago

I vaguely remember something about restoring from S3, but I thought that was more for backups rather than immediate recovery.

Jamal 3 months 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.

Javier 4 months 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.

Mammie 4 months 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.

Amazon SOA-C03 Exam - Topic 4 Question 15 Discussion