An organization wants to migrate their legacy Oracle database to Amazon Aurora PostgreSQL. They want a tool that can automatically convert the schema and stored procedures. Which tool should they use?

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

Correct Answer: AWS Schema Conversion Tool (SCT)

SCT is designed for heterogenous migrations where the source and target database engines are different, helping with schema conversion and code refactoring....

📋Part of AWS Certified Solutions Architect – Professional (SAP-C02) · AWS Certification Practice
Real Exam ScenarioAmazon RDS

An organization wants to migrate their legacy Oracle database to Amazon Aurora PostgreSQL. They want a tool that can automatically convert the schema and stored procedures. Which tool should they use?

✓ Correct Answer & ExplanationAmazon RDS

Correct Answer

AWS Schema Conversion Tool (SCT)

Why This Answer Is Correct

SCT is designed for heterogenous migrations where the source and target database engines are different, helping with schema conversion and code refactoring.

📚 What This Question Tests

This question evaluates your knowledge of Amazon RDS — a core concept tested in AWS Certified Solutions Architect – Professional (SAP-C02). 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.