Data Governance1 / 5
A company wants to monitor data quality in its ETL pipeline in real-time. Which approach is MOST effective for automated data quality monitoring?
CorrectIncorrect
Alex
Automated validation rules embedded in the ETL pipeline can catch quality issues during processing, before bad data reaches reports. These include null checks, type validation, range checks, uniqueness constraints, statistical anomaly detection (row count shifts, distribution drift), and business rule enforcement. Tools like Great Expectations, dbt tests, AWS Glue Data Quality, and Monte Carlo automate checks and alert on threshold breaches (CompTIA Data+ Data Governance domain; DAMA DMBOK Ch. 13). Why not the others? Full backups protect against data loss, not quality issues, and they preserve bad data too. Reviewing only when users report problems is reactive, so damage has often already occurred. Monthly manual spot checks can miss issues between reviews and don't scale. Exam tip: proactive = automated rules + real-time alerts; reactive = user complaints + infrequent manual reviews.
Sourcedocs.aws.amazon.com
Follow-up answers are available in the app. Create a free account — no credit card required.
Question 1 of 5
Create a free account