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, 3 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 100 times
mickeythecraycray
2 years, 8 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 ago
If I can do it in 30hrs, why choose 1 week? i'd go with B
upvoted 3 times
Aiffone
3 years 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
2 years, 11 months ago
Transfer appliance -A
upvoted 2 times
...
...
Deb2293
1 year, 9 months ago
Go home you are drunk
upvoted 5 times
...
...
joe2211
3 years, 1 month ago
Not about time but "Google-recommended practices"
upvoted 8 times
...
MikeB19
3 years, 3 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
...
...
gingerbeer
Highly Voted 3 years, 3 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, 4 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
...
...
T12344223
Most Recent 3 weeks, 4 days 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
6 months, 3 weeks 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
7 months, 1 week 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
7 months, 2 weeks ago
Selected Answer: B
B fo sho
upvoted 1 times
...
afsarkhan
7 months, 3 weeks 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
8 months 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
8 months, 1 week 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
8 months, 1 week 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
9 months ago
Selected Answer: D
with 1 Gbps it will take only 30 hrs so best option is D
upvoted 2 times
...
RajSelvaraj
9 months, 2 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
10 months ago
Selected Answer: B
Answer B. Cp limit is 5 TB max
upvoted 3 times
...
OrangeTiger
10 months, 4 weeks 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
6 months, 3 weeks ago
D says compress data, in a single file? it will be more than the limit 5 TB of gsutil
upvoted 1 times
...
...
Pime13
11 months ago
Selected Answer: D
https://cloud.google.com/architecture/migration-to-google-cloud-transferring-your-large-datasets
upvoted 2 times
...
Pime13
11 months, 1 week ago
Selected Answer: D
https://cloud.google.com/architecture/migration-to-google-cloud-transferring-your-large-datasets#online_versus_offline_transfer
upvoted 1 times
...
didek1986
11 months, 2 weeks ago
Selected Answer: B
It is B
upvoted 2 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