Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Professional Data Engineer Exam - Topic 3 Question 122 Discussion

You work for a large real estate firm and are preparing 6 TB of home sales data lo be used for machine learning You will use SOL to transform the data and use BigQuery ML lo 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?
A) When creating your model, use BigQuerys TRANSFORM clause to define preprocessing stops. At prediction time, use BigQuery's ML. EVALUATE clause without specifying any transformations on the raw input data.
B) When creating your model, use BigQuery's TRANSFORM clause to define preprocessing steps Before requesting predictions, use a saved query to transform your raw input data, and then use ML. EVALUATE
C) Use a BigOuery to define your preprocessing logic. When creating your model, use the view as your model training data. At prediction lime, use BigQuery's ML EVALUATE clause without specifying any transformations on the raw input data.
D) Preprocess all data using Dataflow. At prediction time, use BigOuery's ML. EVALUATE clause without specifying any further transformations on the input data.

Google Professional Data Engineer Exam - Topic 3 Question 122 Discussion

Actual exam question for Google's Professional Data Engineer exam
Question #: 122
Topic #: 3
[All Professional Data Engineer Questions]

You work for a large real estate firm and are preparing 6 TB of home sales data lo be used for machine learning You will use SOL to transform the data and use BigQuery ML lo 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?

Show Suggested Answer Hide Answer
Suggested Answer: A

https://cloud.google.com/bigquery-ml/docs/bigqueryml-transform 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


by Dorothy at May 13, 2026, 01:57 PM

Limited Time Offer

25%

Off

Get Premium Professional Data Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Ma
3 hours ago
Option B seems like the best choice for consistent preprocessing.
upvoted 0 times
...
Xenia
5 days ago
I recall a similar question where we had to ensure the model and input data were aligned. I feel like option C could work, but I’m not sure if using a view is the right way to go about it.
upvoted 0 times
...
Ma
10 days ago
I think option D could be a good choice since it suggests preprocessing all data with Dataflow, but I'm not entirely confident if that’s the best approach for this scenario.
upvoted 0 times
...
Shelton
16 days ago
I'm a bit unsure about the TRANSFORM clause. Wasn't there a question where we had to decide between using it during training or prediction? I feel like option A might lead to issues since it doesn't transform the raw data at prediction time.
upvoted 0 times
...
Deandrea
2 months ago
I remember we discussed the importance of consistent preprocessing during our practice sessions. I think option B makes sense because it emphasizes transforming the raw data before predictions.
upvoted 0 times
...

Save Cancel