DEA-C01 Data Operations and Support Practice Question

• ✓ A.Enable automated backups with a 1-day retention period and point-in-time recovery.
• ✓ B.Enable Multi-AZ deployment.
• C.Enable automated backups with a 5-minute retention period.
• D.Create a cross-Region read replica.
• E.Use a single-AZ instance with a standby in another Region.

Why A: Options A and B are correct. Multi-AZ deployment (B) provides automatic failover to a standby in a different Availability Zone, meeting the RTO of less than 30 minutes. Automated backups with point-in-time recovery (A) allow recovery to any point within the retention period, enabling an RPO of less than 5 minutes. Option C is wrong because automated backups have a minimum retention of 1 day; you cannot set a 5-minute retention. Option D is wrong because a cross-Region read replica requires manual promotion and does not provide automatic failover, resulting in higher RTO. Option E is wrong because a single-AZ instance without Multi-AZ does not provide automatic failover, leading to RTO exceeding 30 minutes.

• ✓ A.Enable automated backups with a retention period of 7 days.
• ✓ B.Create a cross-region read replica to another AWS region.
• C.Configure the DB instance to be Single-AZ for simplicity.
• D.Export automated snapshots to an S3 bucket in a different region.
• ✓ E.Enable Multi-AZ deployment for automatic failover.

Why A: To achieve an RPO of 5 minutes and RTO of 15 minutes for an Amazon RDS for MySQL database with Multi-AZ deployment, the engineer should enable automated backups (A) for point-in-time recovery within minutes, create a cross-region read replica (B) for fast failover in another region, and enable Multi-AZ deployment (E) for automatic failover within the same region. Option C (Single-AZ) would not provide high availability, and option D (exporting snapshots to S3) is too slow for the required RTO.

• A.Take frequent manual snapshots and copy them to another Region.
• ✓ B.Enable automated backups with point-in-time recovery.
• ✓ C.Enable Multi-AZ deployment with a standby instance.
• D.Create a read replica in a different Availability Zone.
• E.Use cross-Region replication with Amazon Aurora Global Database.

Why B: Options B and C are correct. Multi-AZ deployment with a standby instance enables automatic failover, typically achieving an RTO of under 1-2 minutes. Combined with automated backups and point-in-time recovery, which allow database restoration to any point within seconds (RPO of less than 1 minute), the requirements are met. Option A is incorrect because manual snapshots are not frequent enough to guarantee RPO under 1 minute and restoring from a snapshot takes longer than 5 minutes. Option D is incorrect because a read replica in a different Availability Zone is not designed for automatic failover; it is for read scaling and requires manual promotion. Option E is incorrect because Amazon Aurora Global Database is a different service; this question is about Amazon RDS for PostgreSQL, and cross-Region replication for RDS does not provide automatic failover and typically has higher RTO.

• A.Enable Multi-AZ deployment in the same Region.
• B.Set up AWS Database Migration Service (DMS) for continuous replication.
• C.Take a manual snapshot and copy it to the other Region daily.
• ✓ D.Create a cross-Region read replica of the database.

Why D: Cross-Region read replica. Amazon RDS for MySQL supports cross-Region read replicas, which provide asynchronous replication to another Region. In a disaster, you can promote the read replica to a standalone primary database, minimizing data loss (typically seconds). Option A is wrong because Multi-AZ is within a single Region and does not provide cross-Region protection. Option B is wrong because AWS DMS is a separate service that requires ongoing management and cost; it is not the simplest approach. Option C is wrong because manual snapshots copied daily have a Recovery Point Objective (RPO) of up to 24 hours, resulting in significant data loss.