Question 175 of 280
Single answerYou work for a food product company. Your company’s historical sales data is stored in BigQuery.You need to use Vertex AI’s custom training service to train multiple TensorFlow models that read the data from BigQuery and predict future sales. You plan to implement a data preprocessing algorithm that performs mm-max scaling and bucketing on a large number of features before you start experimenting with the models. You want to minimize preprocessing time, cost, and development effort. How should you configure this workflow?
AWrite the transformations into Spark that uses the spark-bigquery-connector, and use Dataproc to preprocess the data.
✓BWrite SQL queries to transform the data in-place in BigQuery.
CAdd the transformations as a preprocessing layer in the TensorFlow models.
DCreate a Dataflow pipeline that uses the BigQuerylO connector to ingest the data, process it, and write it back to BigQuery.
✓
Correct Answer: B
Write SQL queries to transform the data in-place in BigQuery.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.