nerdexam
Google

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.

Submitted by jian89· Apr 18, 2026ML model development

Question

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 make monthly sales predictions for each product. You want to use a solution that can be implemented quickly with minimal effort. What should you do?

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)
  • A
    17% (11)
  • B
    8% (5)
  • C
    73% (48)
  • D
    3% (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.

AUse Prophet on Vertex AI Training to build a custom model.

Prophet on Vertex AI Training would require setting up a custom training job and managing code, which is more involved than BigQuery ML.

BUse Vertex AI Forecast to build a NN-based model.

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.

CUse BigQuery ML to build a statistical ARIMA_PLUS model.Correct

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.

DUse TensorFlow on Vertex AI Training to build a custom model.

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

#BigQuery ML#Time Series Forecasting#Managed Services#Solution Design

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-MACHINE-LEARNING-ENGINEER Practice