Skip to Content

Amazon SAP-C02: Solution to meet requirements migrate database in least time

By: Author Alex Lim

Posted on  - Last updated:

Categories Exam

Question

A company is planning a one-time migration of an on-premises MySQL database to Amazon Aurora MySQL in the us-east-1 Region. The company’s current internet connection has limited bandwidth. The on-premises MySQL database is 60 TB in size. The company estimates that it will take a month to transfer the data to AWS over the current internet connection. The company needs a migration solution that will migrate the database more quickly. Which solution will migrate the database in the LEAST amount of time?

A. Request a 1 Gbps AWS Direct Connect connection between the on-premises data center and AWS. Use AWS Database Migration Service (AWS DMS) to migrate the on-premises MySQL database to Aurora MySQL.
B. Use AWS DataSync with the current internet connection to accelerate the data transfer between the on-premises data center and AWS. Use AWS Application Migration Service to migrate the on-premises MySQL database to Aurora MySQL.
C. Order an AWS Snowball Edge device. Load the data into an Amazon S3 bucket by using the S3 interface. Use AWS Database Migration Service (AWS DMS) to migrate the data from Amazon S3 to Aurora MySQL.
D. Order an AWS Snowball device. Load the data into an Amazon S3 bucket by using the S3 Adapter for Snowball. Use AWS Application Migration Service to migrate the data from Amazon S3 to Aurora MySQL.

Answer

C. Order an AWS Snowball Edge device. Load the data into an Amazon S3 bucket by using the S3 interface. Use AWS Database Migration Service (AWS DMS) to migrate the data from Amazon S3 to Aurora MySQL.

Explanation

The best solution for migrating the on-premises MySQL database to Amazon Aurora MySQL in the least amount of time is C. Ordering an AWS Snowball Edge device and using AWS Database Migration Service (AWS DMS) to migrate the data from Amazon S3 to Aurora MySQL will be faster than transferring the data over the internet or using a regular AWS Snowball device.

An AWS Snowball Edge device is a type of Snowball device with on-board storage and compute power for select AWS capabilities. It can transport data at speeds faster than the internet by shipping the data in the appliances through a regional carrier. It has a storage capacity of 100 TB, which is enough to fit the 60 TB on-premises MySQL database. It also supports the S3 interface, which allows loading the data into an Amazon S3 bucket on the device.

AWS Database Migration Service (AWS DMS) is a service that helps migrate databases to AWS quickly and securely. It supports both homogeneous migrations (such as MySQL to MySQL) and heterogeneous migrations (such as MySQL to Aurora MySQL). It can also migrate data from Amazon S3 to Aurora MySQL by using an S3 bucket as a source endpoint.

Therefore, by using an AWS Snowball Edge device and AWS DMS, the company can migrate the on-premises MySQL database to Aurora MySQL more quickly than using other solutions.

The other solutions are not optimal for the following reasons:

A. Requesting a 1 Gbps AWS Direct Connect connection between the on-premises data center and AWS will still take a long time to transfer 60 TB of data over the internet. According to a simple calculation, it will take about 13.9 days to transfer 60 TB of data over a 1 Gbps connection, assuming no overhead or latency. This is much longer than the estimated 4-6 days for receiving an AWS Snowball Edge device.

B. Using AWS DataSync with the current internet connection to accelerate the data transfer between the on-premises data center and AWS will not be much faster than using a regular internet connection. AWS DataSync is a service that automates and accelerates moving data between on-premises storage systems and AWS storage services. However, it still depends on the available bandwidth and latency of the network connection. If the company’s current internet connection has limited bandwidth, as stated in the question, then using AWS DataSync will not significantly speed up the data transfer.

D. Ordering an AWS Snowball device and using AWS Application Migration Service to migrate the data from Amazon S3 to Aurora MySQL will be slower than using an AWS Snowball Edge device and AWS DMS. An AWS Snowball device is similar to an AWS Snowball Edge device, but it has less storage capacity (80 TB) and less compute functionality. It also does not support the S3 interface, but instead uses the S3 Adapter for Snowball, which is a standalone application that acts as an endpoint for Amazon S3 operations. This adds an extra layer of complexity and overhead to the data transfer process.

AWS Application Migration Service is a service that helps migrate applications from on-premises or cloud environments to AWS without rewriting them. However, it does not support migrating databases directly, but instead relies on other services such as AWS DMS or AWS SCT (AWS Schema Conversion Tool) to migrate database schemas and data. This adds another layer of complexity and overhead to the migration process.

Reference

Amazon AWS Certified Solutions Architect – Professional SAP-C02 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Amazon AWS Certified Solutions Architect – Professional SAP-C02 exam and earn Amazon AWS Certified Solutions Architect – Professional SAP-C02 certification.