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 has trained a linear regression model in BigQuery ML to predict customer transaction amounts. The analyst executes the ML.EVALUATE SQL function on an evaluation dataset to assess the model's predictive accuracy.
Which metric returned by the evaluation function measures the average absolute difference between target values and predicted values, where a lower score indicates better model performance?
Precision is a classification evaluation metric that measures the ratio of true positive predictions to the total number of positive predictions made by the model ($ ext{Precision} = rac{ ext{TP}}{ ext{TP} + ext{FP}}$).
The question asked for a classification metric that evaluates the percentage of predicted positive instances that were truly positive, where higher scores reflect higher model accuracy.
A Confusion Matrix is a structured diagnostic table used to evaluate the performance of classification models by cross-tabulating actual categorical classes against model-predicted classes.
The question involved evaluating a binary or multi-class classification model and required identifying a table that visualizes how frequently distinct classes are correctly predicted versus confused with other categories.
R-squared ($r^2$), also known as the coefficient of determination, measures the proportion of variance in the dependent target variable that is predictable from the independent feature variables.
The question asked for a regression metric ranging between 0 and 1 that represents the proportion of variance explained by the model, where higher values indicate a closer fit.
Mean Absolute Error (MAE) is a fundamental evaluation metric used in regression tasks to measure the average magnitude of errors between predicted values and actual target labels. It is calculated by taking the arithmetic average of the absolute differences across all observed and predicted data points, treating over-predictions and under-predictions equally.
ML.EVALUATE on a regression model, BigQuery automatically returns mean_absolute_error alongside other standard regression metrics.MAE directly satisfies the criteria of calculating the average absolute error magnitude where smaller scores represent superior model accuracy, making it the correct metric for regression model evaluation in this scenario.
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