A data scientist wants to use BigQuery ML for time-series forecasting. They need to evaluate model accuracy and compare different models. Which TWO BigQuery ML functions should they use?
Trap 1: ML.EXPLAIN_PREDICT
ML.EXPLAIN_PREDICT provides local explanations for predictions, not evaluation or comparison.
Trap 2: ML.FEATURE_IMPORTANCE
ML.FEATURE_IMPORTANCE is used for tree-based models to show feature importance, not for evaluation.
Trap 3: ML.TRAIN
ML.TRAIN is not a valid BigQuery ML function; model training is performed via CREATE MODEL statement.
- A
ML.EXPLAIN_PREDICT
Why wrong: ML.EXPLAIN_PREDICT provides local explanations for predictions, not evaluation or comparison.
- B
ML.PREDICT
ML.PREDICT generates forecasts, which are necessary for comparing model outputs.
- C
ML.FEATURE_IMPORTANCE
Why wrong: ML.FEATURE_IMPORTANCE is used for tree-based models to show feature importance, not for evaluation.
- D
ML.EVALUATE
ML.EVALUATE directly computes evaluation metrics like MAE, MSE, etc., enabling model comparison.
- E
ML.TRAIN
Why wrong: ML.TRAIN is not a valid BigQuery ML function; model training is performed via CREATE MODEL statement.