Examkin

Question

Difficulty: EasyBackup and Restore Management

A SysOps Administrator needs to restore an Amazon RDS DB instance to its state 30 minutes ago before a critical database table was accidentally deleted. Which action will successfully restore the database?

  1. A
    Promote a Read Replica to the primary role, as replicas maintain historical states for point-in-time recovery.
  2. B
    Trigger a Multi-AZ failover to automatically rollback the active primary database to the state prior to the deletion.
  3. Perform a point-in-time recovery (PITR), which launches a new DB instance with a new endpoint using automated backups and transaction logs.Answer
  4. D
    Replicate the database backup to another AWS Region using S3 Cross-Region Replication without enabling S3 versioning.

Answer

Perform a point-in-time recovery (PITR), which launches a new DB instance with a new endpoint using automated backups and transaction logs.
Point-in-time recovery (PITR) allows an administrator to restore a database to any point within its backup retention period. RDS implements this by launching a completely new DB instance and using transaction logs to roll forward the database to the specified minute before the deletion occurred.

Step-by-Step Solution

1
Determine the precise timestamp prior to the accidental deletion to use as the target recovery time.
The recovery target is set to 30 minutes ago.
This target avoids restoring the database to a point where the user error has already occurred.
2
Launch the Point-in-Time Recovery operation via the AWS Management Console, AWS CLI, or RDS API.
Amazon RDS begins provisioning a new DB instance.
RDS restores the database using the latest daily automated snapshot and applies transaction logs (write-ahead logs) up to the specified time.
3
Configure client applications to point to the new DB instance endpoint once the restoration completes.
Client connections are routed to the recovered database.
Point-in-time recovery always creates a new database instance with a new DNS endpoint to prevent accidental data overwrites on the active instance.

Key Concept

Point-in-Time Recovery (PITR) for Amazon RDS
Rate this question

Topics

Backup and Restore Management

More questions from this topic