Google Cloud Professional Data Engineer — Question 158

You want to migrate your existing Teradata data warehouse to BigQuery. You want to move the historical data to BigQuery by using the most efficient method that requires the least amount of programming, but local storage space on your existing data warehouse is limited. What should you do?

Answer options

• A. Use BigQuery Data Transfer Service by using the Java Database Connectivity (JDBC) driver with FastExport connection.
• B. Create a Teradata Parallel Transporter (TPT) export script to export the historical data, and import to BigQuery by using the bq command-line tool.
• C. Use BigQuery Data Transfer Service with the Teradata Parallel Transporter (TPT) tbuild utility.
• D. Create a script to export the historical data, and upload in batches to Cloud Storage. Set up a BigQuery Data Transfer Service instance from Cloud Storage to BigQuery.

Correct answer: A

Explanation

The correct answer is A because using BigQuery Data Transfer Service with the JDBC driver and FastExport connection minimizes programming effort while efficiently transferring data. Options B and D involve more manual processes and local storage usage, which contradicts the requirement for limited space. Option C, while effective, does not align with the least programming requirement.