Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
You are planning to migrate your existing Teradata data warehouse to Google BigQuery. Your primary goal is to transfer the historical data to BigQuery in the most efficient manner while minimizing the amount of coding required. Additionally, please note that the local storage capacity on your current data warehouse is constrained. Given these factors, what approach should you take to accomplish this migration?
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.