Google Cloud Professional Cloud Architect — Question 164

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?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer is B because using the Data Transfer appliance allows for an efficient offline migration of large datasets without impacting the on-premises database performance. Options A and C involve online transfers that could increase load and costs, while D, although it speeds up uploads, would still be limited by the bandwidth and may not be as efficient for such a large volume of data.