Ultimate access to all questions.
You are tasked with developing a linear regression model in BigQuery ML to predict the likelihood of a customer purchasing your company's products. The model uses city names as a key predictive factor. What is the most efficient way to structure your data into columns for training and deploying the model with minimal coding effort?
Explanation:
The correct approach is B, which involves using SQL in BigQuery to apply one-hot encoding to the city column. This method efficiently converts categorical city names into binary columns, enabling the linear regression model to utilize city information as a predictive feature without unnecessary complexity.