DA0-002 Data Concepts and Environments Practice Question
A retail company is merging customer data from three separate systems: an e-commerce platform, a point-of-sale (POS) system, and a loyalty program. The e-commerce platform stores customer names in "FirstName LastName" format, the POS system stores names as "LastName, FirstName", and the loyalty program stores names in separate "first_name" and "last_name" fields. The data analyst needs to create a unified customer master table. After initial merging, there are 20% more records than expected, including duplicates with slight name variations (e.g., "John Smith" vs "John A. Smith"). To ensure accurate consolidation, which data concept should the analyst prioritize applying first?
⚠ Common exam trap
A common mix-up: candidates confuse data profiling (which only identifies issues) with data standardization (which actively resolves format inconsistencies), leading them to choose A instead of B, even though profiling alone cannot fix the duplicate records caused by name variations.
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
✓
Data standardization
Data standardization is the correct first step because it resolves the inconsistent name formats (e.g., 'FirstName LastName', 'LastName, FirstName', and separate fields) into a single, consistent representation. By applying a standardized format (e.g., 'FirstName LastName'), the analyst can then accurately identify and merge duplicates like 'John Smith' and 'John A. Smith' using fuzzy matching or exact matching on the standardized values. This ensures the unified customer master table has the correct number of records without the 20% inflation caused by formatting variations.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Data profiling
Why it's wrong here
Profiling identifies data quality issues, but the immediate need is to standardize formats to enable consolidation.
- ✓
Data standardization
Why this is correct
Standardizing name formats to a common convention reduces variations and allows accurate matching and deduplication.
- ✗
Data indexing
Why it's wrong here
Indexing improves data retrieval performance but does not resolve format or duplication issues.
- ✗
Data encryption
Why it's wrong here
Encryption secures data, but does not address format inconsistencies or duplicates.
Visual reference
Go deeper
Related to this question
About these practice questions
Courseiva writes every DA0-002 question from scratch — 986 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DA0-002 practice question is part of Courseiva's free CompTIA 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 DA0-002 exam.