Reviewed by Aditya Kumar Ā· Last reviewed 2026-03-24
**Situation**: Data quality directly impacts decisions. **Action**: (1) Validationāschema, null/range, referential integrity; (2) Dedupāconstraints, idempotency; (3) MonitoringāGreat Expectations, dbt tests; (4) Anomaly detectionāthresholds, volume checks; (5) Lineageātrace to...
Situation: Data quality directly impacts decisions.
Action: (1) Validationāschema, null/range, referential integrity; (2) Dedupāconstraints, idempotency; (3) MonitoringāGreat Expectations, dbt tests; (4) Anomaly detectionāthresholds, volume checks; (5) Lineageātrace to source. Transactional writes; exactly-once where possible. Fail fast on critical; quarantine bad; alert.
Pro-Move: 'dbt tests run in CI + nightly. We quarantine and alert; SLO: <0.1% invalid records. Lineage helped trace 3 incidents.'
According to DataEngPrep.tech, this is one of the most frequently asked General/Other interview questions, reported at 1 company. DataEngPrep.tech maintains an editor-reviewed database of 1,863 data engineering interview questions across 7 categories.