AWS Certified Solutions Architect – Professional (SAP-C02) — Question 490

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.)

Answer options

• A. Use Migration Evaluator Quick Insights to analyze the source databases and to identify the stored procedures that need to be migrated.
• B. Use AWS Application Migration Service to analyze the source databases and to identify the stored procedures that need to be migrated.
• C. Use the AWS Schema Conversion Tool (AWS SCT) to analyze the source databases for changes that are required
• D. Use AWS Database Migration Service (AWS DMS) to migrate the source databases to Amazon RDS.
• E. Use AWS DataSync to migrate the data from the source databases to Amazon RDS.

Correct answer: C, D

Explanation

AWS Schema Conversion Tool (AWS SCT) is designed to assess heterogeneous database migrations and convert database schemas and code like stored procedures before migration. AWS Database Migration Service (AWS DMS) is then used to securely and efficiently migrate the actual data from the on-premises databases to Amazon RDS. Other tools like Migration Evaluator, AWS Application Migration Service, and AWS DataSync are not designed for database schema assessment or database-level replication.