SAP-C02 Practice Question: Accelerate Workload Migration and Modernization
A healthcare company is migrating a legacy patient records system to AWS. The system uses an Oracle database with complex stored procedures and triggers. The company wants to move to Amazon Aurora PostgreSQL to reduce licensing costs. They need to convert the schema and code with minimal manual effort. Which AWS service should they use?
⚠ Common exam trap
Many candidates confuse data migration with schema conversion; AWS DMS moves data, but AWS SCT converts the schema and code.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
AWS Schema Conversion Tool (AWS SCT)
AWS Schema Conversion Tool is specifically built to convert database schemas and procedural code from one engine to another. It automates the conversion of Oracle PL/SQL to PostgreSQL PL/pgSQL, significantly reducing manual effort. While AWS DMS handles data migration, it does not convert schema objects, so SCT is the correct choice for this scenario.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
AWS Schema Conversion Tool (AWS SCT)
Why this is correct
AWS Schema Conversion Tool is designed to convert database schemas and code objects from one database engine to another, such as from Oracle to PostgreSQL. It automatically converts stored procedures, triggers, and views, and provides an assessment report highlighting items that require manual intervention. This directly reduces manual effort and accelerates the migration to Aurora PostgreSQL.
- ✗
AWS Database Migration Service (AWS DMS)
Why it's wrong here
AWS Database Migration Service is used to migrate data between databases, but it does not convert schema objects like stored procedures and triggers. While it can replicate data from Oracle to Aurora PostgreSQL, the schema and code objects must be converted separately. Using AWS DMS alone would leave the stored procedures and triggers unconverted, requiring significant manual effort, which the company wants to avoid.
- ✗
AWS DataSync
Why it's wrong here
AWS DataSync is a data transfer service for moving files between on-premises storage and AWS. It is not used for database schema or code conversion. It cannot handle Oracle stored procedures or triggers, and it is not designed for database migrations. Using DataSync here would not address the schema conversion requirement and would be entirely inappropriate for the task.
- ✗
AWS Application Migration Service (AWS MGN)
Why it's wrong here
AWS Application Migration Service is a lift-and-shift replication service for servers, not a database schema conversion tool. It replicates entire servers to AWS, including the operating system and applications, but does not convert database schemas or code. Using it would not help migrate to Aurora PostgreSQL; instead, it would replicate the Oracle database as-is, failing to meet the modernization goal.
Go deeper
Related to this question
About these practice questions
Courseiva writes every SAP-C02 question from scratch — 984 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Amazon Web Services exam blueprint
This SAP-C02 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SAP-C02 exam.