Essential Data Quality Checks: Remove Duplicates, Consistent Types, Handle Missing Values
Before training an Einstein Prediction model, a data analyst must perform data quality checks. Which THREE checks are most critical?
Quick Answer
The answer is checking for missing values in key fields, removing duplicates, and ensuring consistent data types. These three data quality checks are most critical before training an Einstein Prediction model because they directly prevent data leakage and model bias. Duplicate records, for instance, allow the model to see the same information in both training and validation splits, causing overfitting and inflated accuracy metrics, while missing values can skew predictions and inconsistent types break the model’s ability to interpret features. On the Salesforce AI Associate exam, this question tests your understanding of foundational data preparation—a common trap is focusing on advanced transformations instead of these basic hygiene steps. Remember the mnemonic “DCM”: Duplicates, Consistency, Missing—if any of these are off, your model’s performance is unreliable.
⚠ Common exam trap
Salesforce often tests the misconception that all features must be normally distributed, which is a requirement for some statistical tests but not for machine learning models like those in Einstein Prediction Builder, which can handle non-normal data via tree-based or ensemble methods.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Remove duplicate records that could cause data leakage
Duplicate records can cause data leakage by allowing the model to see the same or highly similar data in both training and validation splits, leading to overfitting and inflated performance metrics. Removing duplicates ensures that the model generalizes to unseen data rather than memorizing repeated instances.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Confirm that label distribution matches the target baseline
Why it's wrong here
This is about class balance, not data quality, and can be addressed during modeling.
- ✓
Remove duplicate records that could cause data leakage
Why this is correct
Duplicates can over-represent certain patterns.
- ✓
Verify consistent data types across records (e.g., all dates as Date)
Why this is correct
Inconsistent types cause import errors.
- ✗
Ensure all features follow a normal distribution
Why it's wrong here
Normality is not required for most models.
- ✓
Check for missing values in key fields
Why this is correct
Missing values can bias or break models.
Go deeper
Related to this question
About these practice questions
One of 753 original AI Associate practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
2 more ways this is tested on AI Associate
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A data analyst is evaluating data quality for an Einstein model. Which TWO dimensions are most critical for model accuracy?
medium- A.Uniqueness
- ✓ B.Accuracy
- C.Consistency
- ✓ D.Completeness
- E.Timeliness
Why B: Completeness (no missing values) and accuracy (correct values) are fundamental to model performance.
Variation 2. Refer to the exhibit. A data analyst runs a profile on a dataset and sees these statistics. Based on best practices, which action should be taken first?
easy- A.Impute the 500 missing values with the mean
- ✓ B.Remove the 200 duplicate records
- C.Remove the 50 outliers in the Amount field
- D.Skip all preprocessing and train the model directly
Why B: Duplicate records introduce bias and redundancy, leading to overfitting or skewed model performance. Removing duplicates is a standard first step in data preprocessing to ensure data integrity before handling missing values or outliers. In the context of the AI Associate exam, best practices prioritize deduplication early in the data cleaning pipeline.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This AI Associate practice question is part of Courseiva's free Salesforce certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the AI Associate exam.