PCDE Migrate data solutions Practice Question
A company is migrating a 10 TB Teradata data warehouse to BigQuery. They need to convert Teradata DDL and BTEQ scripts to BigQuery SQL. Which Google Cloud service 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
✓
Schema Conversion Tool (SCTS)
Schema Conversion Tool (SCTS) is designed to convert DDL and SQL scripts from sources like Teradata to BigQuery-compatible format.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
BigQuery Data Transfer Service
Why it's wrong here
BigQuery Data Transfer Service automates scheduled ingestion from sources like Google Ads or Amazon S3, but it cannot parse or convert Teradata DDL or BTEQ scripts into BigQuery SQL syntax. It is tempting because its name suggests a general migration utility, and it would be correct for moving raw data from a supported source into BigQuery without schema transformation.
- ✗
Database Migration Service (DMS)
Why it's wrong here
DMS supports homogeneous migrations (e.g., MySQL to Cloud SQL) but not Teradata to BigQuery.
- ✓
Schema Conversion Tool (SCTS)
Why this is correct
The Schema Conversion Tool (SCTS) automates the translation of Teradata DDL and BTEQ scripts into BigQuery-compatible SQL, directly addressing the 10 TB migration volume by eliminating manual script rewriting. Its parser maps Teradata-specific syntax—such as `CREATE SET TABLE` and `QUALIFY`—to BigQuery equivalents, satisfying the constraint of converting legacy ETL logic without requiring intermediate staging.
- ✗
gcloud bigquery load
Why it's wrong here
This command loads data files but does not convert schema or scripts.
Go deeper
Related to this question
About these practice questions
This PCDE question is part of Courseiva's 1,446-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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 PCDE 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 PCDE exam.