A company needs to analyze audit logs stored in an RDS SQL Server database. They want to offload this analytical work from the production database. Which approach is most efficient for a SQL Server engine in RDS?

Direct Answer (Verified)Reviewed by Sunny (Senior Cloud Engineer)

Correct Answer: Use Read Replicas (if supported by the edition) or AWS DMS to sync to a separate instance

RDS for SQL Server supports read replicas for certain editions. Alternatively, DMS could be used for continuous replication to an analytical database....

📋Part of AWS Certified Solutions Architect – Associate (SAA-C03) · AWS Certification Practice
Real Exam ScenarioAmazon RDS

A company needs to analyze audit logs stored in an RDS SQL Server database. They want to offload this analytical work from the production database. Which approach is most efficient for a SQL Server engine in RDS?

✓ Correct Answer & ExplanationAmazon RDS

Correct Answer

Use Read Replicas (if supported by the edition) or AWS DMS to sync to a separate instance

Why This Answer Is Correct

RDS for SQL Server supports read replicas for certain editions. Alternatively, DMS could be used for continuous replication to an analytical database.

📚 What This Question Tests

This question evaluates your knowledge of Amazon RDS — a core concept tested in AWS Certified Solutions Architect – Associate (SAA-C03). Understanding Amazon RDS is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.