PROFESSIONAL-MACHINE-LEARNING-ENGINEER · Question #234
You work for a pharmaceutical company based in Canada. Your team developed a BigQuery ML model to predict the number of flu infections for the next month in Canada. Weather data is published weekly…
The correct answer is D. Download the weather data each week, and download the flu data each month. Deploy the model. To minimize cost for a BigQuery ML model predicting monthly flu infections using weekly weather data and monthly flu statistics, configure monthly retraining.
Question
Options
- ADownload the weather and flu data each week. Configure Cloud Scheduler to execute a Vertex AI
- BDownload the weather and flu data each month. Configure Cloud Scheduler to execute a Vertex
- CDownload the weather and flu data each week. Configure Cloud Scheduler to execute a Vertex AI
- DDownload the weather data each week, and download the flu data each month. Deploy the model
How the community answered
(23 responses)- A4% (1)
- B4% (1)
- C9% (2)
- D83% (19)
Why each option
To minimize cost for a BigQuery ML model predicting monthly flu infections using weekly weather data and monthly flu statistics, configure monthly retraining.
Retraining weekly would incur higher costs without providing a clear benefit for a model predicting monthly flu infections, as the primary target variable only updates monthly.
Downloading weather data only monthly might result in less fresh feature data if weekly trends are valuable, and executing a Vertex AI custom job might be more complex than a direct BigQuery ML `CREATE OR REPLACE MODEL` for a BQML model.
Retraining weekly with all data, including monthly flu data, is not cost-optimal because the target variable for prediction only changes monthly.
Retraining the model monthly aligns with the publication frequency of flu infection statistics (the target variable), which is the most cost-effective approach for a monthly prediction target. Downloading weather data weekly ensures freshness but is incorporated into the monthly retraining cycle, automated via Cloud Scheduler executing a BigQuery ML `CREATE OR REPLACE MODEL` statement.
Concept tested: Model retraining policy optimization
Source: https://cloud.google.com/bigquery-ml/docs/model-management#update_or_retrain_your_model
Topics
Community Discussion
No community discussion yet for this question.