MLA-C01 Data Preparation for Machine Learning Practice Test 2 — 15 Questions

Question 1

A data scientist is preparing a large dataset for training a binary classification model. The dataset has a severe class imbalance (95% negative, 5% positive). Which data preparation technique should the scientist use to address this imbalance without losing too much data?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

SMOTE (Synthetic Minority Over-sampling Technique). SMOTE (Synthetic Minority Over-sampling Technique) is the best choice because it generates synthetic examples for the minority class by interpolating between existing minority instances and their k-nearest neighbors, rather than simply duplicating data. This addresses the severe 95:5 class imbalance without losing data (as undersampling would) and without the overfitting risk of naive random oversampling. The synthetic samples help the model learn a more general decision boundary for the positive class.

Answer

Random undersampling of the majority class

Answer

Random oversampling of the minority class

Answer

Apply class weights during model training

Question 2

A machine learning engineer is preparing a dataset that contains both numerical and categorical features. The categorical features have high cardinality (e.g., zip code with thousands of unique values). Which technique is most appropriate for encoding these high-cardinality categorical features?

Accepted Answer

Target encoding. Target encoding is the most appropriate technique for high-cardinality categorical features because it replaces each category with the mean of the target variable for that category, effectively capturing the predictive signal while keeping the feature as a single numeric column. This avoids the dimensionality explosion of one-hot encoding and the arbitrary ordinality of label encoding, making it a common choice in gradient boosting frameworks like XGBoost or LightGBM for datasets with thousands of unique categories.

Answer

Label encoding

Answer

One-hot encoding

Answer

Frequency encoding

Question 3

A team is building a regression model on a dataset with missing values in multiple features. They decide to use a k-Nearest Neighbors (k-NN) imputer. The dataset has 100,000 rows and 50 features. Which step should the team take to ensure the imputation is efficient and accurate?

Accepted Answer

Standardize the features before applying k-NN imputation. Standardizing features before applying k-NN imputation is critical because k-NN relies on distance calculations (e.g., Euclidean distance). If features are on different scales (e.g., one feature ranges 0–1 and another 0–100,000), the distance metric will be dominated by the larger-scale feature, leading to biased neighbor selection and inaccurate imputation. Standardization (e.g., z-score scaling) ensures each feature contributes equally to the distance computation, improving both efficiency and accuracy.

Answer

Set k=1 to minimize bias

Answer

Use all 100,000 rows to find neighbors for each missing value

Answer

Use only the feature with missing values to find neighbors

Question 4

A data engineer is using Amazon SageMaker Data Wrangler to prepare a dataset. The dataset contains a column 'review_date' with timestamps. The engineer wants to extract the day of the week as a new feature. How should this transformation be performed in Data Wrangler?

Accepted Answer

Use the 'day_of_week' transform on the 'review_date' column. Amazon SageMaker Data Wrangler includes a built-in 'day_of_week' transform that directly extracts the day of the week (e.g., Monday, Tuesday) from a timestamp column without requiring custom code or additional formatting. This transform is optimized for Data Wrangler's visual interface and integrates seamlessly with its processing pipeline.

Answer

Write a custom Python script using pandas dt.day_name()

Answer

Use one-hot encoding on the timestamp

Answer

Use the 'extract' transform with format '%A'

Question 5

A company uses AWS Glue ETL jobs to transform data for machine learning. They have a dataset with a column 'income' that is heavily right-skewed. Which transformation should be applied to make the distribution more Gaussian-like?

Accepted Answer

Log transformation (natural log). A log transformation is appropriate for heavily right-skewed data because it compresses the long tail by applying a concave function, pulling extreme values closer to the mean and making the distribution more symmetric. In AWS Glue ETL, you can apply this using Spark SQL's `LOG` function or a Python UDF with `numpy.log`, which directly addresses the skewness to better approximate a Gaussian distribution for downstream ML models.

Answer

Standardization (z-score)

Answer

Min-max scaling to [0,1]

Answer

Equal-width binning

Question 6

A data scientist is working on a time series forecasting problem. The dataset contains a column 'sales' with occasional negative values due to returns. The model expects non-negative input. Which data preparation step should be taken?

Accepted Answer

Clip negative sales values to zero. Clipping negative sales values to zero directly addresses the model's requirement for non-negative input while preserving the data's temporal structure. This approach is appropriate for time series forecasting where returns cause occasional negative values, as it treats returns as zero sales rather than removing or distorting the data points.

Answer

Apply log transformation after adding a constant

Answer

Remove all rows with negative sales values

Answer

Impute negative values with the mean

Question 7

A team is using Amazon SageMaker Processing for data preprocessing. They have a Parquet dataset in Amazon S3. Which configuration will provide the most efficient reading of the dataset during processing?

Accepted Answer

Read the Parquet files directly using SparkSession.read.parquet. SageMaker Processing natively integrates with Apache Spark, and reading Parquet files directly via `SparkSession.read.parquet` leverages columnar storage, predicate pushdown, and compression (e.g., Snappy) to minimize I/O and deserialization overhead. This approach is far more efficient than text-based or format-conversion methods, as Parquet is optimized for analytical workloads and preserves schema information.

Answer

Read the Parquet files as text using SparkContext.textFile

Answer

Split the dataset into many small Parquet files (e.g., 1 MB each)

Answer

Convert the Parquet files to CSV before processing

Question 8

A machine learning engineer is preparing a dataset for a multiclass classification task. The dataset has 10 features and 100,000 rows. Which TWO techniques should the engineer use to reduce the risk of overfitting during data preparation?

Accepted Answer

Data augmentation (e.g., adding noise). Data augmentation (A) is correct because it artificially increases the diversity of the training set by adding noise or transformations, which helps the model generalize better and reduces overfitting. Feature selection using correlation analysis (E) is correct because it removes redundant or highly correlated features, simplifying the model and minimizing the risk of learning noise from irrelevant predictors.

Answer

SMOTE to balance classes

Answer

One-hot encoding of all categorical features

Answer

Log transformation of skewed features

Question 9

A team is preparing text data for a natural language processing (NLP) model. They have a corpus of customer reviews. Which THREE preprocessing steps are essential to reduce noise and improve model performance?

Accepted Answer

Remove punctuation and special characters. Punctuation and special characters (e.g., commas, exclamation marks) introduce irrelevant noise that does not carry semantic meaning for most NLP models. Removing them reduces vocabulary size and prevents the model from treating 'hello!' and 'hello' as distinct tokens, which improves generalization and reduces overfitting.

Answer

Apply one-hot encoding to each word

Answer

Compute TF-IDF vectors

Question 10

A retail company is preparing a dataset for a machine learning model to predict customer churn. The dataset includes customer_id, signup_date, last_purchase_date, total_purchases, average_order_value, and churn_label. The data scientist notices that the 'total_purchases' column has missing values for 15% of the records. The company wants to use AWS Glue for data preparation. Which approach should the data scientist take to handle the missing values while minimizing bias and preserving data integrity?

Accepted Answer

Use AWS Glue DynamicFrame to perform model-based imputation, predicting missing total_purchases using other features like average_order_value and signup_date.. Model-based imputation uses relationships between features (e.g., average_order_value and signup_date) to predict missing total_purchases values, minimizing bias compared to simple mean/median imputation. AWS Glue DynamicFrames support custom transformation logic, allowing you to implement a predictive model (e.g., using Spark MLlib) directly within the Glue ETL job. This approach preserves data integrity by leveraging existing data patterns rather than discarding records or introducing arbitrary constants.

Answer

Use AWS Glue DataBrew to fill missing values with the median of total_purchases.

Answer

Drop all records with missing total_purchases values.

Answer

Replace missing total_purchases with the mean of the non-missing values.

Question 11

A financial services company is building a fraud detection model using transactional data stored in Amazon S3. The data includes transaction_id, timestamp, amount, merchant_category, and fraud_label (0/1). The data is collected from multiple sources and has inconsistencies: timestamps are in different timezones (UTC and EST), merchant categories are sometimes misspelled (e.g., 'RESTAURANT', 'Restaurant', 'restaurant'), and the fraud_label is missing for about 5% of records. The data science team uses AWS Glue for ETL. They need to prepare a clean dataset for training. The final dataset must have consistent timestamps in UTC, standardized merchant categories, and no missing fraud labels. The team also wants to minimize data loss. Which set of actions should the team take?

Accepted Answer

Use AWS Glue to convert timestamps to UTC, use a mapping table to group similar merchant categories (e.g., all restaurant variants to 'Restaurant'), and impute missing fraud_label using mode (most frequent value).. It preserves data by imputing missing fraud labels using the mode (most frequent value), which is appropriate for a binary classification label where the majority class is likely 0. It also standardizes timestamps to UTC and uses a mapping table to group merchant category variants, ensuring consistency without data loss. Dropping records (as in A and C) would reduce the dataset size, and imputing with the mean (as in B) is invalid for a categorical label.

Answer

Use AWS Glue to convert all timestamps to UTC, apply a mapping function to correct merchant category misspellings to a standard list, and drop records with missing fraud_label.

Answer

Use AWS Glue to convert timestamps to UTC, use a fuzzy matching algorithm to standardize merchant categories, and replace missing fraud_label with the mean value (0.05).

Answer

Use AWS Glue to convert timestamps to UTC, correct merchant categories by mapping known misspellings to correct names, and drop records with missing fraud_label.

Question 12

A healthcare startup is building a model to predict patient readmission within 30 days. The data is stored in Amazon Redshift and includes patient demographics, admission history, lab results, and medication records. The data scientist extracts a sample of 10,000 records to Amazon S3 as CSV files for initial prototyping. During exploratory data analysis, they find that the 'age' column has values like '150', '0', and negative numbers. The 'diagnosis_code' column contains codes like 'E11', 'E11.9', and 'e11' (inconsistent formatting). The 'readmitted' target column has 60% 'Yes' and 40% 'No'. The data scientist wants to use AWS Glue DataBrew for data cleaning. Which combination of steps should they use?

Accepted Answer

In AWS Glue DataBrew: 1) Filter age between 0 and 120 to remove invalid values. 2) Standardize diagnosis_code to uppercase using a formula. 3) Apply Random Oversampling to balance the target column.. It uses AWS Glue DataBrew's built-in capabilities to filter invalid age values (0–120), standardize the diagnosis_code to uppercase via a formula, and apply Random Oversampling to address the 60/40 class imbalance. DataBrew supports filtering, formula-based transformations, and built-in ML transforms like Random Oversampling, making this combination valid and efficient for data cleaning.

Answer

In AWS Glue DataBrew: 1) Impute age with the mean. 2) Apply Standard Scaler to all numeric columns. 3) Use Random Oversampling to balance the target column.

Answer

In AWS Glue DataBrew: 1) Replace age with median. 2) Convert diagnosis_code to uppercase. 3) Apply SMOTE to balance the target column.

Answer

In AWS Glue DataBrew: 1) Remove rows where age is outside 0-120. 2) Drop diagnosis_code column. 3) Use Random Undersampling to balance the target column.

Question 13

An e-commerce company is building a recommendation system using user interaction data stored in Amazon DynamoDB. The data includes user_id, product_id, timestamp, event_type (click, add_to_cart, purchase), and session_id. The data science team exports the data to Amazon S3 as JSON files. During preprocessing, they discover that the 'event_type' field contains inconsistent values due to logging errors: 'Click', 'click', 'CLICK', and 'clck' all appear. Also, there are duplicate records where the same user_id, product_id, and timestamp appear multiple times with the same event_type. The team wants to use AWS Glue to clean the data for training a sequence-based recommendation model. Which set of actions should they perform?

Accepted Answer

Use AWS Glue to drop exact duplicate rows (all columns identical). Then apply a mapping function to standardize event_type to a controlled vocabulary (e.g., 'click', 'add_to_cart', 'purchase').. It addresses both data quality issues: first, dropping exact duplicate rows (all columns identical) removes redundant records that would bias the sequence model; second, standardizing event_type to a controlled vocabulary ensures consistent categorical input for ML training. AWS Glue's DynamicFrame with DropDuplicates and Map transformations are the appropriate tools for this ETL task.

Answer

Use AWS Glue to group records by session_id and aggregate event_types into a list per session. Then apply a mapping function to standardize event_type names.

Answer

Use AWS Glue to drop duplicate records based on all columns. Then drop the event_type column and use only numeric features for training.

Answer

Use AWS Glue to impute event_type with the mode for records with inconsistent values. Then drop duplicate records based on user_id, product_id, and timestamp.

Question 14

A data scientist is preparing a dataset for training a binary classification model. The dataset has 100,000 rows and 50 features. The target variable is imbalanced, with only 5% positive cases. Which technique should the data scientist apply to address the class imbalance BEFORE training?

Accepted Answer

Random oversampling of the minority class. Random oversampling of the minority class (Option B) directly addresses the class imbalance by duplicating examples from the positive class until the class distribution is more balanced. This prevents the binary classification model from being biased toward the majority class, which is critical when only 5% of the 100,000 rows are positive cases. Oversampling is applied before training to ensure the model sees sufficient minority examples during learning.

Answer

Principal Component Analysis (PCA) dimensionality reduction

Answer

Standard scaling of numerical features

Answer

One-hot encoding of categorical variables

Question 15

A machine learning engineer is building a pipeline to preprocess text data for a sentiment analysis model. The data consists of customer reviews. The engineer wants to convert the text into numerical features while preserving the semantic meaning of words. Which technique should be used?

Accepted Answer

Word embeddings (e.g., Word2Vec or GloVe). Word embeddings (like Word2Vec or GloVe) are dense vector representations that capture semantic relationships between words based on their context in a large corpus. For sentiment analysis, preserving semantic meaning (e.g., 'good' and 'excellent' having similar vectors) is critical, and embeddings directly encode this, unlike sparse or count-based methods.

Answer

One-hot encoding of each word

Answer

Bag-of-words with TF-IDF

Answer

Hashing vectorizer