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…
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)- A13% (2)
- B6% (1)
- C81% (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.
Migration Evaluator Quick Insights focuses on TCO analysis for migration readiness, not on detailed schema analysis or conversion of stored procedures.
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.
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.
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.
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.