Google
PROFESSIONAL-DATA-ENGINEER · Question #250
You work for a large real estate firm and are preparing 6 TB of home sales data to be used for machine learning. You will use SQL to transform the data and use BigQuery ML to create a machine learning
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #250. The question stem and answer options stay visible for context.
Submitted by carter_n· Mar 30, 2026Operationalizing machine learning models
Question
You work for a large real estate firm and are preparing 6 TB of home sales data to be used for machine learning. You will use SQL to transform the data and use BigQuery ML to create a machine learning model. You plan to use the model for predictions against a raw dataset that has not been transformed. How should you set up your workflow in order to prevent skew at prediction time?
Options
- AWhen creating your model, use BigQuery's TRANSFORM clause to define preprocessing steps.
- BWhen creating your model, use BigQuery's TRANSFORM clause to define preprocessing steps.
- CUse a BigQuery view to define your preprocessing logic.
- DPreprocess all data using Dataflow.
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#BigQuery ML#TRANSFORM clause#training-serving skew#preprocessing