A marketing analytics team has raw customer exports with inconsistent date formats and blank cells. They want a point-and-click workspace where analysts can apply hundreds of ready-made cleaning steps and save the sequence as a reusable recipe, without writing any scripts. Which AWS service fits?
Show answer and explanation
Answer: A
DataBrew is a point-and-click cleaning tool in the AWS Glue family. Its library of more than 250 built-in transformations covers standardizing formats, filling missing values, and filtering rows, and the steps can be saved as a recipe and rerun on a schedule. Redshift Spectrum lets Redshift run SQL against S3 data but offers no visual cleaning workspace. Firehose delivers streaming data to destinations, and DMS moves database contents between systems.
Why the other options are wrong
- B. Redshift Spectrum extends Redshift queries to data in S3 using SQL. It assumes the analyst writes queries and does not offer a point-and-click library of cleaning transformations.
- C. Kinesis Data Firehose loads streaming records into destinations such as S3 or Redshift, optionally with a Lambda transform. It does not give analysts an interactive interface for fixing dates and blanks in exported files.
- D. Database Migration Service copies and replicates data between database engines with minimal downtime. It is aimed at migrations, not at interactive preparation of datasets for modeling.