exam questions

Exam Professional Cloud Architect All Questions

View all questions & answers for the Professional Cloud Architect exam

Exam Professional Cloud Architect topic 1 question 146 discussion

Actual exam question from Google's Professional Cloud Architect
Question #: 146
Topic #: 1
[All Professional Cloud Architect Questions]

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.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
pr2web
Highly Voted 3 years, 4 months ago
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
upvoted 101 times
mickeythecraycray
2 years, 10 months ago
Will that not increase the Database load?, one of the requirement is to reduce the load of the DB during this operation.
upvoted 3 times
...
Aiffone
3 years, 1 month ago
If I can do it in 30hrs, why choose 1 week? i'd go with B
upvoted 3 times
Aiffone
3 years, 1 month ago
I mean I'd go with A rather...questions says to spend minimum time and we have 1Gbps to do 10Tb in 30hrs
upvoted 2 times
Aiffone
3 years ago
Transfer appliance -A
upvoted 2 times
...
...
Deb2293
1 year, 11 months ago
Go home you are drunk
upvoted 6 times
...
...
joe2211
3 years, 2 months ago
Not about time but "Google-recommended practices"
upvoted 8 times
...
MikeB19
3 years, 4 months ago
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”
upvoted 3 times
valgorodetsky
2 weeks, 2 days ago
"If It would take more than one week to upload your data over the network." You always need to take in account you connection speed.
upvoted 1 times
...
...
...
gingerbeer
Highly Voted 3 years, 4 months ago
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
upvoted 21 times
RitwickKumar
2 years, 5 months ago
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.
upvoted 1 times
...
...
hpf97
Most Recent 2 weeks ago
Selected Answer: D
Answer A/C : very to setup and does not improve network limitation Answer D: Interesting for PB, not TB... and minimum 2 weeks after purchase to get the appliance (see https://cloud.google.com/blog/products/storage-data-transfer/transfer-appliances-for-simple-secure-performant-data-movement) Answer D is the best : compress would reduce the size, and even with a 1Gbps network, the transfert would take less 3 hours at full speed. Furthermore -m option use multithread.
upvoted 1 times
...
T12344223
2 months ago
Selected Answer: B
B and D sounds feasible but gsutil is not recommended any more so definitely B. https://cloud.google.com/storage/docs/gsutil However, I'm not sure if D is replaced with gcloud storage cp.
upvoted 1 times
...
ccpmad
8 months ago
Selected Answer: B
D says compress data, ¿in a single file? it will be more than the limit 5 TB of gsutil, so it is B.
upvoted 1 times
...
huuthanhdlv
8 months, 2 weeks ago
I think the answer is B. The main consideration is between B and D. Just thinking if they want the answer to be online transfer, they should have added Online Transfer Service instead of gsutils. Just guessing Google must want us to choose B :)
upvoted 1 times
...
seetpt
8 months, 3 weeks ago
Selected Answer: B
B fo sho
upvoted 1 times
...
afsarkhan
9 months ago
D will be most cost effective where as B will incur cost (question asking to consider cost effective solution as well) so D is my answer
upvoted 2 times
...
MFay
9 months, 1 week ago
Selected Answer: B
Option B (Data Transfer appliance) is the best choice for efficient and cost-effective data migration while minimizing database load and transfer time. This solution bypasses network limitations and reduces the impact on the on-premises environment, making it ideal for migrating large data sets to the cloud.
upvoted 2 times
...
gbemimatti
9 months, 2 weeks ago
Selected Answer: B
Compressing the data and uploading it with gsutil -m can be a good optimization for your transfer, but it has limitations to consider: Compression Overhead: While compressing the data can reduce upload size and potentially speed up transfer, the compression and decompression processes themselves take time and resources. Depending on your data type, the benefit of reduced size might be offset by the processing overhead. Transfer Appliance: The recommended approach with the Transfer Appliance already utilizes parallel transfers for faster uploads, potentially making gsutil -m less impactful. I will go with B
upvoted 2 times
...
gbemimatti
9 months, 2 weeks ago
Compressing the data and uploading it with gsutil -m can be a good optimization for your transfer, but it has limitations to consider: Compression Overhead: While compressing the data can reduce upload size and potentially speed up transfer, the compression and decompression processes themselves take time and resources. Depending on your data type, the benefit of reduced size might be offset by the processing overhead. Transfer Appliance: The recommended approach with the Transfer Appliance already utilizes parallel transfers for faster uploads, potentially making gsutil -m less impactful. I will go with B
upvoted 1 times
...
342f1c6
10 months, 1 week ago
Selected Answer: D
with 1 Gbps it will take only 30 hrs so best option is D
upvoted 2 times
...
RajSelvaraj
10 months, 3 weeks ago
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
upvoted 1 times
...
madcloud32
11 months, 1 week ago
Selected Answer: B
Answer B. Cp limit is 5 TB max
upvoted 3 times
...
OrangeTiger
12 months ago
Selected Answer: D
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
upvoted 2 times
ccpmad
8 months ago
D says compress data, in a single file? it will be more than the limit 5 TB of gsutil
upvoted 1 times
...
...
Pime13
1 year ago
Selected Answer: D
https://cloud.google.com/architecture/migration-to-google-cloud-transferring-your-large-datasets
upvoted 2 times
...
Pime13
1 year ago
Selected Answer: D
https://cloud.google.com/architecture/migration-to-google-cloud-transferring-your-large-datasets#online_versus_offline_transfer
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago