In a January sales data report, which data quality inconsistency is present?

Enhance your skills with the CompTIA Data+ Certification Test. Engage with flashcards, tackle challenging multiple choice questions, complete with hints and explanations. Get yourself exam-ready now!

Multiple Choice

In a January sales data report, which data quality inconsistency is present?

The key idea is data duplication in transactional data. Duplication happens when the same transaction or record is entered more than once, so the same sale could be counted multiple times. In a January sales report, this leads to inflated totals, skewed averages, and misleading KPIs because the same data point is effectively repeated. This is a specific form of redundancy, but it’s the repeated-record nature of duplication that makes it the right diagnosis here. Missing values would show gaps, and outliers would be unusual data points rather than repeated ones; those don’t describe the issue in a January sales report as accurately as duplication does.

The key idea is data duplication in transactional data. Duplication happens when the same transaction or record is entered more than once, so the same sale could be counted multiple times. In a January sales report, this leads to inflated totals, skewed averages, and misleading KPIs because the same data point is effectively repeated. This is a specific form of redundancy, but it’s the repeated-record nature of duplication that makes it the right diagnosis here. Missing values would show gaps, and outliers would be unusual data points rather than repeated ones; those don’t describe the issue in a January sales report as accurately as duplication does.

More practice questions