TABLEAU DESKTOP SPECIALIST LATEST
EVALUATION EXAMS QUESTIONS AND ANSWERS
SURE A+
✔✔When to use an extract? - ✔✔For performance, offline analysis, complex
calculations, or to isolate a subset of data.
✔✔What is a join? - ✔✔Combines tables horizontally by matching key fields (inner, left,
right, full).
✔✔What is a union? - ✔✔Stacks tables vertically (same structure/columns) to add rows.
✔✔What are relationships? - ✔✔Logical connections between tables that preserve their
native levels of detail and join only when needed in the viz.
✔✔When are relationships preferred over physical joins? - ✔✔When combining fact
tables with different grains or when avoiding row duplication/incorrect aggregations.
✔✔What is data blending? - ✔✔Combines data from multiple published/connected
sources at the aggregate level (primary and secondary sources).
, ✔✔How do you identify blending in a view? - ✔✔An orange chain link icon appears on
linked fields; secondary data has orange tick marks.
✔✔What is the default join type? - ✔✔Inner join.
✔✔What is a left join result? - ✔✔All records from left table; matching records from
right; unmatched right values are null.
✔✔What is a full outer join result? - ✔✔All records from both tables; unmatched values
from either side are null.
✔✔How do you create a union of multiple CSVs with the same schema? - ✔✔Drag one
file onto another in the Data Source canvas or use Wildcard (folder union) option.
✔✔What is a join clause vs. join type? - ✔✔Clause: how tables match (e.g., left.ID =
right.ID); Type: inner/left/right/full determining row inclusion.
✔✔What is a dimension? - ✔✔Categorical field used for slicing/grouping (e.g., Region,
Category).
✔✔What is a measure? - ✔✔Quantitative field aggregated by default (e.g., Sales,
Profit).
✔✔What does blue vs. green mean? - ✔✔Blue = discrete (headers), Green =
continuous (axis).
✔✔How do you convert a field from discrete to continuous? - ✔✔Right-click field -->
Convert to Continuous (or change pill from blue to green via context menu).
✔✔What is a data role? - ✔✔The way Tableau treats a field (e.g., geographic role like
Country/State, or data type like string, number).
✔✔How are nulls handled in dimensions vs. measures? - ✔✔Dimension nulls appear as
'Null' category; measure nulls can be filtered or shown as gaps.
✔✔What is default aggregation for measures? - ✔✔SUM, but can be changed (AVG,
MIN, MAX, COUNT, CNTD, etc.).
✔✔When use discrete dates? - ✔✔To display separate headers (e.g., Month names as
categories).
✔✔When use continuous dates? - ✔✔To show a continuous axis for trends over time.
EVALUATION EXAMS QUESTIONS AND ANSWERS
SURE A+
✔✔When to use an extract? - ✔✔For performance, offline analysis, complex
calculations, or to isolate a subset of data.
✔✔What is a join? - ✔✔Combines tables horizontally by matching key fields (inner, left,
right, full).
✔✔What is a union? - ✔✔Stacks tables vertically (same structure/columns) to add rows.
✔✔What are relationships? - ✔✔Logical connections between tables that preserve their
native levels of detail and join only when needed in the viz.
✔✔When are relationships preferred over physical joins? - ✔✔When combining fact
tables with different grains or when avoiding row duplication/incorrect aggregations.
✔✔What is data blending? - ✔✔Combines data from multiple published/connected
sources at the aggregate level (primary and secondary sources).
, ✔✔How do you identify blending in a view? - ✔✔An orange chain link icon appears on
linked fields; secondary data has orange tick marks.
✔✔What is the default join type? - ✔✔Inner join.
✔✔What is a left join result? - ✔✔All records from left table; matching records from
right; unmatched right values are null.
✔✔What is a full outer join result? - ✔✔All records from both tables; unmatched values
from either side are null.
✔✔How do you create a union of multiple CSVs with the same schema? - ✔✔Drag one
file onto another in the Data Source canvas or use Wildcard (folder union) option.
✔✔What is a join clause vs. join type? - ✔✔Clause: how tables match (e.g., left.ID =
right.ID); Type: inner/left/right/full determining row inclusion.
✔✔What is a dimension? - ✔✔Categorical field used for slicing/grouping (e.g., Region,
Category).
✔✔What is a measure? - ✔✔Quantitative field aggregated by default (e.g., Sales,
Profit).
✔✔What does blue vs. green mean? - ✔✔Blue = discrete (headers), Green =
continuous (axis).
✔✔How do you convert a field from discrete to continuous? - ✔✔Right-click field -->
Convert to Continuous (or change pill from blue to green via context menu).
✔✔What is a data role? - ✔✔The way Tableau treats a field (e.g., geographic role like
Country/State, or data type like string, number).
✔✔How are nulls handled in dimensions vs. measures? - ✔✔Dimension nulls appear as
'Null' category; measure nulls can be filtered or shown as gaps.
✔✔What is default aggregation for measures? - ✔✔SUM, but can be changed (AVG,
MIN, MAX, COUNT, CNTD, etc.).
✔✔When use discrete dates? - ✔✔To display separate headers (e.g., Month names as
categories).
✔✔When use continuous dates? - ✔✔To show a continuous axis for trends over time.
