Get Your CertDEA-C01PlayCompete
‹ All DEA-C01 questions

DEA-C01 Practice Question 63: No Code Data Preparation Recipes

AWS Certified Data Engineer – Associate (DEA-C01) · Test 7 · question 3 of 10

Data Ingestion and Transformationmedium

Business analysts receive raw CSV files in Amazon S3 with inconsistent date formats, missing values and misspelled category names. They do not write code. The team wants them to explore the data visually, apply point-and-click cleaning steps, reuse the same steps on future files, and write the cleaned output back to S3, without managing any clusters. Which service should they use?

Select one answer
Show answer and explanation

Answer:

  • A. AWS Glue DataBrew

AWS Glue DataBrew is *"a visual data preparation tool that enables users to clean and normalize data without writing any code."* It offers more than 250 point-and-click transformations for tasks such as *"removing nulls, replacing missing values, fixing schema inconsistencies,"* saves steps as a recipe that can be reused with other datasets, writes prepared output to Amazon S3, and is serverless, so there are no clusters to manage (option A).

- B is wrong because a PySpark job requires programming skills, which the analysts do not have. - C is wrong because EMR Studio notebooks are code-based and require an EMR cluster (or EMR Serverless application) behind them. - D is wrong because CTAS statements require writing SQL and have no visual profiling or reusable recipe feature.

Reference: What is AWS Glue DataBrew?

Practice Test 7 ›

Study guides for DEA-C01

AWS Developer Associate exam guide: DVA-C02 to DVA-C03AWS Developer Associate exam: DVA-C02 ends 30 November 2026 and DVA-C03 starts 1 December. What changes, which to sit, format, price and study plan.
How AWS Certification Exams Work: Scoring and RenewalHow AWS certification exams work: levels, booking, question types, unscored questions, scaled scores, pass marks, validity and how recertification works.
What Is Amazon RDS? Multi-AZ, Read Replicas and BackupsWhat is Amazon RDS? Engines, Multi-AZ, read replicas, backups, RDS Proxy, Aurora and pricing explained, with the traps that AWS exams set around each one.
Microsoft Fabric certification: DP-700 vs DP-600Microsoft Fabric certification means two exams, DP-600 and DP-700. Their roles, skills, format, cost in India, and which one to take first.
Databricks Data Engineer Associate vs AWS DEA-C01Databricks Data Engineer Associate vs AWS Certified Data Engineer – Associate - format, cost, topics and which one to take for your job, as of 2026.
Which AWS certification should you get? 2026 roadmapWhich AWS certification to get first, by role and experience, with each exam's status in October 2026, what is changing, and prices in USD and INR.
What Is AWS Glue? Data Catalog, Crawlers and ETL JobsWhat is AWS Glue? The Data Catalog, crawlers, ETL jobs and DPUs, workflows, streaming, job bookmarks, Flex and Data Quality, plus the traps AWS exams set.