Select An AI Action To Trigger Against This Article

You developed a BigQuery ML linear regressor model by using a training dataset stored in a BigQuery table. New data is added to the table every minute. You are using Cloud Scheduler and Vertex AI Pipelines to automate hourly model training, and use the model for direct inference. The feature preprocessing logic includes quantile bucketization and MinMax scaling on data received in the last hour. You want to minimize storage and computational overhead. What should you do?

  • A. Preprocess and stage the data in BigQuery prior to feeding it to the model during training and inference.
  • B. Use the TRANSFORM clause in the CREATE MODEL statement in the SQL query to calculate the required statistics.
  • C. Create a component in the Vertex AI Pipelines directed acyclic graph (DAG) to calculate the required statistics, and pass the statistics on to subsequent components.
  • D. Create SQL queries to calculate and store the required statistics in separate BigQuery tables that are referenced in the CREATE MODEL statement.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
Back
Run Some AI Magic On Article

Exam Professional Machine Learning Engineer topic 1 question 289 discussion - ExamTopics

Click on the Run Some AI Magic button and choose an AI action to run on this article