nerdexam
Amazon

SOA-C03 · Question #129

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, wh

Sign in or unlock SOA-C03 to reveal the answer and full explanation for question #129. The question stem and answer options stay visible for context.

Submitted by katya_ua· Mar 5, 2026Reliability and business continuity

Question

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?

Options

  • 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
  • CPerform a point-in-time recovery and create a new database to restore the database to a
  • DCreate a new Aurora cluster. Choose the Restore data from S3 bucket option. Choose log files up

Unlock SOA-C03 to see the answer

You've previewed enough free SOA-C03 questions. Unlock SOA-C03 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Aurora point-in-time recovery#database restore#accidental deletion#PostgreSQL
Full SOA-C03 Practice