SAA-C03 Q668 · Database

Question

A company is migrating its workloads to AWS. The company has sensitive and critical data in on-premises relational databases that run on SQL Server instances. The company wants to use the AWS Cloud to increase security and reduce operational overhead for the databases. Which solution will meet these requirements?

Accepted Answer

**Option B: Multi-AZ Amazon RDS for SQL Server with AWS KMS encryption** satisfies every requirement:

1. **SQL Server compatibility**: Amazon RDS natively supports SQL Server as a database engine. This is a direct, compatible migration path for on-premises SQL Server workloads — no schema redesign or application refactoring needed.

2. **Reduced operational overhead**: RDS is a **managed service**. AWS handles patching, backups, failover, hardware maintenance, and OS updates. Compared to self-managed EC2 instances or on-premises servers, this dramatically reduces operational burden.

3. **Increased security**: 
   - **AWS KMS managed key** provides encryption at rest with automatic key rotation and centralized key management.
   - RDS also supports encryption in transit via SSL/TLS.
   -

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🔒 Security

🎯 Exam Tips