PDE Ingesting and Processing the Data Practice Question
A large enterprise is migrating its data warehouse from Teradata to BigQuery. They need to transfer historical data (100 TB) and set up ongoing daily incremental loads. They also need to transform the data using dbt. Which THREE Google Cloud services should they use?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
BigQuery Data Transfer Service for Teradata
BigQuery Data Transfer Service for Teradata handles both historical and incremental loads, dbt runs on BigQuery for transformations, and Cloud Composer can orchestrate the dbt runs on a schedule.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Datastream
Why it's wrong here
Datastream does not support Teradata as a source.
- ✓
BigQuery Data Transfer Service for Teradata
Why this is correct
Supports both backfill and incremental transfers from Teradata to BigQuery.
- ✗
Transfer Appliance
Why it's wrong here
Transfer Appliance is for offline transfers, but the question mentions ongoing daily incremental loads which require online transfer.
- ✓
dbt (data build tool)
Why this is correct
dbt runs SQL-based transformations on BigQuery, ideal for data modeling.
- ✓
Cloud Composer
Why this is correct
Cloud Composer can schedule and orchestrate dbt runs and other tasks.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PDE question from scratch — 890 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PDE practice question is part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PDE exam.