A retail company wants to build a product recommendation system using BigQuery ML for their e-commerce platform. The data includes customer purchase history, product metadata, and clickstream logs. The ML engineer needs to minimize manual feature engineering and leverage pre-built solutions. Which approach should the engineer take?
Trap 1: Use a pre-built recommendation model from Vertex AI Model Garden…
This is not a BigQuery ML solution and requires additional infrastructure.
Trap 2: Write a custom TensorFlow model using the Vertex AI Training…
This requires significant custom coding, not low-code.
Trap 3: Export the data to CSV and use AutoML Tables to train a…
AutoML Tables is not integrated with BigQuery ML; exporting data adds complexity.
- A
Use a pre-built recommendation model from Vertex AI Model Garden and deploy it to an endpoint.
Why wrong: This is not a BigQuery ML solution and requires additional infrastructure.
- B
Write a custom TensorFlow model using the Vertex AI Training service and deploy it via Vertex AI Prediction.
Why wrong: This requires significant custom coding, not low-code.
- C
Export the data to CSV and use AutoML Tables to train a recommendation model.
Why wrong: AutoML Tables is not integrated with BigQuery ML; exporting data adds complexity.
- D
Use BigQuery ML's matrix factorization model (CREATE MODEL with model_type='matrix_factorization') to train directly on historical interaction data.
BigQuery ML provides low-code matrix factorization for recommendations.