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 and the overall cost. 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. Upload the data with gcloud storage cp.
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.
(https://cloud.google.com/transfer-appliance/docs/4.0/overview#suitability
This Transfer Appliance docs says it is suitable when “It would take more than one week to upload your data over the network”
10TB would take way less than a week for 1GBPS bandwidth.
Also the turn around time for the Transfer Appliance is 2-3 weeks, which eat up lot of 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. Upload the data with gcloud storage cp.
(Using gsutil cp would take only 30 hours to move 10TB.)