nerdexam
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…

The correct answer is A. When creating your model, use BigQuery's TRANSFORM clause to define preprocessing steps. Explanation/Reference: Using the TRANSFORM clause, you can specify all preprocessing during model creation. The preprocessing is automatically applied during the prediction and evaluation phases of machine learning. https://cloud.google.com/bigquery-ml/docs/bigqueryml-transform

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.

How the community answered

(57 responses)
  • A
    46% (26)
  • B
    7% (4)
  • C
    30% (17)
  • D
    18% (10)

Explanation

Explanation/Reference: Using the TRANSFORM clause, you can specify all preprocessing during model creation. The preprocessing is automatically applied during the prediction and evaluation phases of machine learning. https://cloud.google.com/bigquery-ml/docs/bigqueryml-transform

Topics

#BigQuery ML#TRANSFORM clause#training-serving skew#preprocessing

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full PROFESSIONAL-DATA-ENGINEER Practice