Transform and process data

23 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

23 total · page 1 of 1
DEA-C01 S-grade

Kinesis Data Firehose CSV to Parquet Conversion

This question tests the native data transformation capabilities of Amazon Kinesis Data Firehose. The correct solution leverages built-in format conver

19 comments
DEA-C01 S-grade

Troubleshooting Amazon Athena Queries with Date Extraction

This question addresses a common Athena query error where a numeric year filter fails because the source column is a date or timestamp type. The corre

17 comments
DEA-C01 S-grade

Most Cost-Effective AWS Glue ETL for Small Daily CSV Files?

Choosing the cheapest AWS service to run a daily ETL job over sub-100 MB CSV files uploaded to Amazon S3 comes down to matching compute overhead to da

14 comments
DEA-C01 A-grade

Optimizing AWS Glue Job Performance with S3 Partitioning and Scaling

Learn how to fix slow AWS Glue jobs by partitioning S3 data by date and scaling up worker types. This guide covers DEA-C01 best practices for improvin

7 comments
DEA-C01 A-grade

Cost-Effective One-Time Data Join Across Heterogeneous AWS Sources

Learn why Amazon Athena Federated Query is the most cost-effective solution for joining data from DynamoDB, RDS, Redshift, and S3 in a one-time analys

6 comments
DEA-C01 A-grade

How Do You Make Redshift Spectrum Queries on S3 the Fastest?

Redshift Spectrum query speed on an S3 data lake is driven overwhelmingly by how the files are laid out, not by compression tricks. This page confirms

6 comments
DEA-C01 S-grade

AWS Glue DataBrew NEST_TO_MAP Transformation

This question tests the use of AWS Glue DataBrew's NEST_TO_MAP transformation to consolidate multiple columns into a single JSON object with minimal c

6 comments
DEA-C01 A-grade

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

5 comments
DEA-C01 A-grade

How to Optimize Athena Queries on Partitioned S3 CSV Data?

This DEA-C01 question tests how to optimize Athena queries over date-partitioned CSV flight metrics in Amazon S3. The correct combination is same-Regi

5 comments
DEA-C01 A-grade

How to Ingest CSV into S3 for Cost-Effective Athena Queries?

Converting a 15-column CSV source into Apache Parquet with an AWS Glue ETL job lets Athena scan only the queried columns, making it the most cost-effe

5 comments
DEA-C01 A-grade

Athena INSERT INTO SELECT for Data Subset

This question tests the correct SQL syntax for copying a subset of data from an existing Amazon Athena table to a new or existing target table using t

5 comments
DEA-C01 S-grade

AWS Glue FindMatches for Data Deduplication

This question explores the most efficient method for deduplicating legacy data during an S3 migration, highlighting AWS Glue's built-in machine learni

5 comments
DEA-C01 A-grade

Implementing Automated Data Quality Checks with AWS Glue DataBrew

Learn how to perform automated data quality checks on IoT sensor data using AWS Glue DataBrew with minimal coding, focusing on completeness and range

4 comments
DEA-C01 A-grade

Optimizing Amazon Athena Query Performance with Parquet and Partitioning

Learn how to minimize Amazon Athena query times by converting CSV logs to Apache Parquet, partitioning by date, and leveraging predicate pushdown filt

4 comments
DEA-C01 A-grade

Apache Iceberg Automatic Compaction for Small Files

Apache Iceberg handles the small-files problem in Amazon S3 by using table properties to enable automatic compaction based on file size and count thre

4 comments
DEA-C01 A-grade

How to process only daily incremental S3 data in AWS Glue with least effort?

AWS Glue job bookmarks track previously processed S3 objects so an ETL job can read only daily incremental data with minimal code. This page confirms

4 comments
DEA-C01 A-grade

Which AWS solution detects changing schemas and loads data to S3 with least overhead?

This DEA-C01 scenario requires detecting undefined or changing schemas across SAP HANA, SQL Server, MongoDB, Kafka, and DynamoDB while loading transfo

4 comments
DEA-C01 A-grade

Least-Effort Way to Count Distinct Customers from an .xls File in S3?

For a 2 GB .xls customer file in Amazon S3, AWS Glue DataBrew provides the least operational effort to concatenate first and last names and count dist

4 comments
DEA-C01 A-grade

Create Empty Athena Table from Existing Schema

Learn how to create a new empty table in Amazon Athena with the same schema as an existing table using the CREATE TABLE AS SELECT (CTAS) statement com

4 comments
DEA-C01 A-grade

AWS Glue Catalog Views with Lake Formation and CloudTrail

This question tests implementing a data mesh architecture using AWS Glue Data Catalog multi-dialect views for cross-engine analytics, Lake Formation f

2 comments
DEA-C01 S-grade

Configuring Redshift IAM Roles for Glue UNLOAD

AWS Glue reads from Amazon Redshift by issuing an UNLOAD command to S3, requiring the Redshift cluster to have an IAM role with permissions to write t

2 comments
DEA-C01 A-grade

Automated Data Ingestion and Obfuscation with AWS Glue

This page explains how to use AWS Glue for least-overhead automated ingestion and sensitive data obfuscation from S3 to Redshift. The correct solution

1 comment
DEA-C01 A-grade

AWS Lake Formation Cross-Account Data Sharing and Governance

Learn how to securely share sensitive S3 datasets across AWS accounts using AWS Lake Formation for governance, discovery, and lineage tracking.

1 comment