AWS Schema Conversion Tool

Answer : D.

Option A is incorrect - AWS Database Migration Service (AWS DMS) is a cloud service that makes it easy to migrate relational databases, data warehouses, NoSQL databases, and other types of data stores.

You can use AWS DMS to migrate your data into the AWS Cloud, between on-premises instances (through an AWS Cloud setup), or between combinations of cloud and on-premises setups.

With AWS DMS, you can perform one-time migrations, and you can replicate ongoing changes to keep sources and targets in sync.

If you want to change database engines, you can use the AWS Schema Conversion Tool (AWS SCT) to translate your database schema to the new platform.

You then use AWS DMS to migrate the data.

Because AWS DMS is a part of the AWS Cloud, you get the cost efficiency, speed to market, security, and flexibility that AWS services offer.

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

Option B is incorrect -AWS DataSync is a data transfer service that simplifies, automates, and accelerates moving and replicating data between on-premises storage systems and AWS storage services over the internet or AWS Direct Connect.

As a fully managed service, DataSync removes the need to modify applications, develop scripts, or manage infrastructure.

DataSync currently supports data transfer between Network File System (NFS) and Amazon Elastic File System (Amazon EFS), or Amazon Simple Storage Service (Amazon S3)

https://docs.aws.amazon.com/datasync/latest/userguide/what-is-datasync.html

Option C is incorrect -AWS Migration Hub provides a single place to discover your existing servers, plan migrations, and track the status of each application migration.

The AWS Migration Hub provides visibility into your application portfolio and streamlines planning and tracking.

You can see the status of the servers and databases that make up each of the applications you are migrating regardless of which migration tool you are using.

https://docs.aws.amazon.com/migrationhub/latest/ug/whatishub.html

Option D is correct -AWS Schema Conversion Tool (AWS SCT) to convert your existing database schema from one database engine to another.

You can convert relational OLTP schema, or data warehouse schema.

Your converted schema is suitable for an Amazon Relational Database Service (Amazon RDS) MySQL DB instance, an Amazon Aurora DB cluster, an Amazon RDS PostgreSQL DB instance, or an Amazon Redshift cluster.

The converted schema can also be used with a database on an Amazon EC2 instance or stored as data on an Amazon S3 bucket

https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Welcome.html

The correct answer is D. AWS Schema Conversion.

AWS Schema Conversion Tool (AWS SCT) is a service provided by AWS to convert a database schema from one format to another. It helps in the conversion of database schema, including stored procedures and views, to make it compatible with the target database engine. The tool provides a highly automated process for converting database schemas and reduces the time and effort required to migrate databases.

In the case of MSP Bank, they are migrating their OLTP workloads from their existing databases, including Microsoft SQL Server, Oracle, Postgres, MySQL, and Greenplum, to Aurora and Redshift. To migrate these databases to the target engines, AWS Schema Conversion Tool will be used to convert the existing database schemas to the new format. The tool will analyze the existing database schema and provide suggestions for converting the schema to the target engine.

AWS Database Migration Service (AWS DMS) is a service that helps in migrating data from on-premise databases to the cloud. It does not help in converting the schema from one format to another. AWS Data Sync is a service that helps in transferring data between data stores, and AWS Migration Hub is a service that helps in tracking the status of migrations. Neither of these services are designed to convert database schemas.