AWS Certified CloudOps Engineer - Associate SOA-C03

By Amazon · Question Mode

QuestionQ34

Reliability and Business Continuity

A company operates an application on Amazon EC2 instances. The application stores and retrieves data from an Amazon Aurora PostgreSQL database. A developer accidentally drops a table in the database, causing application errors. Two hours later, a CloudOps engineer must recover the data and restore application functionality.

Which solution meets this requirement?

Explanation

Aurora PostgreSQL supports point-in-time recovery within its backup-retention period, but that recovery creates a new DB cluster rather than restoring the existing cluster in place. Restoring the cluster to a time before the table drop and reconfiguring the application to connect to the new cluster endpoint recovers the data and allows the application to operate again. Aurora Backtrack applies to Aurora MySQL-compatible edition, not Aurora PostgreSQL.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!