Page Reader AI | Exam Professional Machine Learning Engineer topic 1 question 289 discussion

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

This question discusses optimizing a BigQuery ML linear regressor model's training and inference processes by minimizing storage and computational overhead.

AI Summary available — skim the key points instantly. Show AI Generated Summary

Show AI Generated Summary

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