A multinational corporation has discovered that its customer database contains duplicate records, outdated address information, and inconsistent formatting across different regional branches. Which data maintenance practice would BEST address these issues?
Data normalization
Data cleansing
Data compression
Data encryption
Data cleansing is the BEST answer because it specifically addresses the issues described in the scenario: duplicate records, outdated information, and inconsistent formatting. Data cleansing is the process of detecting and correcting (or removing) corrupt, inaccurate, or irrelevant records from a dataset. This process involves identifying incomplete, incorrect, inaccurate, or irrelevant parts of the data and then replacing, modifying, or deleting this dirty data to improve data quality.
While data normalization (standardizing data formats) would help with the inconsistent formatting issue, it doesn't address the duplicate records or outdated information problems comprehensively. Data compression is about reducing storage requirements, not fixing data quality issues. Data encryption focuses on protecting the confidentiality of data, but doesn't address the data quality problems described in the scenario.
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
All IT & Cybersecurity Package plans include the following perks and exams .
Our pricing is simple. Full access to all certifications and exams in each package, for one price.
As many practice tests for as many topics as you want.
Use study mode non-stop, no limits.
Access to our AI assistant, Bash, trained to help you pass your exam.
Track your scores over time in study mode and report cards.
See how you improve over time, and where you need to focus.
Access our store with even bigger discounts than before.
Unlimited access to all performance questions and be prepared for the real thing.
All IT & Cybersecurity Package plans include unlimited access to the following study materials.
Create an account or sign in to access our study materials.