Google Cloud Professional Machine Learning Engineer — Question 214

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?

Answer options

• A. Use Prophet on Vertex AI Training to build a custom model.
• B. Use Vertex AI Forecast to build a NN-based model.
• C. Use BigQuery ML to build a statistical ARIMA_PLUS model.
• D. Use TensorFlow on Vertex AI Training to build a custom model.

Correct answer: C

Explanation

The correct answer is C, as BigQuery ML provides a straightforward and efficient way to create statistical models like ARIMA_PLUS directly within the database environment, minimizing setup time. Options A and D involve more complex custom model development, while B focuses on neural network approaches that may require more data and tuning for optimal performance.