Least Overhead ETL to Redshift

DEA-C01 By islever Editorial Last updated

Automate data processing by using AWS services.

Short answer

B Use AWS Glue DataBrew to prepare the data and AWS Glue to load it into Amazon Redshift for analytics with minimal operational overhead.

Question

A data engineer is processing and analyzing multiple terabytes of raw data that is in Amazon S3. The data engineer needs to clean and prepare the data. Then the data engineer needs to load the data into Amazon Redshift for analytics. The data engineer needs a solution that will give data analysts the ability to perform complex queries. The solution must eliminate the need to perform complex extract, transform, and load (ETL) processes or to manage infrastructure. Which solution will meet these requirements with the LEAST operational overhead?
  1. Use Amazon EMR to prepare the data. Use AWS Step Functions to load the data into Amazon Redshift. Use Amazon QuickSight to run queries.
  2. Use AWS Glue DataBrew to prepare the data. Use AWS Glue to load the data into Amazon Redshift. Use Amazon Redshift to run queries. Correct Answer
  3. Use AWS Lambda to prepare the data. Use Amazon Kinesis Data Firehose to load the data into Amazon Redshift. Use Amazon Athena to run queries.
  4. Use AWS Glue to prepare the data. Use AWS Database Migration Service (AVVS DMS) to load the data into Amazon Redshift. Use Amazon Redshift Spectrum to run queries.

Key Takeaways

The key is identifying 'serverless' tools that handle both transformation (DataBrew) and orchestration/loading (Glue) without manual infrastructure management.

AWS Glue DataBrew and AWS Glue provide a serverless solution for data preparation and loading into Amazon Redshift, eliminating the need to manage infrastructure or perform complex custom ETL coding.

Common mistake: Candidates often choose D because they overlook that AWS DMS is primarily for database-to-database migration and does not natively support S3 as a direct source for schema-less raw data without additional glue code.

Expert Analysis

Why the Answer Is Correct

Option B is correct because it leverages fully managed, serverless services. AWS Glue DataBrew is a visual data preparation tool that requires no code and handles cleaning/transformation efficiently. AWS Glue provides serverless ETL jobs to load this prepared data into Amazon Redshift. This combination eliminates infrastructure management (EC2/EMR) and reduces operational overhead compared to other options.

Why the Other Options Are Wrong

Option A uses Amazon EMR, which requires managing clusters (even if using EMR Serverless, it's more complex than Glue for simple tasks) and Step Functions adds orchestration overhead. Option C suggests using Lambda for terabytes of data, which hits memory/time limits, and Athena is for querying S3 directly, not running queries on loaded Redshift data as implied by the workflow. Option D claims DMS supports S3; while recent updates allow some S3 integration, it is not the standard pattern for general-purpose data cleaning/prep like Glue DataBrew, and DMS is typically for homogeneous/heterogeneous DB replication.

Community Comment Notes

One user noted that DMS does not support S3 as a source in the context of this exam question, validating why D is incorrect. Another user emphasized that Redshift allows for 'complex' queries, supporting the use of Redshift as the analytics engine in option B. The community consensus leans heavily towards B due to the 'least operational overhead' requirement favoring fully managed services.

Exam Strategy

When asked for 'least operational overhead', prioritize Fully Managed/Serverless services (Glue, Lambda, Fargate) over self-managed or cluster-based ones (EMR, EC2). For data prep, look for specific tools like DataBrew or Glue Studio before writing custom code.

Frequently Asked Questions

Why isn't AWS DMS used for loading from S3?

AWS DMS is designed for migrating data between databases. While it has some S3 capabilities, Glue is the native, serverless choice for general ETL from S3 to Redshift.

Can I use Lambda for terabytes of data?

No, Lambda has strict time and memory limits (max 15 mins, 10GB RAM). It is unsuitable for processing terabytes of raw data.

More DEA-C01 FAQ →

Community Votes

B
67%
D
33%

67% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 4 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 4

  1. teo2157 👍 1 Answered B
    It can´t be D as DMS doesn´t support S3 as a source, it's B as it achieve all the goals described in the subject.
  2. catoteja 👍 1 Answered B
    B. They can do the "complex" queries in redshift.
  3. seouk 👍 1 Answered D
    the LEAST operational overhead ...
  4. phkhadse 👍 2
    Option B

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Amazon Redshift Compound Sort Key Query Optimization

S-grade

Secure Redshift Spectrum Access with VPC Endpoints

S-grade

Athena Federated Query for Multi-Source Iceberg Pipelines

S-grade

Reclaiming Storage in Amazon Redshift Materialized Views

S-grade

Practice All DEA-C01 Questions

Access 100 questions with complete answers and detailed explanations.

View Full DEA-C01 Practice Test →

← Back to DEA-C01 Study Guide