DA0-002 Visualization and Reporting Practice Question
In Tableau, an analyst wants to create a parameter that allows users to select a threshold for highlighting products with sales above that value. The parameter is used in a calculated field that returns TRUE if sales exceed the parameter value. Which type of calculated field is this?
⚠ Common exam trap
Many candidates confuse the output type (Boolean) with the computation method (table calc, aggregate, LOD). Candidates might see 'parameter' and think it's a table calculation because parameters are often used in table calculations, or they might think it's an aggregate because it involves sales, but the key is that the calculated field returns TRUE/FALSE, which is Boolean.
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
✓
Boolean calculation
A calculated field that returns TRUE or FALSE based on a condition is a Boolean calculation. In Tableau, Boolean calculated fields produce logical values (True/False) and are often used for filtering, highlighting, or conditional formatting. Here, the field compares Sales to a parameter value and returns TRUE when Sales exceeds the threshold, which is a classic Boolean expression. The parameter allows dynamic threshold selection, but the output type of the calculation is Boolean.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Table calculation
Why it's wrong here
Table calculations operate on values already in the view, such as running totals or percentages, and depend on the viz's partitioning. It is tempting because parameters often drive table calculations, but this field compares each row's sales to the parameter before aggregation, making it a basic row-level expression.
- ✗
Aggregate calculation
Why it's wrong here
Aggregate calculations apply functions such as SUM or AVG across rows, returning a single aggregated value rather than a row-level boolean. It is tempting because parameters often feed aggregate comparisons, but the field here evaluates each row's sales against the parameter, which is a basic row-level expression.
- ✗
Level of Detail expression
Why it's wrong here
Level of Detail expressions set the granularity of aggregation using FIXED, INCLUDE or EXCLUDE, not row-level comparisons. It is tempting because LODs also use parameters, but they return aggregated values at a specified dimension, whereas this field returns TRUE or FALSE per row against the threshold.
- ✓
Boolean calculation
Why this is correct
The calculated field returns TRUE or FALSE depending on whether sales exceed the parameter threshold, so its output is a Boolean data type. Tableau classifies such TRUE/FALSE expressions as Boolean calculations, matching the highlighting logic described.
About these practice questions
This DA0-002 question is part of Courseiva's 1,004-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. 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.