Your company wants to migrate their 10-TB on-premises database export into Cloud Storage. You want to minimize the time it takes to complete this activity, the overall cost, and database load. The bandwidth between the on-premises environment and Google Cloud is 1 Gbps. You want to follow Google-recommended practices. What should you do?
A. Develop a Dataflow job to read data directly from the database and write it into Cloud Storage.
B. Use the Data Transfer appliance to perform an offline migration.
C. Use a commercial partner ETL solution to extract the data from the on-premises database and upload it into Cloud Storage.
D. Compress the data and upload it with gsutil -m to enable multi-threaded copy.
Disclaimer
This is a practice question. There is no guarantee of coming this question in the certification exam.
Answer
D
Explanation
A. Develop a Dataflow job to read data directly from the database and write it into Cloud Storage.
(Ruled out.)
B. Use the Data Transfer appliance to perform an offline migration.
(Transferring data using transfer appliance will have 2-3 weeks total time.)
C. Use a commercial partner ETL solution to extract the data from the on-premises database and upload it into Cloud Storage.
(Ruled out.)
D. Compress the data and upload it with gsutil -m to enable multi-threaded copy.
(Reference:
https://cloud.google.com/architecture/migration-to-google-cloud-transferring-your-large-datasets#online_versus_offline_transfer
10TB with 1GBPS will take 30 hours.)