Q42 — AWS SAP-C02 Ch.1

Question 42 of 75 | ← Chapter 1

Q117. A company is planning to migrate its business-critical applications from an on-premises data center to AWS. The company has an on-premises installation of a Microsoft SQL Server Always On cluster. The company wants to migrate to an AWS managed database service. A solutions architect must design a heterogeneous database migration on AWSWhich solution will meet these requirements?

• A. Migrate the SQL Server databases to Amazon RDS for MySQL by using backup and restore utilities
• B. Use an AWS Snowball Edge Storage Optimized device to transfer data to Amazon S3. Set up Amazon RDS for MySQLUse S3 integration with SQL Server features, such as BULK INSERT
• C. Use the AWS Schema Conversion Tool to translate the database schema to Amazon RDS for MySQL.Then use AWSDatabase Migration Service (AWS DMS) to migrate the data from on-premises databases to Amazon RDS ✓
• D. Use AWS DataSync to migrate data over the network between on-premises storage and Amazon S3.Set up Amazon RDS for MySQL. Use S3 integration with SQL Server features. such as BULK INSERT

Correct Answer: C. Use the AWS Schema Conversion Tool to translate the database schema to Amazon RDS for MySQL.Then use AWSDatabase Migration Service (AWS DMS) to migrate the data from on-premises databases to Amazon RDS

Explanation

To migrate a Microsoft SQL Server Always On cluster from an on-premises data center to an AWS managed database service, the most suitable solution is: C. Use the AWS Schema Conversion Tool to translate the database schema to Amazon RDS for MySQL. Then use AWS Database Migration Service (AWS DMS) to migrate the data from on-premises databases to Amazon RDS. Explanation: Option A is incorrect because migrating SQL Server databases to Amazon RDS for MySQL using backup and restore utilities is not a direct and compatible migration strategy. SQL Server and MySQL have different database engines and functionalities, and a simple backup and restore process will not ensure a successful migration. Option B is incorrect because using an AWS Snowball Edge device to transfer data to Amazon S3 and setting up Amazon RDS for MySQL with S3 integration is not a direct and compatible migration strategy. It does not address the need to migrate the SQL Server Always On cluster to an AWS managed database service. Option D is incorrect because using AWS DataSync to migrate data between on-premises storage and Amazon S3 and setting up Amazon RDS for MySQL with S3 integration is not a direct and compatible migration strategy. It does not address the need to migrate the SQL Server Always On cluster to an AWS managed database service. Therefore, the correct solution is C: Use the AWS Schema Conversion Tool to translate the database schema from SQL Server to Amazon RDS for MySQL. Then use AWS Database Migration Service (AWS DMS) to migrate the data from the on-premises SQL Server Always On cluster to Amazon RDS for MySQL. The AWS Schema Conversion Tool will handle the necessary conversions and mappings between the two different database engines, ensuring a successful migration to the AWS managed database service. The AWS Schema Conversion Tool (AWS SCT) makes heterogeneous database migrations.