SAP-C02 Practice Question: Accelerate Workload Migration and Modernization
A company is migrating an on-premises .NET application to AWS. The application uses a SQL Server database with a large number of stored procedures and triggers. The company wants to reduce licensing costs by moving to an open-source database. Which AWS service should the solutions architect use to automate the database conversion?
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 (SCT)
AWS Schema Conversion Tool (SCT) automates the conversion of database schema and code to a target database like PostgreSQL or MySQL. DMS handles data migration, not schema conversion. App2Container is for containerizing applications. CloudEndure is for server migration.
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 Database Migration Service (DMS)
Why it's wrong here
Incorrect: DMS migrates data, not schema/code conversion.
- ✗
AWS App2Container
Why it's wrong here
Incorrect: App2Container is for containerizing .NET applications, not database conversion.
- ✓
AWS Schema Conversion Tool (SCT)
Why this is correct
Correct: SCT automates schema and code conversion to target databases.
- ✗
AWS Application Migration Service (CloudEndure)
Why it's wrong here
Incorrect: CloudEndure is for server migration, not database conversion.
Go deeper
Related to this question
About these practice questions
One of 1,660 original SAP-C02 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
1 more way this is tested on SAP-C02
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A company is migrating a .NET application from Windows Server to AWS. The application uses Microsoft SQL Server. The company wants to reduce licensing costs and minimize operational overhead. Which migration strategy should be recommended?
medium- A.Replatform to Amazon RDS for SQL Server
- B.Refactor the application to .NET Core on Amazon Linux
- ✓ C.Replatform to Amazon RDS for PostgreSQL
- D.Rehost to Amazon EC2 with SQL Server on Windows
Why C: (Replatform to Amazon RDS for PostgreSQL) is the best choice because it replaces SQL Server with PostgreSQL, which is open-source, thus eliminating SQL Server licensing costs. RDS also reduces operational overhead by managing the database. Option A (Replatform to Amazon RDS for SQL Server) reduces overhead but still incurs SQL Server licensing costs. Option B (Refactor to .NET Core on Amazon Linux) would require significant application changes and does not directly address database licensing. Option D (Rehost to Amazon EC2 with SQL Server on Windows) maintains high licensing costs and operational overhead.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
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.