Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
In your role at a large real estate firm, you're preparing to analyze 6 TB of home sales data. You plan to use SQL for data transformation and BigQuery ML to build a machine learning model, aiming to make predictions on raw, untransformed data. How should you set up your workflow to prevent skew during prediction?
A
Define preprocessing steps with BigQuery's TRANSFORM clause when creating your model. During prediction, apply ML.EVALUATE without transforming the raw input data.
B
After defining preprocessing steps with BigQuery's TRANSFORM clause during model creation, transform your raw input data using a saved query before applying ML.EVALUATE for predictions.
C
Establish preprocessing logic in a BigQuery view, use this view as your training data for model creation, and apply ML.EVALUATE without transformations on raw data during prediction.
D
Process all data through Dataflow for preprocessing. During prediction, use ML.EVALUATE without additional transformations on the input data.