A telecom company is building a BigQuery ML model that predicts customer churn from 150 numeric usage metrics. Model accuracy degrades because extreme magnitude differences across columns dominate the loss function. Data engineers decide to add an explicit preprocessing step in the CREATE MODEL statement instead of relying on automatic feature standardization. Which manual preprocessing function should they call in the TRANSFORM clause to scale every numeric feature to unit L2 norm without changing the feature count?
ML.NORMALIZER performs L2 normalization across each row (or feature vector), scaling the numeric values so that the square root of the sum of squared elements equals 1. This addresses magnitude disparities without adding new columns. ML.MAX_ABS_SCALER rescales values by their maximum absolute value, ML.ROBUST_SCALER rescales based on inter-quartile range, and ML.ONE_HOT_ENCODER expands categorical columns into multiple binary columns, so none of these meet the requirement to normalize all numeric features to unit length while preserving column count.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is L2 normalization?
Open an interactive chat with Bash
Why is automatic feature standardization insufficient here?
Open an interactive chat with Bash
How does `ML.NORMALIZER` differ from `ML.MAX_ABS_SCALER` and `ML.ROBUST_SCALER`?
Open an interactive chat with Bash
What is feature normalization in machine learning?
Open an interactive chat with Bash
What does L2 normalization accomplish?
Open an interactive chat with Bash
How does ML.NORMALIZER differ from other preprocessing functions like ML.MAX_ABS_SCALER or ML.ROBUST_SCALER?
Open an interactive chat with Bash
GCP Professional Data Engineer
Preparing and using data for analysis
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .