AWS Certified Data Analytics Specialty 2021 – Hands-On - AWS Glue DataBrew

Data Brew is a visual data preparation tool designed for transforming large datasets with ease. It offers over 250 transformations, including data cleaning and SQL-style operations, without requiring code. Users can create projects, define jobs, and apply transformation recipes to datasets. Data Brew integrates with security features and supports various output formats. The tool is cost-effective, with interactive sessions priced at $1.00 and job processing at $0.48 per node hour.

What is the primary purpose of Data Brew?

• To replace Glue Studio

• To graphically perform data transformations

• To create complex workflows

• To store data in S3

Which of the following is a feature of Data Brew?

• Creating directed acyclic graphs

• Building complex ETL pipelines

• Managing EC2 instances

• Defining data quality rules

What is required to create a new project in Data Brew?

• A custom SQL query

• An IAM role

• A Redshift cluster

• A CloudWatch alarm

Which transformation can be performed using Data Brew?

• Deploying web applications

• Filtering data by condition

• Running machine learning models

• Creating EC2 instances

How can missing values be handled in Data Brew?

• By creating a new IAM role

• By converting to JSON format

• By filling with the most frequent value

• By deleting the entire dataset

What file types can Data Brew output?

• DOCX, XLSX, PPTX

• MP3, WAV, FLAC

• HTML, XML, PDF

• CSV, Parquet, JSON

What is the cost of an interactive session in Data Brew?

• $0.50 per session

• $1.00 per session

• $2.00 per session

• $5.00 per session