nerdexam
Amazon

SAP-C02 · Question #764

A company needs to migrate its on-premises database fleet to Amazon RDS. The company is currently using a mixture of Microsoft SQL Server, MySQL, and Oracle databases. Some of the databases have…

The correct answer is C. Use the AWS Schema Conversion Tool (AWS SCT) to analyze the source databases for changes D. Use AWS Database Migration Service (AWS DMS) to migrate the source databases to Amazon. To migrate diverse on-premises databases to Amazon RDS, the AWS Schema Conversion Tool (SCT) should be used to analyze and convert custom schemas and stored procedures. Subsequently, AWS Database Migration Service (DMS) should be utilized to perform the actual data migration…

Submitted by klara.se· Mar 6, 2026Migrate Workloads and Modernize Solutions

Question

A company needs to migrate its on-premises database fleet to Amazon RDS. The company is currently using a mixture of Microsoft SQL Server, MySQL, and Oracle databases. Some of the databases have custom schemas and stored procedures. Which combination of steps should the company take for the migration? (Choose two.)

Options

  • AUse Migration Evaluator Quick Insights to analyze the source databases and to identify the stored
  • BUse AWS Application Migration Service to analyze the source databases and to identify the
  • CUse the AWS Schema Conversion Tool (AWS SCT) to analyze the source databases for changes
  • DUse AWS Database Migration Service (AWS DMS) to migrate the source databases to Amazon
  • EUse AWS DataSync to migrate the data from the source databases to Amazon RDS.

How the community answered

(16 responses)
  • A
    13% (2)
  • B
    6% (1)
  • C
    81% (13)

Why each option

To migrate diverse on-premises databases to Amazon RDS, the AWS Schema Conversion Tool (SCT) should be used to analyze and convert custom schemas and stored procedures. Subsequently, AWS Database Migration Service (DMS) should be utilized to perform the actual data migration with minimal downtime.

AUse Migration Evaluator Quick Insights to analyze the source databases and to identify the stored

Migration Evaluator Quick Insights focuses on TCO analysis for migration readiness, not on detailed schema analysis or conversion of stored procedures.

BUse AWS Application Migration Service to analyze the source databases and to identify the

AWS Application Migration Service (AWS AMS) is primarily a lift-and-shift migration tool for entire servers, not a specialized tool for converting database schemas or performing heterogeneous database migrations to Amazon RDS.

CUse the AWS Schema Conversion Tool (AWS SCT) to analyze the source databases for changesCorrect

The AWS Schema Conversion Tool (AWS SCT) is specifically designed to assess and convert existing database schemas, including stored procedures and functions, from one database engine to another, which is critical for migrating heterogeneous databases like SQL Server, MySQL, and Oracle to Amazon RDS.

DUse AWS Database Migration Service (AWS DMS) to migrate the source databases to AmazonCorrect

AWS Database Migration Service (AWS DMS) is a robust tool for migrating data from various source databases to Amazon RDS with minimal downtime, supporting both one-time migrations and continuous data replication.

EUse AWS DataSync to migrate the data from the source databases to Amazon RDS.

AWS DataSync is designed for large-scale, high-performance data transfer between network file systems (NFS, SMB) and AWS storage services, not for migrating relational databases.

Concept tested: Heterogeneous Database Migration, AWS SCT, AWS DMS

Source: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.html

Community Discussion

No community discussion yet for this question.

Full SAP-C02 Practice