Which data cleansing operation involves checking for consistency across different data systems?

Question

BlackTom AI · Accepted Answer

Consistency checks compare and reconcile the same pieces of information across different data systems or datasets to ensure they match and do not contradict one another.

1) Relevant concepts:
- Data cleansing operations include tasks such as consistency checks, validation, verification, deduplication, normalization, and documentation.
- Consistency checks specifically look for agreement of values across systems or tables (for example, ensuring a customer’s address or account balance is the same in the billing system and the CRM).
- Validation ensures individual data items meet format, type, range, or business-rule constraints (e.g., an email matches an email regex, a date falls within an allowed range).
- Verification usually means confirming data against an authoritative external source or original documents (e.g., verifying an ID against a government database).
- Documentation records data provenance, definitions, and procedures, not the act of cross-system comparison.

2) Step-by-step reasoning:
- The question asks which operation “involves checking for consistency across different data systems.” That phrasing targets cross-system agreement.
- Option a, “Consistency checks,” explicitly names that activity: checking consistency across sources.
- Option b, “Validation,” focuses on whether a record conforms to rules and formats—typically intra-system checks—so it doesn’t capture the cross-system reconciliation emphasized by the question.
- Option c, “Verification,” implies confirming correctness (often against an authoritative source), which is related but distinct: verification can be single-source confirmation rather than comparing multiple systems for mutual consistency.
- Option d, “Documentation,” is about recording metadata and processes, not about performing comparisons.

3) Why the correct answer is correct:
- Consistency checks are designed to detect mismatches between systems (e.g., mismatched customer IDs, different statuses) and therefore directly fulfill the requirement in the question.

4) Why other options are incorrect (brief):
- Validation: checks format/rules, not cross-system agreement.
- Verification: confirms against an authoritative source, not necessarily cross-system consistency.
- Documentation: describes data/processes; not an operational check.

Conclusion: The correct answer is a. Consistency checks, which matches the provided answer.

Which data cleansing operation involves checking for consistency across different data systems?单项选择题

类似问题

A business analyst is improving data quality in a CRM system. Many customer records have missing or inconsistent information, such as incomplete addresses and duplicate entries. Which process should the analyst prioritize?

A retailer merges customer records from multiple systems before a targeted campaign. During review, analysts find duplicate names, inconsistent street abbreviations, and outdated addresses that would distort outreach results. Which step is most important before management trusts the analysis?

You own a bond that pays $64 in interest annually. The face value is $1,000 and the current market price is $1,021.61. The bond matures in 11 years. What is the yield to maturity?

Which of the following statements is CORRECT?

It will cost $9,600 to acquire an ice cream cart that is expected to produce cash inflows of $3,600 a year for three years. After the three years, the cart is expected to be worthless. What is the payback period?

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单