Transform and process data.
16 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
16 total · page 1 of 1Kinesis 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
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
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
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
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
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 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
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
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
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
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
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
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
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
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
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.