What is the least-code way to build a game recommendation model in BigQuery?

You work at a gaming startup that has several terabytes of structured data in Cloud Storage. This data includes gameplay time data, user metadata, and game metadata. You want to build a model that recommends new games to users that requires the least amount of coding. What should you do?

  1. Load the data in BigQuery. Use BigQuery ML to train an Autoencoder model.
  2. Load the data in BigQuery. Use BigQuery ML to train a matrix factorization model. Source Reference Answer
  3. Read data to a Vertex AI Workbench notebook. Use TensorFlow to train a two-tower model.
  4. Read data to a Vertex AI Workbench notebook. Use TensorFlow to train a matrix factorization model.

Community Votes

B
100%

100% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.

Community Insight

The exam tests that BigQuery ML provides built-in matrix factorization for recommendation models, requiring far less coding than custom TensorFlow implementations.

For a gaming startup with structured data in Cloud Storage, BigQuery ML's matrix factorization is the recommended low-code collaborative filtering approach, as confirmed by 91% of voters.

Choosing A (Autoencoder) because it still uses BigQuery ML, but autoencoders are not designed for collaborative filtering recommendations; matrix factorization is the standard low-code model.

Community Discussion (4 comments)

omermahgoub 👍 1 Selected: A
Minimal Coding: BigQuery ML provides a user-friendly interface for training models, minimizing the need for extensive coding in tools like TensorFlow (C & D) Efficient Data Processing: Training directly in BigQuery eliminates data movement and leverages BigQuery's scalable infrastructure.
vaibavi 👍 4 Selected: B
least amount of coding--> BQML recommendations--> matrix factorization
guilhermebutzke 👍 3 Selected: B
Using BigQuery ML for training a matrix factorization model would require less coding compared to building a custom model with TensorFlow in a Vertex AI Workbench notebook. BigQuery ML provides high-level APIs for machine learning tasks directly within the BigQuery environment, thus reducing the amount of coding needed for data preprocessing and model training. Matrix factorization is a commonly used technique for recommendation systems, making it a suitable choice for recommending new games to users based on their gameplay time data, user metadata, and game metadata.
Yan_X 👍 3 Selected: B
B https://developers.google.com/machine-learning/recommendation/collaborative/matrix

Comments & Corrections

No comments yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

Expert Analysis

Why the Answer Is Correct

Matrix factorization is a well-known collaborative filtering technique for recommendation systems, modeling user-item interactions. BigQuery ML supports matrix factorization via a simple SQL statement (CREATE MODEL with MODEL_TYPE='MATRIX_FACTORIZATION'), which minimizes coding and integrates directly with data loaded into BigQuery. Voter comments [1] and [2] highlight that the phrase 'least amount of coding' points to BigQuery ML's high-level APIs rather than custom code.

Why the Other Options Are Wrong

Option A uses BigQuery ML but selects an autoencoder, which is not designed for recommendation tasks and would require more complex preprocessing. Options C and D require reading data into a Vertex AI Workbench notebook and writing TensorFlow code, which is significantly more code than a BigQuery ML SQL query. The question explicitly asks for the least coding, so BQML's managed approach is the clear winner.

Community Comment Notes

The top comment [1] succinctly maps 'least amount of coding' to 'BQML recommendations → matrix factorization'. Comment [2] explains that BigQuery ML reduces data preprocessing and training code compared to TensorFlow. Comment [3] shares the Google Machine Learning recommendation resources on matrix factorization, reinforcing the concept. Comment [4] incorrectly suggests autoencoder, but the community overwhelmingly favors B with 91 votes, aligning with the suggested answer.

Official Reference

Exam Strategy

Look for the phrase 'least amount of coding' in Google Cloud exam questions; this usually signals BigQuery ML over custom notebooks. For recommendation scenarios, remember the canonical BigQuery ML model type is matrix factorization, not autoencoder or two-tower.

Related Analysis

You are pre-training a large language model on Google Cloud.

S-Grade

You work for a retail company. You have been asked to develo

A-Grade

You need to deploy a scikit-leam classification model to pro

S-Grade

Practice All PMLE Questions

Access 65 questions with complete answers and detailed explanations.

View Full PMLE Practice Test →

← Back to PMLE Study Guide