CERTIFIED-DATA-ANALYST-ASSOCIATE · Question #90
CERTIFIED-DATA-ANALYST-ASSOCIATE Question #90: Real Exam Question with Answer & Explanation
The correct answer is D: Data blending. Data blending is the process of combining data from multiple sources into a single, unified dataset - exactly what the analyst is doing by merging two complementary sources for ongoing team use. Last-mile ETL (A) refers to the final transformations needed to prepare data for a sp
Question
A data analyst has two data sources that are providing similar but complementary information. The analyst wants to combine these sources of data into a single, comprehensive dataset for ongoing use for their team in a variety of different projects. Which terms is used to describe this type of work?
Options
- ALast-mile ETL
- BAd-hoc improvements
- CData testing
- DData blending
Explanation
Data blending is the process of combining data from multiple sources into a single, unified dataset - exactly what the analyst is doing by merging two complementary sources for ongoing team use. Last-mile ETL (A) refers to the final transformations needed to prepare data for a specific end-user or report, not the act of merging sources. Ad-hoc improvements (B) describes one-off, unplanned fixes rather than a defined data practice. Data testing (C) involves validating data quality and accuracy, not combining datasets.
Memory tip: Think of blending like a smoothie - you're taking distinct ingredients (data sources) and mixing them into one cohesive result. If you see "combine," "merge," or "two sources into one," think blend.
Community Discussion
No community discussion yet for this question.