• Maxim
  • New member
  • Offline

Topic: Professional Cloud Architect topic 1 question 146

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.

Re: Professional Cloud Architect topic 1 question 146

This is pretty simple.
Time to transfer using Transfer Appliance: 1-3 weeks (I've used it twice and had a 2-3 week turnaround total)
Time to transfer using 1Gbps : 30 hours (https://cloud.google.com/architecture/migration-to-google-cloud-transferring-your-large-datasets)

Answer is D, using gsutil

Re: Professional Cloud Architect topic 1 question 146

If I can do it in 30hrs, why choose 1  week? i'd go with B

Re: Professional Cloud Architect topic 1 question 146

I mean I'd go with A rather...questions says to spend minimum time and we have 1Gbps to do 10Tb in 30hrs

Re: Professional Cloud Architect topic 1 question 146

Transfer appliance -A

Re: Professional Cloud Architect topic 1 question 146

Go home you are drunk

Re: Professional Cloud Architect topic 1 question 146

Will that not increase the Database load?, one of the requirement is to reduce the load of the DB during this operation.

Re: Professional Cloud Architect topic 1 question 146

Not about time but "Google-recommended practices"

Re: Professional Cloud Architect topic 1 question 146

This is the correct article to support this question but the article proves the transfer appliance is the correct answer. Right below the transfer calc chart is recommended amount of data for gsutil. Gsutil should be used for data transfer under 1 tb

“Your private data center to Google Cloud    Enough bandwidth to meet your project deadline
for less than 1 TB of data    gsutil”

Re: Professional Cloud Architect topic 1 question 146

No perfect answer as B and D both have flaws. B is time latency as transfer appliance usually takes weeks; D gsutil applies for less than 1TB. The answer should be storage transfer service for on-premises data, which is not available here.

If have to choose one I go for B

Re: Professional Cloud Architect topic 1 question 146

Storage transfer service is for online data. It can't serve the purpose if you don't have the connectivity established between on prem and gcp. Which is what we can't assume ourselves in this question.

Re: Professional Cloud Architect topic 1 question 146

Option B and D are most feasible options
Option B will be okay if the size of the data is too huge
Option D will be good for a few TBs of data. I am assuming 10 TB will fit in this case.

https://cloud.google.com/blog/topics/developers-practitioners/how-transfer-your-data-google-cloud

Re: Professional Cloud Architect topic 1 question 146

Answer B. Cp limit is 5 TB max

Re: Professional Cloud Architect topic 1 question 146

I chose D.
According to the link below, 10TB of data can be transferred in 30h. The light blue area is the acceptable line for online transfer.
https://cloud.google.com/architecture/migration-to-google-cloud-transferring-your-large-datasets?hl=ja#online_versus_offline_transfer

Re: Professional Cloud Architect topic 1 question 146

https://cloud.google.com/architecture/migration-to-google-cloud-transferring-your-large-datasets

Re: Professional Cloud Architect topic 1 question 146

https://cloud.google.com/architecture/migration-to-google-cloud-transferring-your-large-datasets#online_versus_offline_transfer

Re: Professional Cloud Architect topic 1 question 146

It is B

Re: Professional Cloud Architect topic 1 question 146

it is D. it is far more faster to send this 10TB data over network, than 'call' for Transfer Applience.

Re: Professional Cloud Architect topic 1 question 146

Transfer Appliance: 1-3 weeks
Transfer using 1Gbps : 30 hours

Re: Professional Cloud Architect topic 1 question 146

Is Transfer Appliance suitable for me?
Transfer Appliance is a good fit for your data transfer needs if:    You are an existing Google Cloud customer.
   Your data resides in locations that Transfer Appliance is available.
    It would take more than one week to upload your data over the network. vs Time to transfer using 1Gbps : 30 hours

Re: Professional Cloud Architect topic 1 question 146

I just want to ask who choose B. Both B and D you can find some evidence in the doc. So we do not talk about the doc, we just talk about if 30 hours to transfer it you can not accept it, and if you use transfer appliance it will spend over 10 days you can accept?  So forget about the doc, if google want you to choose B, they will give you 100TB or 1PB rather than 10TB

Re: Professional Cloud Architect topic 1 question 146

Option B is correct. Below is the explanation.

Transfer scenario    Recommendation
Transferring from another cloud storage provider    Use Storage Transfer Service.
Transferring less than 1 TB from on-premises    Use gcloud storage.
Transferring more than 1 TB from on-premises    Use Storage Transfer Service.
Transferring less than 1 TB from another Cloud Storage region    Use gcloud storage.
Transferring more than 1 TB from another Cloud Storage region    Use Storage Transfer Service.

Re: Professional Cloud Architect topic 1 question 146

"The expected turnaround time for a network appliance to be shipped, loaded with your data, shipped back, and rehydrated on Google Cloud is 20 days. If your online transfer timeframe is calculated to be substantially more than this timeframe, consider Transfer Appliance."

Re: Professional Cloud Architect topic 1 question 146

10 TB @ 1 Gbps = 30 hour transfer time. So would you go with the 20 day timeline, or 30 hours?

Re: Professional Cloud Architect topic 1 question 146

B for me as this is a Google exam.