SAA-C03 Q579 · Database

Question

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?

Accepted Answer

This question has two distinct requirements:

**Requirement 1: Retain data for 90 days** (regulatory compliance)
**Requirement 2: Point-in-time restore (PITR) for up to 14 days**

**Why AWS Backup is the best answer:**

1. **90-day retention**: AWS Backup allows you to create backup plans with retention periods up to virtually unlimited days (including 90 days). It handles the lifecycle automatically — creating, managing, and deleting backups per the policy.

2. **Point-in-time restore**: When AWS Backup manages RDS backups, it leverages RDS's native continuous backup mechanism. AWS Backup supports **continuous backups for RDS**, which enables PITR. You can set the PITR window (up to 35 days) independently.

3. **Least operational overhead**: AWS Backup is a fully managed, centralized back

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🔒 Security

🎯 Exam Tips