New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Amazon SAA-C03 Exam - Topic 1 Question 48 Discussion

Actual exam question for Amazon's SAA-C03 exam
Question #: 48
Topic #: 1
[All SAA-C03 Questions]

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?

Show Suggested Answer Hide 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.


Contribute your Thoughts:

0/2000 characters
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
...
...
Sylvie
1 year ago
What, no option for a weekly trip to the RDS database to perform a handstand backup? I'm disappointed.
upvoted 0 times
Aja
1 year ago
D) Create a backup plan that has a retention period of 90 days by using AWS Backup for Amazon RDS.
upvoted 0 times
...
Jamey
1 year ago
C) Use the Amazon Aurora Clone feature for Oracle to create a point-in-time restore. Delete clones that are older than 90 days
upvoted 0 times
...
Lea
1 year ago
B) Create an Amazon RDS manual snapshot every day. Delete manual snapshots that are older than 90 days.
upvoted 0 times
...
Ryan
1 year ago
A) Create Amazon RDS automated backups. Set the retention period to 90 days.
upvoted 0 times
...
...
Camellia
1 year 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.
upvoted 0 times
...
Terry
1 year ago
I disagree, I believe option A is the most efficient solution.
upvoted 0 times
...
Viola
1 year 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.
upvoted 0 times
Glen
1 year ago
I think Option D is the way to go. It simplifies the process of retaining data and restoring to a specific point in time.
upvoted 0 times
...
Stevie
1 year ago
I agree, Option D seems like the most straightforward solution for managing the database migration.
upvoted 0 times
...
Jeff
1 year ago
Option D sounds like a good choice. AWS Backup can handle the retention and restore needs efficiently.
upvoted 0 times
...
...
Bernardine
1 year 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.
upvoted 0 times
Mayra
1 year ago
Definitely, it's the most efficient solution for meeting the requirements.
upvoted 0 times
...
Blythe
1 year ago
I agree, having automated backups makes everything so much easier.
upvoted 0 times
...
Angella
1 year ago
Angella is right, minimal operational overhead is key.
upvoted 0 times
...
Emerson
1 year ago
Option A all the way! Automated backups with a 90-day retention period? Sign me up!
upvoted 0 times
...
...
Camellia
1 year ago
I think option D is the best choice for this scenario.
upvoted 0 times
...

Save Cancel