Good luck for the exams. I know I'm gonna fail coz it takes me 3 hours just to read the questions. >:(

if you got far it means you are persistent, good luck on your exam

option D provides the most cost-effective solution by leveraging Aurora backups with a 1-hour frequency and cross-Region replication to meet the disaster recovery requirements with the desired RPO.

RPO is a requirement and not RTO. They are talking about replicating the data in the Aurora database to another Region to meet disaster recovery requirements.

My head hurts after the reading the last 2 questions and 45 mins later, still confuse. I am looking at the key requirements, RPO <1h, meet DR requirements, and LOWEST Cost. After reading the link below and all of the comments, I think Option A fulfil all the requirements in the question. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database.html

Github copilot While AWS Database Migration Service (DMS) can be used to replicate ongoing changes from the Aurora database to an Amazon S3 bucket in another region using a change data capture (CDC) task, it's important to note that DMS does not create a standard SQL dump or backup file that can be directly restored to an Aurora database. The data migrated to S3 by DMS is in Apache Parquet format, a columnar storage file format optimized for speed and for a small footprint. This format is not directly restorable to an Aurora database. If you need to restore the data to an Aurora database, you would need to use a service like AWS Glue or Amazon Athena to read the data from S3 and then insert it into Aurora. This process could be complex and time-consuming, and might not meet your RPO of 1 hour.

Use AWS Database Migration Service (AWS DMS). Create a DMS change data capture (CDC) task that replicates the ongoing changes from the Aurora database to an Amazon S3 bucket in another Region. Is it possible to restore data from the S3 bucket to an Aurora Database?

D: the auto back can be disabled, see the link below: https://repost.aws/questions/QU1FrG5tQkQwi-yHbhT_EdvA/easily-turn-off-the-auto-backups-snapshots-for-rds

C is the least worst answer

not C because.. DMS is not cheap and moreover, DMS S3 Target support either .csv or parquet format.. good luck with restoring this data into a database from s3 this is not a Disaster Recovery this is purely "playing around with data in a Disaster situation"

As there is no RTO C is best and most cost-effective.

we assume that dms instance is deployed in a different region and somehow accesses the aurora instance, through the public endpoint or with vpc connection or any other way, and then replicates changes to the bucket in the same region it resides(different region for aurora)

I thought it has 304 questions, how come there is no more next page?

its can't be D You can't disable automated backups on Aurora. The backup retention period for Aurora is managed by the DB cluster. so answer is C

Although I also lean towards C, the problem is that I think the solution is not complete with only the CDC. We would also need a backup from which to recover the databases before applying the changes.

Before considering the cost, please consider the ability of solution. B. Backtrack feature is mainly use for solved incorrect data or configuration but don't clone to new DB, just roll-back to a PITR. C. How can create a S3 as a target for DMS in other regions? It must be the same region with DMS. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.S3.html#CHAP_Target.S3.Prerequisites D. Cannot turn off automatic backup of Aurora, the automatic backup range is 1 to 35 days. Disable require 0 day but don't have any option which is 0 day. So, the answer A is reasonable.

lean to C, but C doesn't backup the full data?