SAA-C03 Q323 · Database

Question

A company needs to migrate its customer transactions database from on premises to AWS. The database is an Oracle DB instance on Linux. A new requirement mandates rotating the database password yearly. Which solution provides this capability with the least operational overhead?

Accepted Answer

Option B satisfies every requirement with minimal operational overhead:

1. **Database compatibility**: The source is Oracle DB. Amazon RDS for Oracle is a managed service that runs Oracle natively — no schema conversion or application rewrite needed. This is a straightforward like-for-like migration.

2. **Managed service = least operational overhead**: RDS handles patching, backups, high availability, and infrastructure management. Compared to EC2 (self-managed) or converting to a completely different database engine, RDS for Oracle is the lowest-effort migration path.

3. **Password rotation**: AWS Secrets Manager has **built-in, native integration with Amazon RDS** for automatic credential rotation. You simply:
   - Store the database password in Secrets Manager
   - Enable automatic r

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🔒 Security

🎯 Exam Tips