A company needs to analyze a large dataset that is stored in Amazon S3 in Apache Parquet format. The company wants to use one-hot encoding for some of the columns. The company needs a no-code…

Question

Options

• AConfigure an AWS Glue DataBrew project that connects to the data. Use the DataBrew
• BConfigure an AWS Glue Data Catalog table that points to the data. Use Amazon Athena to write
• CConfigure an AWS Glue Data Catalog table that points to the data. Create an AWS Glue ETL
• DConfigure an Amazon Redshift cluster to access the data by using Redshift Spectrum. Use SQL

• A
  73% (27)
• B
  3% (1)
• C
  16% (6)
• D
  8% (3)

Explanation

AWS Glue DataBrew is a no-code, visual data preparation service purpose-built for non-programmers and scenarios requiring no scripting. It provides a point-and-click interface to connect to S3, apply over 250 built-in transformations including one-hot encoding, and write the results back to S3. This satisfies all requirements: no-code, Parquet support, one-hot encoding, and S3 output. AWS Glue ETL (C) requires writing Python or Scala scripts. Amazon Athena (B) requires SQL queries. Amazon Redshift with Redshift Spectrum (D) also requires SQL and additional infrastructure setup - none of these are 'no-code' solutions.

No community discussion yet for this question.