Question 20
You are auditing a “Sales Transaction” dataset. For true Beverage items, the “Product Category” column contains:
● “Bev.” in 40% of rows ● “Beverages” in 30% ● “Drinks” in 20% ● “Soft Drinks” in 5% ● Blank in 5%
Your BI dashboard defines “Beverage revenue” using: ● A filter: Product Category IN ("Beverages", "Drinks")
Last month, the dashboard reported ₹80 crore as “Beverage revenue.” You run a corrected query that groups all 4 labels together as “Beverage” and find actual Beverage revenue is ₹120 crore.
Which data quality dimension is the root cause of this ₹40 crore under-reporting?
Accuracy – because some non-beverage items may also be included in the report.
Completeness – because 5% of Beverage rows are blank in Product Category.
Consistency – because the same logical category is split across multiple labels that the filter does not fully capture.