Examkin

Question

Difficulty: HardBackup and Restore Management

A SysOps Administrator is designing a disaster recovery and backup compliance strategy for a critical transaction application. The requirements dictate that the MySQL database must support point-in-time recovery (PITR) to any moment within the past 14 days, fail over automatically to a standby instance in another Availability Zone with zero administrative intervention during an outage, and copy daily backup exports to an Amazon S3 bucket that is replicated to a different AWS Region for long-term retention. How should the SysOps Administrator configure this environment to meet all requirements?

  1. Enable RDS automated backups with a 14-day retention period. Ensure the DB instance is configured as Multi-AZ. Export daily snapshots to an Amazon S3 bucket with versioning enabled, and configure S3 Cross-Region Replication (CRR) to a destination S3 bucket that also has versioning enabled.Answer
  2. B
    Enable RDS automated backups with a 14-day retention period. Configure a Read Replica in another Availability Zone for automated failover. Export daily snapshots to an Amazon S3 bucket, and set up S3 Cross-Region Replication (CRR) to a destination bucket without enabling versioning on the destination bucket.
  3. C
    Configure RDS Read Replicas in multiple Availability Zones to handle automatic failover. Enable automated backups with a 14-day retention period. Export snapshots to an S3 bucket, and set up S3 Cross-Region Replication (CRR) to a destination bucket that has versioning enabled, while the source bucket has versioning disabled.
  4. D
    Enable RDS automated backups with a 14-day retention period. Ensure the DB instance is configured as Multi-AZ. Export daily snapshots to an Amazon S3 bucket, and configure S3 Cross-Region Replication (CRR) to a destination bucket, while disabling versioning on both buckets to optimize storage costs.

Answer

Enable RDS automated backups with a 14-day retention period, configure the DB instance as Multi-AZ, and export daily snapshots to an S3 bucket with versioning enabled on both the source and destination buckets for Cross-Region Replication.
To support point-in-time recovery (PITR) for up to 14 days, RDS automated backups must be enabled with a retention period of at least 14 days. For automatic zero-intervention failover during an Availability Zone outage, the database must be configured as a Multi-AZ deployment. For S3 Cross-Region Replication (CRR) to function correctly, S3 versioning must be explicitly enabled on both the source S3 bucket and the destination S3 bucket in the target Region.

Step-by-Step Solution

1
Address the point-in-time recovery requirement.
Enable RDS automated backups with a retention period of at least 14 days.
Automated backups allow restoring a DB instance to any point in time within the retention period.
2
Address the high availability and zero-intervention failover requirement.
Configure the RDS DB instance as a Multi-AZ deployment.
Multi-AZ provides synchronous replication and automatic failover by updating DNS records to point to the standby replica, whereas Read Replicas require manual promotion.
3
Address the long-term offsite backup replication requirement.
Enable versioning on both the source S3 bucket and the destination S3 bucket in the target Region, then configure Cross-Region Replication (CRR).
S3 Cross-Region Replication strictly requires that versioning is enabled on both the source and destination buckets.

Key Concept

Synthesizing Amazon RDS Automated Backups for PITR, Multi-AZ for automated high availability failover, and the versioning prerequisites of Amazon S3 Cross-Region Replication.
Estimated Time:2m 0s
Rate this question

Topics

Backup and Restore Management

More questions from this topic