Examkin

Question

Difficulty: MediumBackup and Restore Management

A company hosts its critical production database on a single-node Amazon RDS for MySQL DB instance. A SysOps Administrator must configure a backup and recovery solution to satisfy the following requirements:
1. The database must automatically fail over to a standby instance in a different Availability Zone in the event of an infrastructure failure.
2. The administrator must be able to restore the database to any point in time within the last 14 days.
3. Daily database snapshots must be automatically copied to an Amazon S3 bucket in a different AWS Region for long-term compliance, utilizing S3 Cross-Region Replication (CRR) to keep the replication process continuous and automated.

Which combination of steps should the SysOps Administrator perform to meet these requirements?

  1. A
    Convert the RDS DB instance to a Multi-AZ deployment. Set the RDS automated backup retention period to 14 days. Configure S3 Cross-Region Replication (CRR) to copy the exported daily DB snapshots to the destination S3 bucket in the second Region without enabling versioning on either S3 bucket.
  2. B
    Create an RDS Read Replica in a different Availability Zone to serve as the automatic failover target. Set the RDS automated backup retention period to 14 days. Enable versioning on both the source and destination S3 buckets, and configure S3 Cross-Region Replication (CRR) for the daily DB snapshots exported to S3.
  3. Convert the RDS DB instance to a Multi-AZ deployment. Set the RDS automated backup retention period to 14 days. Enable versioning on both the source and destination S3 buckets, and configure S3 Cross-Region Replication (CRR) for the daily DB snapshots exported to S3.Answer
  4. D
    Convert the RDS DB instance to a Multi-AZ deployment. Set the RDS automated backup retention period to 14 days. Deploy a utility EC2 instance in a public subnet to manage snapshot exports to S3, but do not associate a route targeting the Internet Gateway (IGW) in the subnet's route table. Enable versioning on both the source and destination S3 buckets, and configure S3 Cross-Region Replication (CRR).

Answer

Convert the RDS DB instance to a Multi-AZ deployment. Set the RDS automated backup retention period to 14 days. Enable versioning on both the source and destination S3 buckets, and configure S3 Cross-Region Replication (CRR) for the daily DB snapshots exported to S3.
The correct configuration satisfies all three requirements: converting the RDS instance to Multi-AZ provides synchronous replication and automatic failover to a standby instance in a different Availability Zone; setting the automated backup retention period to 14 days enables point-in-time recovery (PITR) up to 14 days; and enabling versioning on both the source and destination S3 buckets is a mandatory prerequisite for configuring S3 Cross-Region Replication (CRR) to copy exported snapshots to another Region.

Step-by-Step Solution

1
Convert the RDS DB instance to a Multi-AZ deployment.
Enables synchronous replication to a standby instance in a different Availability Zone, offering automatic failover.
To satisfy the high availability and automatic failover requirement during infrastructure failures.
2
Set the RDS automated backup retention period to 14 days.
Allows the database to be restored to any point in time within the 14-day window.
To meet the point-in-time recovery (PITR) requirement.
3
Enable versioning on both the source and destination S3 buckets, and configure S3 Cross-Region Replication (CRR).
Allows daily database snapshots exported to S3 to be automatically replicated to a different AWS Region.
Versioning is a mandatory prerequisite for S3 CRR, which ensures compliance copies are maintained in a separate Region.

Key Concept

RDS automated backups retention and high availability combined with S3 Cross-Region Replication prerequisites.
Rate this question

Topics

Backup and Restore Management

More questions from this topic