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 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
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
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
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
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
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
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
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
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
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
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
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.