Amazon SAA-C03 Exam - Topic 1 Question 48 Discussion

Actual exam question for Amazon's SAA-C03 exam

Question #: 48
Topic #: 1

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.

Show Suggested Answer

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.

by William at Sep 16, 2024, 08:45 AM

Limited Time Offer

25%

Off

Get Premium SAA-C03 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Bethanie

3 months ago

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

upvoted 0 times

...

Solange

3 months ago

A definitely meets the requirements, no doubt about it.

upvoted 0 times

...

Levi

3 months ago

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

upvoted 0 times

...

Maybelle

4 months ago

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

upvoted 0 times

...

Dominga

4 months ago

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

upvoted 0 times

...

Kyoko

4 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.

upvoted 0 times

...

Felicidad

4 months 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.

upvoted 0 times

...

Annamaria

4 months 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.

upvoted 0 times

...

Nathalie

5 months 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.

upvoted 0 times

...

Tawanna

5 months 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.

upvoted 0 times

...

Louvenia

5 months 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.

upvoted 0 times

...

Lelia

5 months 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.

upvoted 0 times

...

Percy

5 months 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.

upvoted 0 times

...

Jeanice

5 months 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.

upvoted 0 times

...

Carmen

5 months 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.

upvoted 0 times

...

Bok

1 year 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'.

upvoted 0 times

Zona

1 year ago

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

upvoted 0 times

...

Lillian

1 year ago

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.

upvoted 0 times

...

Bettyann

1 year 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'.

upvoted 0 times

...