Tableau Desktop Specialist Certification Exam Study Guide & Practice Questions - 2026-2027
What is Tableau Desktop used for? Authoring and analyzing data; creating workbooks, sheets, dashboards, and stories.
What is Tableau Public? A free platform to publish and share visualizations publicly; data/workbooks are
public.
What is Tableau Server/Online? Secure platforms to publish, share, and collaborate on Tableau content within an
organization (Server self-hosted; Online SaaS).
Difference between .twb and .twbx? .twb is XML instructions (no data); .twbx packages workbook with data, images, and
assets.
What does .hyper represent? Extract file format used by Tableau for fast query performance.
Where is the Show Me pane and what does it do? Right side by default; suggests chart types based on selected fields.
What is the Data pane? Left panel listing fields (dimensions, measures) and data sources.
What is the Marks card? Controls encoding: color, size, label, detail, tooltip, shape.
What are shelves? Rows, Columns, Filters, Pages, etc., where you place fields to build the view.
What is the Status Bar useful for? Shows marks count, filter status, and summary of selection.
What is a data source in Tableau? A defined connection to data (schema, fields, connection type, extract/live settings).
How do you add a second data source to a workbook? Data menu --> New Data Source; or connect via the Data Source page.
How do you rename a data source or field? Right-click the data source/field --> Rename.
How do you hide unused fields? Data Source page --> Hide All Unused Fields; or right-click field --> Hide.
How do you replace a field used across the workbook? Right-click field --> Replace References...
, Tableau Desktop Specialist Certification Exam Study Guide & Practice Questions - 2026-2027
What is a data source filter? A filter applied at the data source level affecting all sheets using that source.
How do you create an extract? On Data Source page --> Extract radio button --> Create Extract; or Data menu -->
Extract.
When should you refresh an extract? When underlying source data changes and you need updated results.
Live vs. Extract—key tradeoff? Live: real-time, can be slower, source load; Extract: snapshot, faster, offline
capable.
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 Drag one file onto another in the Data Source canvas or use Wildcard (folder union)
schema? option.
What is Tableau Desktop used for? Authoring and analyzing data; creating workbooks, sheets, dashboards, and stories.
What is Tableau Public? A free platform to publish and share visualizations publicly; data/workbooks are
public.
What is Tableau Server/Online? Secure platforms to publish, share, and collaborate on Tableau content within an
organization (Server self-hosted; Online SaaS).
Difference between .twb and .twbx? .twb is XML instructions (no data); .twbx packages workbook with data, images, and
assets.
What does .hyper represent? Extract file format used by Tableau for fast query performance.
Where is the Show Me pane and what does it do? Right side by default; suggests chart types based on selected fields.
What is the Data pane? Left panel listing fields (dimensions, measures) and data sources.
What is the Marks card? Controls encoding: color, size, label, detail, tooltip, shape.
What are shelves? Rows, Columns, Filters, Pages, etc., where you place fields to build the view.
What is the Status Bar useful for? Shows marks count, filter status, and summary of selection.
What is a data source in Tableau? A defined connection to data (schema, fields, connection type, extract/live settings).
How do you add a second data source to a workbook? Data menu --> New Data Source; or connect via the Data Source page.
How do you rename a data source or field? Right-click the data source/field --> Rename.
How do you hide unused fields? Data Source page --> Hide All Unused Fields; or right-click field --> Hide.
How do you replace a field used across the workbook? Right-click field --> Replace References...
, Tableau Desktop Specialist Certification Exam Study Guide & Practice Questions - 2026-2027
What is a data source filter? A filter applied at the data source level affecting all sheets using that source.
How do you create an extract? On Data Source page --> Extract radio button --> Create Extract; or Data menu -->
Extract.
When should you refresh an extract? When underlying source data changes and you need updated results.
Live vs. Extract—key tradeoff? Live: real-time, can be slower, source load; Extract: snapshot, faster, offline
capable.
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 Drag one file onto another in the Data Source canvas or use Wildcard (folder union)
schema? option.
