Courseiva
Data Operations and SupporteasyMultiple ChoiceObjective-mapped

DEA-C01 Data Operations and Support Practice Question

A company uses Amazon S3 to store raw data and AWS Glue to run ETL jobs. The data is partitioned by date in the format 'year=YYYY/month=MM/day=DD'. A new data source started sending data with a different date format 'YYYY-MM-DD'. The Glue crawler is configured to create a single table for the entire bucket. The crawler runs daily, but it is not detecting the new partitions from the new data source. The existing partitions are in the format 'year=2024/month=05/day=10', while the new data is stored as '2024-05-10/' without the key-value structure. How should the engineer modify the data pipeline to include the new data?

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

Modify the new data source to store data in the same Hive-style partition format as the existing data.

The new data uses a flat date folder (YYYY-MM-DD) instead of the existing Hive-style partition layout (year=YYYY/month=MM/day=DD). AWS Glue crawlers expect Hive-style partitions to automatically infer partitions. To include the new data without breaking the existing pipeline, the simplest solution is to store the new data in the same Hive-style format as the existing data. Option A is incorrect because partition indexes help with query performance, not with partition format mismatch. Option B is incorrect because custom classifiers affect schema inference, not partition structure. Option D is incorrect because converting to Parquet does not change the partition folder structure.

Answer analysis

Option-by-option breakdown

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

  • Run the crawler with the 'Create partition indexes' option enabled.

    Why it's wrong here

    Partition indexes improve query performance, not detection.

  • Configure the crawler to add a custom classifier for date formats.

    Why it's wrong here

    Classifiers are for file format, not partition structure.

  • Modify the new data source to store data in the same Hive-style partition format as the existing data.

    Why this is correct

    Consistent partition structure enables the crawler to detect partitions.

  • Convert the new data to Parquet format.

    Why it's wrong here

    File format does not affect partition detection.

Quick reference

AWS S3 Storage Class Comparison

Storage ClassMin DurationRetrievalUse Case
S3 StandardNoneImmediateFrequently accessed data
S3 Standard-IA30 daysImmediateInfrequent access, rapid retrieval
S3 One Zone-IA30 daysImmediateNon-critical infrequent data
S3 Intelligent-TieringNoneImmediate–hoursUnknown or changing access patterns
S3 Glacier Instant90 daysMillisecondsArchive with instant retrieval
S3 Glacier Flexible90 daysMinutes–hoursArchive, flexible retrieval
S3 Glacier Deep Archive180 daysHoursLong-term compliance archive

About these practice questions

Courseiva writes every DEA-C01 question from scratch — 1,711 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This DEA-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DEA-C01 exam.