AWS Certified Data Engineer Associate DEA-C01 Practice Question
Your company gets JSON clickstream files in Amazon S3 every 5 minutes. You need to automate a pipeline that 1) runs an AWS Glue job to convert the data to partitioned Parquet and 2) runs an Amazon Athena query to create a daily aggregate. The workflow must include retries, conditional branching, a visual editor, no server management, and low operational overhead. Which solution meets these needs?
Create AWS Glue event triggers that start the ETL job on each S3 PUT and use an S3 event to invoke a Lambda function that runs the Athena query.
Use Amazon EventBridge Scheduler to run the Glue job and the Athena query as separate cron schedules.
Configure AWS Step Functions to invoke the Glue StartJobRun API, wait for completion, then call Athena StartQueryExecution.
Deploy Amazon MWAA and write an Apache Airflow DAG that calls the Glue job followed by the Athena query.
AWS Step Functions is a fully managed, serverless orchestrator that natively integrates with more than 200 AWS APIs, including Glue StartJobRun and Athena StartQueryExecution. A state machine can be configured so the Athena task runs only if the Glue task succeeds, and built-in error handling provides automatic retries or fallback branches. Step Functions offers a graphical console for building and monitoring the workflow and requires no environment management. Glue triggers coupled with S3 events lack orchestration features such as conditional flow and unified monitoring. Amazon MWAA delivers rich DAG capabilities but provisioning, scaling, and patching an Airflow environment increase operational effort. Running separate EventBridge schedules would not ensure the Athena query waits for the ETL job to finish and offers no centralized retry logic.
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
What is Parquet, and why use it in ETL jobs?
Open an interactive chat with Bash
What is Amazon Athena StartQueryExecution API?
Open an interactive chat with Bash
AWS Certified Data Engineer Associate DEA-C01
Data Operations and Support
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 .