DEA-C01 Data Operations and Support Practice Question

Network Topology

Refer to the exhibit. A data engineer runs a Glue ETL job that reads from a CSV file and writes to a Redshift table. The job fails with the error shown. What is the most likely cause?

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

The source CSV file has fewer columns than the target table.

The error indicates a column count mismatch. The source file has 10 columns but the target expects 12. Option B is wrong because the error is about column count, not data type. Option C is wrong because there is no mention of partition count. Option D is wrong because the error is about validation, not permissions.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✓
The source CSV file has fewer columns than the target table.
Why this is correct
Error says columns (10) does not match expected (12).
✗
The IAM role for the Glue job does not have permission to write to Redshift.
Why it's wrong here
Error is about data validation, not permissions.
✗
The target Redshift table has mismatched data types for some columns.
Why it's wrong here
Error mentions column count, not data type.
✗
The Glue job is using an incorrect number of partitions for the source data.
Why it's wrong here
Partitions are not related to column count.

Go deeper

DEA-C01 Data Operations and Support Practice Question

Why each option matters

Option-by-option breakdown

Related to this question