Exam AWS Certified Solutions Architect - Professional topic 1 question 523 discussion

Answer is A. B: Not possible. Because transferring 10TB over 50Mbps will take 17 days at least. C: Use DMS to copy not database dump. D: You don’t need SCT since there is no need for conversion. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_LargeDBs.Process.html

B Using the calculator here http://www.calctool.org/CALC/prof/computing/transfer_time it will take 2 days to transfer 10TB over 50MB line.

A is wrong cause DMS can't load data from S3. DMS is the simplest way here and can transfer 10TB within 3days as calculated below.

You can't use AWS DMS from S3. So A is ruled out. Option - B is the right answer you can set it with minimum effort. 50MBX60X60= ~180GBX24/Per day

Agree with donation. A is the answer

Internet is measured in bit per second NOT Bytes per second. Don't know why the question would say MegaBytes...

A. Snowball copies existing data + additional synchronization

A is right. Snowball can combine with DMS and S3 for faster migration. SCT is not required because it is like to like DB

It says very clearly that "The company's internet link is 50 MB with a VPN." Therefore, transferring 10TB of data over a 50 MB link will take 2 days 7 hours 33 mins 20 sec. Therefore, the answer should be B. Calculation: 8 bits/1 byte x 50 Megabytes/s = 400 Megabits/s

The internet speed is calculated by bitpersecond and NOT Bytepersecond. B is wrong the answer is A as you don't need SCT when migrating from on-prem postgreSQL to AWS PostgreSQL

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_LargeDBs.html

50 MB is not 50 mb. The author wrote the question wrong. One is 800% different from the other. Remember networks are measured in 'b'its not 'B'ytes, even though almost all other data is capital B. In either case, data transfer will take too long.

When you're using an Edge device, the data migration process has the following stages: -You use the AWS Schema Conversion Tool (AWS SCT) to extract the data locally and move it to an Edge device. -You ship the Edge device or devices back to AWS. -After AWS receives your shipment, the Edge device automatically loads its data into an Amazon S3 bucket. -AWS DMS takes the files and migrates the data to the target data store. If you are using change data capture (CDC), those updates are written to the Amazon S3 bucket and then applied to the target data store.

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_LargeDBs.Process.html

The answer is B. We can figure out the answer by ruling out the wrong ones. A,D(wrong): Neither AWS DMS nor AWS Schema Conversion Tool can be used to copying on premise DB to Showball device. https://aws.amazon.com/dms/schema-conversion-tool/ C(wrong): Log Shipping is for SQL server on EC2, rather than AWS RDS for PostgreSQL. https://docs.aws.amazon.com/prescriptive-guidance/latest/migration-sql-server/ec2-log-shipping.html https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html#SQLServer.Concepts.General.FeatureNonSupport

MB means nothing really. If it is MBps then B is correct, If it is Mbps D is correct (Use SCT): https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_DMSIntegration.html https://docs.aws.amazon.com/dms/latest/userguide/CHAP_LargeDBs.html

C is correct. DMS now support S3 The only way to transfer data into Snowball is dump data and copy by Snowball agent, not DMS or SCT. Both DMS and SCT is service and hosted in AWS.