ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 806 - SAA-C03 discussion

Report
Export

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?

A.
Create Amazon RDS automated backups. Set the retention period to 90 days.
Answers
A.
Create Amazon RDS automated backups. Set the retention period to 90 days.
B.
Create an Amazon RDS manual snapshot every day. Delete manual snapshots that are older than 90 days.
Answers
B.
Create an Amazon RDS manual snapshot every day. Delete manual snapshots that are older than 90 days.
C.
Use the Amazon Aurora Clone feature for Oracle to create a point-in-time restore. Delete clones that are older than 90 days
Answers
C.
Use the Amazon Aurora Clone feature for Oracle to create a point-in-time restore. Delete clones that are older than 90 days
D.
Create a backup plan that has a retention period of 90 days by using AWS Backup for Amazon RDS.
Answers
D.
Create a backup plan that has a retention period of 90 days by using AWS Backup for Amazon RDS.
Suggested answer: D

Explanation:

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.

asked 16/09/2024
Nour Algharbi
42 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first