DA0-002 Visualization and Reporting Practice Question
A sales analyst is building a report to analyze quarterly performance. Which THREE are appropriate uses of a formula language or a data transformation tool? (Select three.)
⚠ Common exam trap
Vendor-neutral exams often test the distinction between data transformation tools and data analysis functions, leading candidates to mistakenly think that analysis functions like iterative summations can perform data cleaning tasks, when in fact they are for analytical calculations within the data model.
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
✓
Using a data transformation tool to remove duplicate rows from the data source
Data transformation tools are specifically designed for data cleaning and preparation tasks, such as removing duplicate rows from a data source before the data is loaded into the analysis model. This is a standard ETL operation that such tools handle efficiently using their deduplication features, which is not a function of a formula language.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Using an iterative summation function to sum a column without using iteration
Why it's wrong here
The statement is incorrect because SUMX inherently performs iteration, evaluating an expression for each row of a specified table before summing the results. Its primary purpose is to enable row-context calculations within an aggregation, such as calculating total sales by multiplying quantity and price per transaction. If the requirement was simply to sum an existing column directly, without needing row-by-row evaluation, the SUM function would be the appropriate choice, as it aggregates a column in its entirety.
- ✓
Using a data transformation tool to remove duplicate rows from the data source
Why this is correct
Power Query is ideal for data cleaning and transformation.
- ✓
Using a year-to-date calculation function to calculate year-to-date sales
Why this is correct
TOTALYTD is a time intelligence function for YTD calculations.
- ✓
Using a function that modifies filter context to change the filter context in a measure
Why this is correct
CALCULATE is a core DAX function for modifying filters.
- ✗
Using a lookup function to create a calculated column from a related table
Why it's wrong here
RELATED retrieves a value from a related table, but it's not typically used for measures. However, it can be used in calculated columns; but the question asks for appropriate uses in the context of a report; RELATED is less common for performance measures. Given three correct options, E is less essential than the others.
Go deeper
Related to this question
About these practice questions
One of 986 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 by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
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.