Why D is the answer

AWS Glue DataBrew

DataBrew offers visual data preparation.

In detail

• DataBrew gives a visual, no-code way to clean data.
• Recipes can be reused.

See it in different ways

mindmap
  root((Transform))
    Glue
      Serverless Spark
      Job bookmarks
    EMR
      Custom tuning
    Lambda
      Small files
    DataBrew
      No code
    Redshift
      Stored procedures

flowchart LR
  S0["Connect dataset"] --> S1["Apply steps"] --> S2["Run the job"]

Why the other options are wrong

A. Amazon EMR Studio

EMR Studio is for developers.

B. AWS Glue Studio notebooks

Notebooks need code.

C. Amazon Athena

Athena needs SQL.

Related questions

• Question 12A team needs custom Spark tuning on very large clusters. Which service fits?
• Question 9You need Kafka-compatible streaming with minimal cluster administration on AWS. Which service fits?
• Question 10A nightly job must move data from an on-premises database to S3. Which service fits?
• Question 11You need serverless Spark ETL with no cluster to manage. Which service fits?

Learn more

• Our lesson: Ingestion and transformation
• Amazon Data Firehose
• Kinesis Data Streams