A company must migrate its on‑premises databases to Amazon RDS. The environment contains Microsoft SQL Server, MySQL, and Oracle databases, and some databases include custom schemas and stored procedures. Which combination of actions should the company take to perform the migration? (Choose two.)
Choose an answer
Tap an option to check your answer.
Correct answer: Use the AWS Schema Conversion Tool (AWS SCT) to analyze the source databases for schema and code changes that are required., Use AWS Database Migration Service (AWS DMS) to migrate the source databases to Amazon RDS..
Why this is the answer
The correct options are AWS SCT and AWS DMS. AWS Schema Conversion Tool (AWS SCT) is designed to convert existing database schemas and code objects, including stored procedures, from one database engine to another. This is crucial when migrating heterogeneous databases like SQL Server, MySQL, and Oracle to Amazon RDS, as it identifies and helps resolve compatibility issues. AWS Database Migration Service (AWS DMS) is used to migrate databases to AWS quickly and securely. It supports both homogeneous and heterogeneous migrations and can migrate data with minimal downtime. Migration Evaluator Quick Insights and AWS Application Migration Service are not designed for analyzing database schemas and stored procedures for migration compatibility. AWS DataSync is primarily used for large-scale data transfer between on-premises storage and AWS storage services, not for migrating relational databases to Amazon RDS.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed