Skip to content

Classification Drill

Fill every blank before reading the answers.

  1. Phone number matches approved format but belongs to a different customer → ______
  2. Mandatory customer email is blank → ______
  3. ORDER.CUSTOMER_ID has no matching Customer parent → ______
  4. Feed arrives on schedule, but balances are two months old → ______
  5. Today’s correct balances arrive three hours after required 8 a.m. deadline → ______
  6. Same real customer stored twice under separate IDs → ______
  7. Two systems use same business meaning but conflicting status values → ______
  8. Daily transaction volume far outside plausible benchmark → ______
  9. Analyst explores null rates, distributions, patterns, relationships for first time → ______
  10. Team recalculates same approved DQ score daily and compares with threshold → ______
  11. Business says every U.S. customer must have ZIP Code → ______
  12. 97.5% of required ZIP Codes are populated → ______
  13. At least 99% of required ZIP Codes must be populated → ______
  14. Severe unresolved issue routed to higher authority because of impact/duration → ______
  15. Supplier must correct critical defects within four business hours → ______
  16. Free-form full-name string split into title/given/middle/surname → ______
  17. Tenn. and TN converted to approved representation → ______
  18. Postal address supplemented with geocode coordinates → ______
  19. Engine auto-fixes high-confidence records and routes ambiguous cases to Steward → ______
  20. UI validation and upstream process controls changed so defect is no longer created → ______

Answers

  1. Accuracy failure (may be valid yet inaccurate).
  2. Completeness failure.
  3. Integrity failure.
  4. Currency failure.
  5. Timeliness failure.
  6. Uniqueness/Deduplication failure.
  7. Consistency failure.
  8. Reasonableness failure.
  9. Data profiling.
  10. Measure and Monitor Data Quality.
  11. Data Quality rule aligned primarily to Completeness.
  12. Data Quality metric / measurement result.
  13. Acceptability threshold / standard.
  14. Escalation within DQ issue management.
  15. DQ SLA response/remediation commitment.
  16. Parsing.
  17. Standardization / transformation.
  18. Data enrichment.
  19. Manually-directed correction.
  20. Prevention / root-cause remediation.

Mastery rule: a correct label without the deciding reason is not enough. For every miss, state why the correct concept wins and why the nearest alternative loses.

← Rebuilds · Compression/Repair →