Google Exam Professional-Cloud-Architect Topic 5 Question 77 Discussion

Actual exam question for Google's Google Cloud Architect Professional exam

Question #: 77
Topic #: 5

[All Google Cloud Architect Professional 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?

AUse the Data Transfer appliance to perform an offline migration

BUse a commercial partner ETL solution to extract the data from the on-premises database and upload it into Cloud Storage

CDevelop a Dataflow job to read data directly from the database and write it into Cloud Storage

DCompress the data and upload it with gsutii -m to enable multi-threaded copy

Show Suggested Answer

Suggested Answer: A

The Data Transfer appliance is a Google-provided hardware device that can be used to transfer large amounts of data from on-premises environments to Cloud Storage. It is suitable for scenarios where the bandwidth between the on-premises environment and Google Cloud is low or insufficient, and the data size is large. The Data Transfer appliance can minimize the time it takes to complete the migration, the overall cost and database load, by avoiding network bottlenecks and reducing bandwidth consumption. The Data Transfer appliance also encrypts the data at rest and in transit, ensuring data security and privacy. The other options are not optimal for this scenario, because they either require a high-bandwidth network connection (B, C, D), or incur additional costs and complexity (B, C). Reference:

https://cloud.google.com/data-transfer-appliance/docs/overview

https://cloud.google.com/blog/products/storage-data-transfer/introducing-storage-transfer-service-for-on-premises-data

by Van at Mar 10, 2024, 07:38 AM

Limited Time Offer

25%

6 months ago

I'm leaning towards the Dataflow job option. It seems like the most cost-effective and efficient way to move the data directly from the database to Cloud Storage. Plus, it follows the Google-recommended practices.

upvoted 0 times

6 months ago

This is a tricky question. I'm not sure if the Data Transfer appliance is the best option since it might be overkill for a 10-TB migration. The commercial partner ETL solution could work, but it might be more expensive than the other options.

upvoted 0 times

...