Exam AWS Certified Solutions Architect - Professional SAP-C02 topic 1 question 298 discussion

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

D is wrong. Aurora’s built-in automated backups are continuous but not customizable in frequency

I don't know but isn't the exam supposed to be about being a professional architect? What kind of professional architect would recommend C knowing that a 100 thing can go wrong in such a solution!

For those who are voting for D, here are a few simple facts: - You can’t disabled Aurora automated backup; - You can’t change Aurora backup frequency - it’s automated and point in time, you just need to define retention period which is the period for which you can perform a point-in-time recovery(1 day for free, max 35)

Between A and C, I choose A. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database-getting-started.html#aurora-global-database-attaching For C, note there's high volume of write daily. Can CDC to S3 bucket in another region keep up with 1 hour RPO? Although C has considered lowest cost for backup, does it consider the time taken to restore to full aurora database in the second region up and running?

Ask for 1 hour RPO, cheapest Aurora Global can do 1 second RPO, but expensive DMS with CDC can do 1-hour RPO and cheaper

Option A will replicate "the whole database", we only need "data"

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.