DEA-C01 AWS Certified Data Engineer – Associate Free Practice Questions and Answers

A data pipeline must run a crawler against SQL Server, load results to S3, and coordinate several AWS Glue jobs. Which orchestration option is most cost-effective for a Glue-native workflow?

• A. AWS Glue workflows
• B. Amazon Managed Workflows for Apache Airflow for every simple trigger
• C. AWS Step Functions polling every second
• D. A permanently running EC2 scheduler

A web application needs to submit SQL to Amazon Redshift without managing persistent JDBC connections. Which feature has low operational overhead?

• A. Amazon Redshift Data API
• B. A WebSocket connection to each Redshift node
• C. Amazon Route 53 health checks
• D. An S3 event notification

Different teams query the same S3 data with Athena. They need separate query histories, work settings, and output locations. What should the data engineer create?

• A. A separate Athena workgroup for each team or use case
• B. A separate AWS account for every query
• C. A CloudFront distribution per analyst
• D. An S3 bucket policy that disables Athena

A daily Glue job must finish eventually, but it does not need a fixed start or completion time. The team wants to reduce job cost. Which execution class should it consider?

• A. FLEX execution class
• B. A permanently running G.2X worker pool
• C. A Spot instance setting outside Glue
• D. STANDARD execution with the largest worker count

A Lambda function should convert uploaded CSV files to Parquet and run only for CSV uploads to an S3 bucket. What is a low-maintenance trigger?

• A. An S3 ObjectCreated event notification with a .csv suffix filter and Lambda destination
• B. A daily CloudWatch alarm that invokes Lambda for every bucket object
• C. An EventBridge rule matching all AWS service events
• D. A Route 53 record that points to Lambda