PCDE Migrate data solutions Practice Question
An organization is migrating from Teradata to BigQuery. They have 20 TB of data, complex BTEQ scripts, and require near-zero downtime. Which THREE components should be part of their migration plan? (Choose THREE.)
⚠ Common exam trap
A common mistake is assuming Database Migration Service (DMS) is a general-purpose tool for any database migration, but DMS on Google Cloud is limited to specific source-target pairs (e.g., MySQL/PostgreSQL to Cloud SQL) and does not support Teradata to BigQuery migrations.
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 correct because it automates the conversion of Teradata-specific DDL, BTEQ scripts, and stored procedures into BigQuery-compatible SQL. This is critical for migrating 20 TB of data and complex BTEQ scripts without manual rewriting, reducing errors and accelerating the migration timeline.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Schema Conversion Tool (SCTS)
Why this is correct
Converts Teradata DDL and BTEQ scripts to BigQuery SQL.
- ✗
Cloud SQL Auth Proxy
Why it's wrong here
Not needed for BigQuery migration.
- ✓
Cutover planning with rollback
Why this is correct
Essential for minimizing downtime and ensuring fallback.
- ✓
BigQuery Data Transfer Service
Why this is correct
Transfers data from Teradata to BigQuery.
- ✗
Database Migration Service (DMS)
Why it's wrong here
DMS does not support Teradata to BigQuery migrations.
Go deeper
Related to this question
About these practice questions
One of 1,446 original PCDE practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
8 more ways this is tested on PCDE
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A team needs to migrate a large Teradata data warehouse to BigQuery. They want to automatically convert Teradata DDL and BTEQ scripts to BigQuery-compatible SQL. Which Google Cloud service should they use?
easy- A.BigQuery Data Transfer Service
- B.Database Migration Service (DMS)
- ✓ C.Schema Conversion Tool (SCTS)
- D.Cloud Dataflow
Why C: Schema Conversion Tool (SCTS) is designed for heterogeneous migrations, converting DDL and scripts from sources like Teradata to BigQuery.
Variation 2. A company is migrating from an on-premises Teradata data warehouse to BigQuery using the Schema Conversion Tool (SCTS). Which of the following is correctly handled by SCTS?
medium- A.Converts stored procedures from Teradata PL/SQL to BigQuery SQL.
- ✓ B.Converts Teradata BTEQ scripts to BigQuery SQL syntax.
- C.Automatically re-partitions tables based on BigQuery best practices.
- D.Migrates actual data rows from Teradata to BigQuery.
Why B: SCTS can convert Teradata DDL (e.g., CREATE TABLE) to BigQuery SQL, and also helps convert BTEQ scripts (Teradata scripting language) to BigQuery SQL. However, it does not handle data migration or performance tuning.
Variation 3. A data engineer is migrating a Teradata data warehouse to BigQuery. They have a large number of BTEQ scripts that need to be converted. Which tool is designed to automate the conversion of Teradata DDL and BTEQ scripts to BigQuery-compatible SQL?
medium- A.Database Migration Service
- B.Ora2Pg
- ✓ C.Schema Conversion Tool (SCTS)
- D.BigQuery Data Transfer Service
Why C: Schema Conversion Tool (SCTS) is provided by Google Cloud to automate the conversion of Teradata (and other) DDL and BTEQ scripts to BigQuery SQL. BigQuery Data Transfer Service is for loading data from SaaS applications. Ora2Pg is for Oracle to PostgreSQL. Database Migration Service is for database migrations to Cloud SQL or AlloyDB.
Variation 4. A data analyst needs to load data from an on-premises Teradata system into BigQuery on a recurring daily schedule. Which Google Cloud service should they use?
easy- A.Cloud Composer
- B.Cloud Data Fusion
- ✓ C.BigQuery Data Transfer Service
- D.Database Migration Service (DMS)
Why C: BigQuery Data Transfer Service is the correct service for scheduled, recurring data loads from on-premises Teradata into BigQuery. It supports Teradata via an agent-based transfer configuration. Cloud Composer is a workflow orchestration tool, not directly designed for this use case. Cloud Data Fusion provides ETL capabilities but is not the best fit for simple daily Teradata-to-BigQuery transfers. Database Migration Service is intended for migrating databases to Cloud SQL, not for loading data into BigQuery.
Variation 5. 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?
medium- A.BigQuery Data Transfer Service
- B.Database Migration Service (DMS)
- ✓ C.Schema Conversion Tool (SCTS)
- D.gcloud bigquery load
Why C: Schema Conversion Tool (SCTS) is designed to convert DDL and SQL scripts from sources like Teradata to BigQuery-compatible format.
Variation 6. A data engineer is migrating a large Teradata data warehouse to BigQuery using the Schema Conversion Tool (SCTS). They need to convert BTEQ scripts and Teradata DDL to BigQuery-compatible SQL. After conversion, several date functions are not working correctly. What is the most likely reason?
medium- A.The BigQuery Data Transfer Service is required for date conversion.
- B.The Teradata source has a different date format that is incompatible with BigQuery.
- ✓ C.The SCTS tool did not fully convert the Teradata-specific date functions to BigQuery equivalents.
- D.BigQuery does not support date arithmetic.
Why C: SCTS converts syntax but may not perfectly translate all functions; manual review is often needed for specific date functions.
Variation 7. A company is migrating a Teradata data warehouse to BigQuery. They need to convert Teradata DDL and BTEQ scripts to BigQuery-compatible SQL. Which TWO services or tools should they use? (Choose 2 correct answers.)
medium- ✓ A.Schema Conversion Tool (SCTS)
- B.Dataflow
- C.Cloud Dataproc
- D.BigQuery Migration Assessment
- ✓ E.BigQuery Data Transfer Service
Why A: Schema Conversion Tool (SCTS) is used to convert Teradata DDL to BigQuery DDL. BigQuery Data Transfer Service can be used to load data from Teradata into BigQuery. BigQuery Migration Assessment is for discovery, not conversion. Dataflow and Dataproc are not specialized for Teradata schema conversion.
Variation 8. An organization is migrating a Teradata data warehouse to BigQuery. They need to convert existing Teradata DDL and BTEQ scripts to BigQuery SQL. Which Google Cloud service should they use for schema conversion?
medium- A.Cloud Data Fusion
- B.Cloud Composer
- C.BigQuery Data Transfer Service
- ✓ D.Schema Conversion Tool (SCT)
Why D: Schema Conversion Tool (SCT) (now part of Database Migration Service) converts DDL and scripts from sources like Teradata to BigQuery. BigQuery Data Transfer Service handles data loading, not schema conversion.
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.