A multinational corporation operating in North America, Europe, and Asia has just completed a merger and imported millions of customer records from three CRM systems into a central data warehouse. The consolidation revealed thousands of duplicate customer profiles, postal addresses that no longer match current postal standards, and variations in phone-number formatting by region. To improve data quality before the warehouse is used for analytics, which data maintenance practice would BEST address these issues?
Data cleansing is the BEST answer because it specifically targets the problems described: duplicate records, outdated information, and inconsistent formatting. Data cleansing involves detecting and correcting (or removing) corrupt, inaccurate, or irrelevant records to improve overall data quality. Data normalization focuses on structuring data and reducing relational anomalies but does not update obsolete content. Data compression merely reduces storage requirements, and data encryption protects confidentiality rather than data quality.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is data cleansing and why is it important?
Open an interactive chat with Bash
How is data normalization different from data cleansing?
Open an interactive chat with Bash
What are some common tools used for data cleansing?
Open an interactive chat with Bash
ISC2 CISSP
Asset Security
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .