Prepare and test your skills
Prepare and test your skills
Free sample question, answered and explained below. The Associate Data Practitioner practice bank has 1,156 more like it. Try 10 free: instant score, no account.
A data analyst at an e-commerce company needs to group customers into distinct behavioral segments based on features such as annual spending, visit frequency, and average order value. The dataset does not contain any historical segment labels or predefined target categories.
Which model type should the analyst specify in the CREATE MODEL statement using BigQuery ML?
ARIMA_PLUS)ARIMA_PLUS is a built-in time series forecasting model in BigQuery ML that decomposes and models sequential, time-stamped numerical data by accounting for trend, seasonality, holidays, and anomalous events.
ARIMA_PLUS predicts future chronological data points rather than grouping tabular entity profiles across multidimensional feature spaces.ML.FORECAST.time_series_timestamp_col) and a data value column (time_series_data_col).The goal was to forecast future daily or monthly total retail sales revenue for the e-commerce store over the upcoming holiday quarter.
KMEANS)K-means clustering is an unsupervised machine learning algorithm built directly into BigQuery ML. It partitions a dataset into a specified number ($k$) of distinct, non-overlapping clusters or segments based on the mathematical similarity and distance between feature values of individual data points.
MODEL_TYPE='KMEANS' inside the OPTIONS clause of a CREATE MODEL SQL statement without needing separate data export or external training infrastructure.input_label_cols).ML.CLUSTERS and ML.PREDICT.K-means clustering is the industry-standard algorithm within BigQuery ML for data segmentation and customer grouping tasks where ground-truth outcome labels are unavailable.
LINEAR_REG)Linear regression (LINEAR_REG) is a supervised machine learning algorithm designed to model the relationship between one or more independent predictor variables and a continuous numeric target variable.
The analyst needed to forecast an exact numerical value for each customer, such as predicting total spend over the next quarter based on prior transaction history.
LOGISTIC_REG)Logistic regression (LOGISTIC_REG) is a supervised machine learning model supported in BigQuery ML used to predict discrete categorical outcomes (such as binary or multiclass classification).
input_label_cols parameter in the CREATE MODEL statement.The business already had historical records with explicit labels (e.g., customer churn status as churned or active) and wanted to train a model to classify whether new incoming customers are likely to churn.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated