CERTIFIED-DATA-ANALYST-ASSOCIATE Question #21: Real Exam Question with Answer & Explanation

Question

A data organization has a team of engineers developing data pipelines following the medallion architecture using Delta Live Tables. While the data analysis team working on a project is using gold-layer tables from these pipelines, they need to perform some additional processing of these tables prior to performing their analysis. Which of the following terms is used to describe this type of work?

Options

• AData blending
• BLast-mile
• CData testing
• DLast-mile ETL
• EData enhancement

Explanation

D is correct because "last-mile ETL" specifically refers to the ad-hoc or supplemental data transformations that end users (like analysts) perform after consuming data from a formal pipeline - in this case, additional processing on top of gold-layer tables before analysis. It's the final leg of data preparation closest to the consumer's specific use case.

Why the distractors are wrong:

• A (Data blending) refers to combining data from multiple, often disparate sources - not downstream processing of already-prepared data.
• B (Last-mile) is too vague; while directionally related, "last-mile" alone is not the established technical term for this pattern - the ETL qualifier is essential.
• C (Data testing) describes validating data quality and correctness, not transforming data for analysis.
• E (Data enhancement) is a generic term sometimes used for enriching data with external sources; it doesn't capture the self-service, consumer-side transformation pattern described.

Memory tip: Think of "last-mile delivery" in logistics - the final, customized leg from a distribution hub (gold layer) to your front door (analyst's specific need). Just as that last step is handled differently for each customer, last-mile ETL is the consumer-owned, use-case-specific transformation that happens after the centralized pipeline ends.

No community discussion yet for this question.