Orchestrate data pipelines.
30 practice questions under this official exam objective (DEA-C01), each with the answer key, an option-by-option explanation and instant feedback.
Questions under this objective
30 total · page 1 of 2Orchestrating Long-Running Athena Queries Cost-Effectively
This question addresses the most cost-effective method to orchestrate a series of Amazon Athena queries that exceed the 15-minute limit. The correct s
AWS Glue Workflows vs Step Functions for ETL Orchestration
This question addresses the best practice for orchestrating AWS Glue and EMR ETL workflows with minimal operational overhead. It clarifies that while
AWS Glue Job vs Crawler for SQL Server Migration
This question evaluates the operational efficiency of using AWS Glue Jobs versus Crawlers for migrating SQL Server data to Parquet format in S3. It es
AWS Glue Job Bookmarks Reprocessing Cause
This page explains why an AWS Glue job reprocesses S3 files despite bookmarks being enabled, focusing on the critical role of the commit statement in
AWS Glue Triggers and Connections for ETL Pipelines
This page explains how to minimize operational overhead in AWS Glue ETL pipelines by using native triggers for scheduling and connections for secure d
AWS Glue Workflow for Schema-Aware Redshift ETL
This page explains how to build a robust AWS Glue workflow that handles schema evolution by integrating crawlers with jobs, ensuring correct data load
Athena Federated Query for Multi-Source Iceberg Pipelines
This question evaluates the ability to select AWS services for aggregating heterogeneous data sources into an S3 data lake with minimal operational ov
Which Step Functions State Parallel Processes a Collection of Data Files?
AWS Step Functions uses the Map state to iterate over a collection of items such as S3 data files and run the same transformation steps on each one co
Which AWS service most cost-effectively orchestrates an Amazon EMR ETL pipeline?
Amazon EMR ETL pipelines that pull from multiple sources need an orchestrator that can sequence EMR steps and other AWS services. AWS Step Functions i
Least Latency for AWS Glue Data Catalog Synchronization
This question tests the method for synchronizing the AWS Glue Data Catalog with Amazon S3 partitions to achieve the least latency. The correct solutio
How to Process Multi-Region EFS Data in One Region with Least Effort?
Amazon EFS replication can copy each Regional file system into the data science team's Region so Lambda functions mount local replicas and process the
AWS Service for Cost-Effective SQL Server Migration
This question evaluates the selection of AWS Database Migration Service (DMS) for migrating on-premises Microsoft SQL Server data to Amazon RDS with m
How to Trigger a Lambda CSV-to-Parquet Conversion on S3 Upload?
An S3 event notification with the s3:ObjectCreated:* event type plus a .csv suffix filter can invoke a Lambda function directly, which is the lowest-o
How Do You Schedule a Redshift Stored Procedure Daily Cost-Effectively?
Amazon Redshift query editor v2 supports scheduled queries, so a stored procedure can run daily without standing up extra compute. For a non-mission-c
Most cost-effective AWS Glue execution class for daily non-urgent jobs?
AWS Glue FLEX execution class runs non-urgent daily Glue jobs on spare capacity at a lower price than STANDARD, making it the most cost-effective opti
Which AWS service cost-effectively orchestrates Glue crawler and ETL to S3?
AWS Glue workflows are the most cost-effective way to orchestrate a Glue crawler over Microsoft SQL Server and the downstream ETL job that writes to A
Orchestrating AWS Lambda and Glue with Least Overhead
This question tests the selection of the optimal orchestration service for mixed AWS workloads. Step Functions provides a serverless, managed workflow
How Should MWAA DAGs Orchestrate Daily and Archived S3 Transformations?
This DEA-C01 scenario asks which two tasks an Amazon MWAA DAG should schedule to handle daily 300 GB transformations and a one-time terabyte-scale arc
How to Auto-Start a Glue Workflow After S3 File Gateway Transfers?
This DEA-C01 question tests automatic AWS Glue workflow orchestration after S3 File Gateway uploads. The page establishes that an Amazon EventBridge r
Optimizing Kinesis Data Streams with Enhanced Fan-Out and PutRecords
This question evaluates the optimal strategy for ingesting high-volume mobile gaming data into Amazon Kinesis Data Streams while ensuring dedicated th