Courseiva
← DEA-C01
Full test
Data Operations and Support →mediumMultiple ChoiceObjective-mapped

DEA-C01 Data Operations and Support Practice Question

Exhibit

SELECT COUNT(*) FROM my_table WHERE ds = '2023-01-01';

Query results:
1073741824 bytes scanned

SELECT COUNT(*) FROM my_table WHERE ds = '2023-01-01' AND product_id = 12345;

Query results:
1073741824 bytes scanned

Refer to the exhibit. A data engineer runs two queries on an Athena table partitioned by 'ds'. Both queries scan the same amount of data. What does this indicate?

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 partition column is not being used as a filter

If both queries scan the same amount of data despite being on a partitioned table, it indicates that the partition column 'ds' is not being used as a filter in the queries, so partition pruning is not applied and all partitions are scanned. Option A is correct because the partition column is not used as a filter. Option B is incorrect because the table does have partitions defined (it is partitioned by 'ds'). Option C is incorrect because the table is partitioned. Option D is incorrect because partition pruning is not working correctly; if it were, the amount of data scanned would differ based on the filter.

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 partition column is not being used as a filter

    Why this is correct

    The filter on ds is not being pushed down, possibly due to data type mismatch.

  • ✗

    The table does not have any partitions defined

    Why it's wrong here

    Partitions are defined.

  • ✗

    The table is not partitioned

    Why it's wrong here

    The table is partitioned by ds.

  • ✗

    Partition pruning is working correctly

    Why it's wrong here

    If it were, the second query would scan less data.

About these practice questions

One of 1,711 original DEA-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.