AWS Database Migration Service

AWS Database Migration Service

Question

MSP Bank, Limited is a leading varied 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.

What service does AWS propose to address migration of databases? Select 2 options.

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

Answer : A,D.

Option A is correct -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

AWS provides a range of services for migrating existing infrastructure to the cloud, including databases. In the case of MSP Bank's migration, AWS proposes two services to address the migration of databases:

  1. AWS Database Migration Service (AWS DMS): This service is designed to migrate databases to AWS easily and securely. AWS DMS supports homogenous migrations such as Oracle to Oracle, as well as heterogeneous migrations between different database platforms like Oracle to Amazon Aurora or Microsoft SQL Server to MySQL. AWS DMS can be used for one-time migrations as well as for continuous replication to keep the databases synchronized between on-premises and AWS. AWS DMS can handle data migration with minimal downtime, and it can automatically handle schema conversion and data type transformations.

  2. AWS Schema Conversion Tool (AWS SCT): This service helps automate the process of converting the schema of the source database to the schema of the target database. AWS SCT can analyze the schema of the source database and provide recommendations on how to optimize the schema for the target database in AWS. AWS SCT can also convert the schema, including stored procedures and triggers, from the source database to the target database format.

Both of these services can help MSP Bank migrate their databases to AWS with minimal downtime and effort, while ensuring the security and reliability of the data. Additionally, AWS Migration Hub can be used to track the progress of the overall migration and provide a central location for monitoring and managing the migration of all the different resources, including databases. Finally, AWS Data Sync can be used to transfer data between on-premises storage and AWS storage, including Amazon S3 and Amazon EFS.