SAA-C03 Q441 · Database

Question

A solutions architect is designing a customer-facing application for a company. The application's database will have a clearly defined access pattern throughout the year and will have a variable number of reads and writes that depend on the time of year. The company must retain audit records for the database for 7 days. The recovery point objective (RPO) must be less than 5 hours. Which solution meets these requirements?

Accepted Answer

Let's map each requirement to the solution:

**1. Variable reads/writes depending on time of year → Aurora Auto Scaling**
Aurora Auto Scaling automatically adjusts the number of Aurora Replicas based on workload demand. This handles the variable read patterns. Aurora also supports serverless options for variable write workloads. Auto scaling is a native, managed feature that requires minimal operational overhead.

**2. Retain audit records for 7 days → Database Auditing Parameter**
Aurora MySQL supports Advanced Auditing via the `server_audit_*` parameters in the DB cluster parameter group. Audit logs can be published to Amazon CloudWatch Logs, where retention can be set to any period (including 7 days or more). This satisfies the audit record retention requirement natively.

**3. RPO < 5

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🔒 Security

🎯 Exam Tips