AWS Certified Data Engineer Associate DEA-C01 Practice Question
A company lands compressed CSV files in an S3 bucket. A data engineer needs a serverless workflow that automatically performs these steps:
Run an AWS Glue crawler to update the table schema.
Trigger an AWS Glue ETL job to convert the data to Parquet.
Execute a COPY command to load the Parquet files into Amazon Redshift. The solution must provide built-in retry with exponential backoff, allow parameters to pass between steps, and retain a detailed execution history for auditing. Which service should the engineer use to orchestrate this workflow?
Write a series of AWS Lambda functions that call one another via SNS topics, implementing custom retry logic and logging.
Build an AWS Glue Workflow that chains the crawler and ETL job, then calls the Redshift COPY command as a final action.
Create an AWS Step Functions state machine that invokes the crawler, ETL job, and a Lambda function that issues the Redshift COPY command.
Configure an Amazon EventBridge rule to sequentially trigger the crawler, ETL job, and Redshift COPY operation by specifying targets in order.
AWS Step Functions is designed for coordinating multiple AWS services in a single workflow. It natively supports retries with exponential backoff, JSON-based parameter passing, and a complete execution history that can be reviewed for compliance. Glue Workflows can orchestrate only Glue crawlers and jobs; it cannot directly run Redshift SQL commands without additional services. An EventBridge rule or Scheduler can invoke targets but does not maintain multi-step state or detailed histories. Building custom logic with chained Lambda functions would require the engineer to code retry logic and persistence, increasing operational effort compared with the managed capabilities of Step Functions.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is AWS Step Functions?
Open an interactive chat with Bash
How does AWS Glue integrate with Step Functions?
Open an interactive chat with Bash
What is exponential backoff in AWS Step Functions?
Open an interactive chat with Bash
AWS Certified Data Engineer Associate DEA-C01
Data Ingestion and Transformation
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .