Discuss Amazon SAA-C03 Exam Topic 1 Question 48

A company is migrating its on-premises Oracle database to an Amazon RDS for Oracle database. The company needs to retain data for 90 days to meet regulatory requirements. The company must also be able to restore the database to a specific point in time for up to 14 days.

Which solution will meet these requirements with the LEAST operational overhead?

ACreate Amazon RDS automated backups. Set the retention period to 90 days.

BCreate an Amazon RDS manual snapshot every day. Delete manual snapshots that are older than 90 days.

CUse the Amazon Aurora Clone feature for Oracle to create a point-in-time restore. Delete clones that are older than 90 days

DCreate a backup plan that has a retention period of 90 days by using AWS Backup for Amazon RDS.

Suggested Answer: D

AWS Backup is the most appropriate solution for managing backups with minimal operational overhead while meeting the regulatory requirement to retain data for 90 days and enabling point-in-time restore for up to 14 days.

AWS Backup: AWS Backup provides a centralized backup management solution that supports automated backup scheduling, retention management, and compliance reporting across AWS services, including Amazon RDS. By creating a backup plan, you can define a retention period (in this case, 90 days) and automate the backup process.

Point-in-Time Restore (PITR): Amazon RDS supports point-in-time restore for up to 35 days with automated backups. By using AWS Backup in conjunction with RDS, you ensure that your backup strategy meets the requirement for restoring data to a specific point in time within the last 14 days.

Why Not Other Options?:

Option A (RDS Automated Backups): While RDS automated backups support PITR, they do not directly support retention beyond 35 days without manual intervention.

Option B (Manual Snapshots): Manually creating and managing snapshots is operationally intensive and less automated compared to AWS Backup.

Option C (Aurora Clones): Aurora Clone is a feature specific to Amazon Aurora and is not applicable to Amazon RDS for Oracle.

AWS Reference:

AWS Backup - Overview of AWS Backup and its capabilities.

Amazon RDS Automated Backups - Information on how RDS automated backups work and their limitations.

Get Premium SAA-C03 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

36 comments · newest first

Bethanie 11 months ago

Wait, can we really restore to a specific point in time with just A?

Solange 11 months ago

A definitely meets the requirements, no doubt about it.

Levi 11 months ago

D sounds solid, but is it really the least overhead?

Maybelle 11 months ago

I think B is too much manual work. Why not automate?

Dominga 12 months ago

Option A is the easiest way to handle this. Automated backups are great!

Kyoko 12 months ago

Option D could be a good choice too, especially if it integrates well with AWS Backup. I just hope it meets the point-in-time restore requirement.

Felicidad 1 year ago

I’m a bit confused about option C. I know Aurora has some cool features, but I’m not sure if it applies to Oracle databases in RDS.

Annamaria 1 year ago

I remember practicing a similar question where manual snapshots were discussed. Option B seems like a lot of work since it requires daily management.

Nathalie 1 year ago

I think option A sounds right since it mentions automated backups, which should reduce operational overhead. But I'm not sure if 90 days is the max retention for RDS.

Tawanna 1 year ago

I feel pretty confident about this one. Based on the requirements, I think option A, creating automated backups with a 90-day retention period, is the way to go. It seems the most straightforward and low-maintenance approach to meet the needs.

Louvenia 1 year ago

This is a tricky one. I want to make sure I understand the differences between the backup options like automated backups, manual snapshots, and the Aurora Clone feature. I'll need to carefully read through the details of each to determine the most efficient and reliable solution.

Lelia 1 year ago

Okay, I think I've got a handle on this. The key is finding the solution that meets the 90-day data retention and 14-day point-in-time restore requirements with the least operational overhead. I'm leaning towards option A or D, as they seem the most automated and hands-off.

Percy 1 year ago

Hmm, I'm a bit unsure about this one. The question mentions some specific features like Amazon Aurora Clone and AWS Backup, which I'm not too familiar with. I'll need to review the details of each option to determine the best solution.

Jeanice 1 year ago

This looks like a straightforward question about backup and restore options for an Amazon RDS database. I'll need to carefully consider the requirements around data retention and point-in-time restore.

Carmen 1 year ago

I'm a bit unsure about this one. The question mentions "Vulnerability Response" but the options don't seem to directly match that. I'll have to think it through carefully.

Bok 2 years ago

Option C is my pick. The Aurora Clone feature sounds like a slick way to handle the point-in-time restore needs. Plus, it's got a nice ring to it - 'the Oracle Clone'.

Zona 2 years ago

↳ replying to Bok

I agree with you on Option C. The Aurora Clone feature does sound pretty cool and efficient for point-in-time restores.

Lillian 2 years ago

↳ replying to Bok

I think Option A might be easier to manage. Just set the retention period for 90 days and let the automated backups take care of it.

Bettyann 2 years ago

↳ replying to Bok

Option C is my pick. The Aurora Clone feature sounds like a slick way to handle the point-in-time restore needs. Plus, it's got a nice ring to it - 'the Oracle Clone'.

Sylvie 2 years ago

What, no option for a weekly trip to the RDS database to perform a handstand backup? I'm disappointed.

Aja 2 years ago

↳ replying to Sylvie

D) Create a backup plan that has a retention period of 90 days by using AWS Backup for Amazon RDS.

Jamey 2 years ago

↳ replying to Sylvie

C) Use the Amazon Aurora Clone feature for Oracle to create a point-in-time restore. Delete clones that are older than 90 days

Lea 2 years ago

↳ replying to Sylvie

B) Create an Amazon RDS manual snapshot every day. Delete manual snapshots that are older than 90 days.

Ryan 2 years ago

↳ replying to Sylvie

A) Create Amazon RDS automated backups. Set the retention period to 90 days.

Camellia 2 years ago

But with option D, you can use AWS Backup for Amazon RDS which simplifies the backup process and ensures data retention for 90 days.

Terry 2 years ago

I disagree, I believe option A is the most efficient solution.

Viola 2 years ago

I'm leaning towards Option D. AWS Backup seems like a solid choice for managing the 90-day retention and point-in-time restore requirements.

Glen 2 years ago

↳ replying to Viola

I think Option D is the way to go. It simplifies the process of retaining data and restoring to a specific point in time.

Stevie 2 years ago

↳ replying to Viola

I agree, Option D seems like the most straightforward solution for managing the database migration.

Jeff 2 years ago

↳ replying to Viola

Option D sounds like a good choice. AWS Backup can handle the retention and restore needs efficiently.

Bernardine 2 years ago

Option A all the way! Automated backups with a 90-day retention period? Sign me up! Minimal operational overhead is the name of the game.

Mayra 2 years ago

↳ replying to Bernardine

Definitely, it's the most efficient solution for meeting the requirements.

Blythe 2 years ago

↳ replying to Bernardine

I agree, having automated backups makes everything so much easier.

Angella 2 years ago

↳ replying to Bernardine

Angella is right, minimal operational overhead is key.

Emerson 2 years ago

↳ replying to Bernardine

Option A all the way! Automated backups with a 90-day retention period? Sign me up!

Camellia 2 years ago

I think option D is the best choice for this scenario.

Amazon SAA-C03 Exam - Topic 1 Question 48 Discussion