SAA-C03 Q634 · Database

Question

A company is developing an application using Amazon Aurora MySQL. The team will frequently make schema changes to test new features without affecting production. After testing, changes must be promoted to production with minimal downtime. Which solution meets these requirements?

Accepted Answer

**Option C: Aurora MySQL blue/green deployment** meets all requirements:

1. **Frequent schema changes without affecting production**: The blue/green deployment creates a complete **staging environment (green)** that is a copy of the production environment (blue). The green environment uses logical replication from the blue environment, so production remains unaffected while you make schema changes on the green side.

2. **Promote to production with minimal downtime**: The **switchover mechanism** built into Aurora blue/green deployments uses Amazon RDS to orchestrate the cutover. During switchover, RDS renames the DB cluster endpoints — the green environment takes over the blue environment's endpoint. This typically completes in **under a minute** of downtime, with built-in safeguards lik

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🔒 Security

🎯 Exam Tips