DA0-002 Visualization and Reporting Practice Question
A data analyst is creating a dashboard in Looker Studio and needs to combine data from two different data sources using a common field. Which feature should be used?
⚠ Common exam trap
Candidates often confuse data blending with calculated fields or filters — candidates often think a calculated field can combine sources, but it only operates within one source; data blending is the only feature that joins multiple sources on a common key.
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
✓
Data blending
Data blending in Looker Studio allows you to combine data from multiple data sources into a single chart or table by joining them on a common dimension (key field). This is the correct feature when you need to merge data from two different sources, such as Google Analytics and Google Sheets, using a shared field like date or campaign ID.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Data blending
Why this is correct
Data blending joins two different data sources on a shared dimension key, producing a combined result without prior ETL. Looker Studio's blend feature satisfies the stem's constraint of combining sources via a common field, unlike extracting or joining within a single source.
- ✗
Community connector
Why it's wrong here
A community connector pulls data from an external platform into Looker Studio as one source; it does not join two existing sources on a common field. Connectors suit ingesting third-party data, while blending performs the required join.
- ✗
Filter
Why it's wrong here
Filtering restricts rows returned by a single data source; it cannot join two sources on a shared field, which is what blending or a blended data source accomplishes. Filtering is the right choice when you need to narrow one dataset's records by dimension values or date ranges, not to merge separate sources.
- ✗
Calculated field
Why it's wrong here
A calculated field derives new values from fields within a single data source; it cannot join two sources on a common field. It suits arithmetic, concatenation or CASE logic, whereas blending is the feature that combines sources by a shared dimension.
Go deeper
Related to this question
About these practice questions
One of 1,004 original DA0-002 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 →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official CompTIA exam blueprint
This DA0-002 practice question is part of Courseiva's free CompTIA 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 DA0-002 exam.