PROFESSIONAL-MACHINE-LEARNING-ENGINEER · Question #226
You work for an online retailer. Your company has a few thousand short lifecycle products. Your company has five years of sales data stored in BigQuery. You have been asked to build a model that will
The correct answer is C. Use BigQuery ML to build a statistical ARIMA_PLUS model.. For monthly sales predictions of thousands of short-lifecycle products using historical sales data in BigQuery with minimal effort, BigQuery ML's ARIMA_PLUS model is an excellent, quick-to-implement solution.
Question
Options
- AUse Prophet on Vertex AI Training to build a custom model.
- BUse Vertex AI Forecast to build a NN-based model.
- CUse BigQuery ML to build a statistical ARIMA_PLUS model.
- DUse TensorFlow on Vertex AI Training to build a custom model.
How the community answered
(66 responses)- A17% (11)
- B8% (5)
- C73% (48)
- D3% (2)
Why each option
For monthly sales predictions of thousands of short-lifecycle products using historical sales data in BigQuery with minimal effort, BigQuery ML's `ARIMA_PLUS` model is an excellent, quick-to-implement solution.
Prophet on Vertex AI Training would require setting up a custom training job and managing code, which is more involved than BigQuery ML.
Vertex AI Forecast is a managed service, but BigQuery ML provides a more direct and minimal effort solution when data is already in BigQuery and SQL can be used.
BigQuery ML allows users to create and execute machine learning models directly within BigQuery using SQL queries, significantly reducing the effort and time required for model development and deployment. `ARIMA_PLUS` is a powerful statistical model specifically designed for time series forecasting, making it suitable for this use case.
Using TensorFlow on Vertex AI Training to build a custom model provides maximum flexibility but requires significant development effort, not aligning with the 'minimal effort' requirement.
Concept tested: BigQuery ML for time series forecasting
Source: https://cloud.google.com/bigquery-ml/docs/reference/standard-sql/bigqueryml-syntax-create-forecast#create_model_arithmetic_plus_type
Topics
Community Discussion
No community discussion yet for this question.