Before loading incoming records into the warehouse, a team needs managed rule checks for completeness, uniqueness and value ranges on tables registered in the Data Catalog. Which AWS service provides these checks?
Show answer and explanation
Answer: B
AWS Glue Data Quality lets you define rulesets with checks such as completeness, uniqueness and value ranges, evaluate them against cataloged tables, and act on the results within a pipeline. Athena DDL only defines table metadata, Spectrum extends queries over S3 without validating rows, and CloudTrail records API activity rather than the contents of the records being loaded.
Why the other options are wrong
- A. Athena DDL statements define how tables map to S3 locations. They describe structure but do not evaluate rules against incoming records.
- C. Spectrum lets Redshift query S3 data in place. It does not run validation rules on each incoming record before it is loaded.
- D. CloudTrail records account API activity for auditing. It says nothing about whether the data inside the records is complete or valid.