QuestionQ309
Data Ingestion and TransformationA company keeps CSV files in an Amazon S3 bucket. A data engineer must process the data in the CSV files and save the processed data to a new S3 bucket.
The process must:
- rename a column;
- remove specified columns;
- skip the second row of every file;
- create a new column from values in the first row of the data; and
- filter the results according to a numeric value in a column.
Which solution satisfies these requirements with the LEAST development effort?
- A Use AWS Glue Python jobs to read and transform the CSV files.
- B Use an AWS Glue custom crawler to read and transform the CSV files.
- C Use an AWS Glue workflow to build a set of jobs to crawl and transform the CSV files.
- D Use AWS Glue DataBrew recipes to read and transform the CSV files.
Community Discussion