Professional Cloud ArchitectDemo

By Google · Question Mode

QuestionQ283

Analyzing and optimizing technical and business processes

Your company wants to migrate its 10-TB on-premises database export to Cloud Storage. You want to minimize the time required to complete this activity, the total cost, and database load. 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.
Explanation

With a 1-Gbps connection, an online upload of a 10-TB export is practical; Google describes Transfer Appliance as especially suitable when network bandwidth is limited or unavailable, and notes that reasonable connectivity such as 1 Gbps can make online transfer appropriate. Compressing the existing export reduces the transfer volume without rereading the database, while gsutil -m performs operations in parallel to improve upload throughput. This avoids the shipping delay and added appliance cost, as well as the database load of extracting data through Dataflow or an ETL tool.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!