MSP Bank, Limited is a leading Japanese monetary institution that provides a full range of financial products and services to both institutional and individual customers.
It is headquartered in Tokyo.
MSP Bank is hosting their existing infrastructure on premise.
MSP bank has lot of web applications, databases and data warehouses, NoSQL databases, and other types of data stores.
MSP Bank is working with AWS to migrate their existing platform onto AWS. Currently MSP has the following databases to support OLTP workloads Microsoft SQL Server Oracle Postgres MySQL WH Workload Greenplum. The team finalized Aurora to migrate OLTP workloads and Greenplum onto Redshift.
What service does AWS propose to convert the schema's from one format to other? select 1 option.
Click on the arrows to vote for the correct answer
A. B. C. D.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.htmlOption 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.htmlOption 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.htmlOption 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.htmlThe 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.