# Associate-Data-Practitioner — Question 424

**Type:** multiple_choice
**Topics:** topic_1

## Question

Your retail company wants to predict customer churn using historical purchase data stored in BigQuery. The dataset includes customer demographics, purchase history, and a label indicating whether the customer churned or not. You want to build a machine learning model to identify customers at risk of churning. You need to create and train a logistic regression model for predicting customer churn, using the customer_data table with the churned column as the target label. Which BigQuery ML query should you use?

## Correct Answer

_See scenario._

## Explanation

Selected Answer: B
You can use SELECT * EXCEPT (foo) and SELECT foo AS bar.

**Reference:** examtopics_top_comment

---
Source: https://hiexam.net/q/google/Associate-Data-Practitioner/424  
Practice (tracked): https://hiexam.net/study/Associate-Data-Practitioner/practice