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 Teradata data warehouse to BigQuery. The objective is to transfer historical data to BigQuery as efficiently as possible with minimal programming effort, given the constraint of limited local storage space on your current data warehouse. What is the best approach to achieve this?
A
Develop a script to export historical data in batches, upload them to Cloud Storage, and then use BigQuery Data Transfer Service to move data from Cloud Storage to BigQuery.
B
Utilize the BigQuery Data Transfer Service with the Teradata Parallel Transporter (TPT) tbuild utility for data migration.
C
Employ the BigQuery Data Transfer Service by leveraging the Java Database Connectivity (JDBC) driver with a FastExport connection for direct data transfer.
D
Create a Teradata Parallel Transporter (TPT) export script for historical data and import it into BigQuery using the bq command-line tool.