Skip to Content

Amazon DOP-C02: Migrate On-Premises Databases to Amazon RDS

By: Author Alex Lim

Posted on

Categories Exam

Learn the steps to migrate on-premises Microsoft SQL Server, MySQL, and Oracle databases to Amazon RDS. Utilize AWS Schema Conversion Tool and Database Migration Service.

Table of Contents

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

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.

Answer

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.

Explanation

To migrate the company’s on-premises database fleet consisting of Microsoft SQL Server, MySQL, and Oracle databases to Amazon RDS, the recommended approach is:

  1. Use the AWS Schema Conversion Tool (AWS SCT) to analyze the source databases. AWS SCT will assess the databases and identify any required changes, such as differences in data types, unsupported features, or incompatible stored procedures. This tool helps in planning the migration by providing a detailed report of the necessary modifications.
  2. After analyzing and preparing the source databases with AWS SCT, use AWS Database Migration Service (AWS DMS) to perform the actual migration. AWS DMS supports various database engines, including Microsoft SQL Server, MySQL, and Oracle, and can handle the migration of data, schemas, and stored procedures. It enables a smooth transition from the on-premises databases to Amazon RDS instances.

AWS Application Migration Service (option B) is used for migrating applications, not databases. Migration Evaluator Quick Insights (option A) is not a valid AWS service. AWS DataSync (option E) is used for migrating data between on-premises storage and AWS storage services like Amazon S3 or Amazon EFS, but not for database migrations.

By combining AWS Schema Conversion Tool for analysis and AWS Database Migration Service for the actual migration, the company can effectively migrate its on-premises database fleet to Amazon RDS.

Amazon AWS Certified DevOps Engineer – Professional DOP-C02 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Amazon AWS Certified DevOps Engineer – Professional DOP-C02 exam and earn Amazon AWS Certified DevOps Engineer – Professional DOP-C02 certification.