nerdexam
Google

PROFESSIONAL-MACHINE-LEARNING-ENGINEER · Question #317

You work for a large retailer, and you need to build a model to predict customer churn. The company has a dataset of historical customer data, including customer demographics purchase history, and…

The correct answer is D. Create a logistic regression model in BigQuery ML. Use the ML.CONFUSION_MATRIX function to. Logistic regression is the appropriate choice for predicting customer churn, which is a binary classification problem. BigQuery ML supports evaluation of classification models using ML.CONFUSION_MATRIX, which provides key metrics like precision, recall, and accuracy - essential…

Submitted by devops_kid· Apr 18, 2026ML model development

Question

You work for a large retailer, and you need to build a model to predict customer churn. The company has a dataset of historical customer data, including customer demographics purchase history, and website activity. You need to create the model in BigQuery ML and thoroughly evaluate its performance. What should you do?

Options

  • ACreate a linear regression model in BigQuery ML, and register the model in Vertex AI Model
  • BCreate a logistic regression model in BigQuery ML, and register the model in Vertex AI Model
  • CCreate a linear regression model in BigQuery ML. Use the ML.EVALUATE function to evaluate the
  • DCreate a logistic regression model in BigQuery ML. Use the ML.CONFUSION_MATRIX function to

How the community answered

(57 responses)
  • A
    9% (5)
  • B
    2% (1)
  • C
    5% (3)
  • D
    84% (48)

Explanation

Logistic regression is the appropriate choice for predicting customer churn, which is a binary classification problem. BigQuery ML supports evaluation of classification models using ML.CONFUSION_MATRIX, which provides key metrics like precision, recall, and accuracy - essential for thorough performance evaluation in this context.

Topics

#Customer Churn Prediction#Logistic Regression#BigQuery ML#Model Evaluation

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-MACHINE-LEARNING-ENGINEER Practice