Google Cloud Professional Data Engineer PDE — Topic 1 Question 261

Question

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?

Accepted Answer

Correct answer: A. The correct answer is A. Option A: Use BigQuery Data Transfer Service by using the Java Database Connectivity (JDBC) driver with FastExport connection. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage. BigQuery Data Transfer Service automates loading data into BigQuery on a schedule.

Google Cloud Professional Data Engineer PDE — Question 261