Q16 — AWS SAP-C02 Ch.3

Question 16 of 75 | ← Chapter 3

Q241. 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?

Correct 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

Option A can provide a dedicated, high-speed connection between the on-premises data center and AWS. However, even with a high-speed connection, migrating 60 TB of data over the internet using AWS DMS will still take a considerable amount of time. Option B can accelerate the data transfer using AWS DataSync, but it doesn't address the time required to migrate such a large volume of data over the internet using Application Migration Service. Option C uses an AWS Snowball Edge device to load the data into an Amazon S3 bucket through the S3 interface, which can be shipped to AWS for direct upload to Aurora MySQL. This approach is faster than transferring the data over the internet. The company can use AWS DMS to migrate the data from Amazon S3 to Aurora MySQL quickly and efficiently. Option D uses an AWS Snowball device to load the data into an Amazon S3 bucket using the S3 Adapter for Snowball. This method doesn't offer any significant advantages over option C, as the bottleneck is still in migrating large amounts of data over the internet.