PROFESSIONAL-DATA-ENGINEER · Question #250
PROFESSIONAL-DATA-ENGINEER Question #250: Real Exam Question with Answer & Explanation
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
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.
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
Community Discussion
No community discussion yet for this question.