MLA-C02 practice question: Transforming data with Glue, EMR and Data Wrangler (2 of 2)
Data Preparation for ML and AI A free question from our original MLA-C02 practice exam. Try it, then open the answer to see why each option is right or wrong.
A logistics broker receives carrier invoices as CSV files from about 300 carriers. The files have inconsistent date formats, duplicated carrier names and missing currency codes, and the analytics team needs them cleaned before modeling.
The analysts do not write code, but they need to profile each dataset, apply cleaning steps visually and save the steps so they can rerun them each week.
Which AWS service best meets these requirements?
Choose one answer.
AA. AWS Glue Spark ETL jobs written in Python, with each cleaning step coded by a data engineer and scheduled to run weekly with an AWS Glue trigger.
BB. Amazon EMR with a Hive cluster that analysts access through SQL notebooks they run themselves.
CC. Amazon Athena with CREATE TABLE AS SELECT statements that the analysts write by hand for each cleaning step.
DD. AWS Glue DataBrew, which profiles the datasets and lets analysts build recipes of visual cleaning steps that run as scheduled jobs.
Show the answer and explanation
Answer: D
A. Wrong: Glue is capable, but the steps would need code written by data engineers, which the analysts cannot maintain. The requirement is for analysts to work visually without code.
B. Wrong: Hive and SQL still require writing code, and the broker would manage a cluster for a task a managed visual service handles. The option does not meet the no-code requirement.
C. Wrong: Athena runs SQL, so the analysts would need to write statements, and profiling and visual steps are not part of the workflow. This option misses the no-code requirement.
D. Right: Correct. DataBrew provides a visual interface with profiling and many built-in transformations, and recipes can run as scheduled jobs. The analysts can rerun the saved steps each week without writing code. Learn more: What is AWS Glue DataBrew? (opens in a new tab)
Explanation
AWS Glue DataBrew lets analysts profile data and build reusable visual recipes that run as scheduled jobs, with no code. Spark jobs, EMR and Athena SQL all require code that the analysts do not write.
Want more on Transforming data with Glue, EMR and Data Wrangler? The 5 full-length practice sets have 8 more Transforming data with Glue, EMR and Data Wrangler questions, 325 in all, none of them in the free exam. One payment of $14.99, no subscription. See the practice sets →