PCDE Migrate data solutions Practice Question
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?
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
✓
Converts Teradata BTEQ scripts to BigQuery SQL syntax.
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.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Converts stored procedures from Teradata PL/SQL to BigQuery SQL.
Why it's wrong here
BigQuery does not support stored procedures in the same way; SCTS may assist with conversion, but it is not automatic.
- ✓
Converts Teradata BTEQ scripts to BigQuery SQL syntax.
Why this is correct
SCTS includes functionality to convert BTEQ scripts to BigQuery-compatible SQL.
- ✗
Automatically re-partitions tables based on BigQuery best practices.
Why it's wrong here
SCTS does not automatically re-partition; manual tuning is needed.
- ✗
Migrates actual data rows from Teradata to BigQuery.
Why it's wrong here
Data migration is done by BigQuery Data Transfer Service or other tools, not SCTS.
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 →
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.