hiexam
google · Associate-Data-Practitioner · Q424 · multiple_choice · topic_1

Your retail company wants to predict customer churn using historical purchase data stored in BigQuery. The dataset incl…

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?
  • A.-------------------------
  • B.-------------------------
  • C.-------------------------
  • D.-------------------------
Explanation
Selected Answer: B You can use SELECT * EXCEPT (foo) and SELECT foo AS bar.

Reference: examtopics_top_comment

Practice with progress tracking

Sign in to track wrong answers, get spaced-repetition reminders, and run timed exam mode.