Box 1: Select Columns in Dataset

For Columns to be cleaned, choose the columns that contain the missing values you want to change. You can choose multiple columns, but you must use the same replacement method in all selected columns.

Example:

The task is to build a machine learning model in Azure Machine Learning designer to predict automobile prices, which is a regression problem since the output (price) is a continuous numeric value. The pipeline must follow the logical data preparation, training, and evaluation flow as outlined in the Microsoft Azure AI Fundamentals (AI-900) study guide and Microsoft Learn module “Create a machine learning model with Azure Machine Learning designer.”

Here’s the correct sequence and reasoning:

Select Columns in Dataset:The first step after loading the raw automobile dataset is to choose the relevant columns that will be used as features (inputs) and the label (output). This module ensures that only necessary fields (for example, horsepower, engine size, mileage, etc.) are used to train the model while excluding irrelevant columns like vehicle ID or serial number.

Split Data:Next, the cleaned and filtered dataset must be split into two subsets: training data and testing data (often 70/30 or 80/20). This allows the model to be trained on one portion and evaluated on the other to measure predictive accuracy.

Linear Regression:Since automobile price prediction is a numeric prediction task, the appropriate learning algorithm is Linear Regression. This supervised algorithm learns relationships between numeric features and the target (price).

Finally, the workflow connects the training data and Linear Regression module to the Train Model module, which outputs a trained regression model. The trained model is then linked to the Score Model module to compare predicted vs. actual prices.

This pipeline fully aligns with Microsoft’s recommended process for regression in Azure ML Designer.