Practice questions · Data & Analytics
Tableau Desktop Specialist (Tableau Desktop Foundations): Practice Questions
Original practice questions for the Tableau Desktop Specialist (now Tableau Desktop Foundations). Each answer is explained, including why each wrong option is wrong. Filter by domain or difficulty. These are concept checks - not real exam questions.
Answered 0 · Correct 0
-
In Tableau, a field that is aggregated with functions like SUM or AVG is normally a:
Correct answer: D. Measures are numeric fields Tableau aggregates (SUM, AVG, COUNT). A dimension slices data and is not aggregated by default. A parameter is a single user-controlled value, not a data field. A filter limits what is shown but is not itself the aggregated quantity. -
A blue, discrete date pill on the Columns shelf produces:
Correct answer: B. Discrete (blue) fields create distinct headers. A continuous axis comes from a green, continuous pill, not a blue one. A calculated field is a formula you define, unrelated to the pill colour. A published data source is about where data lives, not how a pill renders. -
Which method stacks rows from several tables that share the same columns (for example, twelve monthly files)?
Correct answer: C. A union stacks rows from tables with matching columns. Data blending links two separate data sources on a shared field rather than stacking rows. An inner join combines columns at the row level on a key, not by stacking. A level-of-detail expression sets calculation granularity and does not combine tables. -
You need to combine an Excel sales table and a SQL Server targets table that live in different connections, linking them on Region. The best approach is:
Correct answer: D. Data blending links two separate data sources on a shared field such as Region. A union only stacks rows from similar tables in the same structure, not separate sources. A context filter narrows data before other filters and does not combine sources. A story point is a step in a Tableau story, unrelated to joining data. -
The Marks card in Tableau lets you control:
Correct answer: B. The Marks card controls visual properties: colour, size, label, detail, shape and tooltip. The list of database tables appears on the data source page, not the Marks card. User permissions are managed on Tableau Server/Cloud, not in the viz. The exam pass mark is unrelated to the product. -
Show Me in Tableau is used to:
Correct answer: D. Show Me suggests suitable chart types based on the fields selected. Publishing to Tableau Public is done through the Server/Public menu, not Show Me. Row-level security is configured on data sources, not in Show Me. Writing a calculation happens in the calculation editor. -
A calculation that runs across the values already displayed in the view, such as a running total or percent of total, is a:
Correct answer: A. Table calculations operate on the marks already in the view (running total, % of total, rank). A row-level calculation works on each underlying row before aggregation, not across the view. A data source filter limits data on load and computes nothing. A union combines tables, and a parameter is a single input value. -
Which expression is a Level of Detail (LOD) calculation?
Correct answer: C. The FIXED/INCLUDE/EXCLUDE syntax in braces defines a Level of Detail expression that sets its own granularity. SUM([Sales]) is a plain aggregate. [Sales] - [Cost] is a row-level calculation. RANK(SUM([Sales])) is a table calculation that ranks values in the view, not an LOD. -
A Tableau dashboard is best described as:
Correct answer: B. A dashboard combines multiple sheets together with filters and actions on one canvas. A single worksheet is just one view, not a dashboard. A saved data extract is a snapshot of the data (.hyper). A database connection is how Tableau reaches the data, not a dashboard. -
A Tableau Story is:
Correct answer: A. A story is a sequence of story points (sheets or dashboards) arranged to tell a narrative. A join combines tables and is not a presentation format. A calculated field is a formula-defined field. A data type (string, date, number) describes a field's values, not a narrative. -
An extract (.hyper) differs from a live connection in that an extract:
Correct answer: C. An extract is a saved snapshot of the data that often performs faster and works offline. It does not show real-time data - that is a live connection, which queries the source each time. An extract can be used offline, so 'cannot be used offline' is the opposite. Extracts store data, not user passwords. -
In Tableau's filter order of operations, which filter type is applied first?
Correct answer: D. Context filters apply before dimension, measure and table-calculation filters, creating a temporary subset the others run against. A measure filter applies after aggregation, later in the order. A table-calculation filter applies last of these. A dimension filter applies after context, not before it. -
To combine selected members of a field (for example, grouping several cities into one 'Key Cities' category), you use a:
Correct answer: A. A group combines selected members of a field into a single category. A parameter is one user-controlled value and cannot bundle members. A union stacks rows from tables, not members of a field. A tooltip is the hover-over detail and has nothing to do with grouping. -
A green, continuous pill placed on Rows produces:
Correct answer: B. Continuous (green) fields create an axis. Discrete headers come from blue, discrete pills, not green ones. Adding a pill to a shelf does not create a data source. A dashboard action is configured on a dashboard, not by dropping a pill on Rows. -
Which join type returns only the rows that have matching keys in both tables?
Correct answer: C. An inner join keeps only rows with a match in both tables. A left join keeps all rows from the left table plus matches from the right. A full outer join keeps all rows from both, matched where possible. A union is not a join at all - it stacks rows. -
The free version of Tableau Desktop that saves your work to the public web is:
Correct answer: D. Tableau Public is the free desktop tool that publishes workbooks to the public web. Tableau Server is the paid, self-hosted sharing platform. Tableau Prep is a separate data-preparation product. Tableau Bridge keeps cloud extracts connected to private data and is not an authoring tool. -
A dual-axis chart in Tableau is used to:
Correct answer: A. A dual axis overlays two measures on the same chart, optionally with synchronised axes. Joining two data sources is a data-preparation step, not a chart feature. Filtering nulls is done on the Filters shelf. Publishing to a server is a sharing action, unrelated to dual axes. -
A parameter in Tableau is:
Correct answer: B. A parameter is one value the user can change, which calculations, filters and reference lines can read. A snapshot of the data is an extract. A dashboard is a multi-sheet canvas, not a single value. Stacking rows is what a union does, not a parameter. -
When you connect to a CSV file and Tableau reads a postal-code column as a number, the correct fix is to:
Correct answer: C. Changing the data type to string stops Tableau treating postal codes as numbers to sum or average. A union stacks rows and does nothing to a field's type. A context filter narrows data, not data types. Publishing an extract saves a snapshot but would keep the wrong type. -
On the data source page, which option keeps the workbook querying the underlying database directly each time it is used?
Correct answer: D. A live connection queries the source database directly each time, so the data stays current. An extract is the opposite - a saved snapshot that does not re-query the source on its own. A union stacks rows from similar tables and is not a connection mode. A data blend links two separate sources in the view and does not define how one source is queried. -
The Pages shelf in Tableau is mainly used to:
Correct answer: A. The Pages shelf breaks a view into pages you can flip through (often by date) to show change. Setting a colour theme is formatting, not the Pages shelf. Joining tables happens on the data source page. Defining user roles is a server administration task. -
To show how a single measure is distributed across geographic regions on a map, the most natural chart is a:
Correct answer: A. A filled (choropleth) map shades regions by a measure, ideal for geographic distribution. A Gantt chart shows durations over time, not geography. A histogram shows the distribution of one continuous measure in bins, with no map. A bullet graph compares a measure to a target, again without geography. -
A dashboard action that changes other sheets when you click a mark is configured through:
Correct answer: B. Interactivity like cross-filtering is set up with Dashboard Actions, such as a Filter action. The data source page is for connecting and joining data, not interactivity. A level-of-detail expression controls calculation granularity. The Pages shelf animates a single view and does not link sheets on click. -
Which statement about dimensions and measures is correct?
Correct answer: C. Dimensions slice data and measures are aggregated by default - the core distinction. Measures are typically green and continuous, not blue and discrete. Dimensions are not aggregated by default; measures are. Fields can be converted between roles, so 'never' is wrong. -
A set in Tableau is best described as:
Correct answer: A. A set is a custom subset of data (e.g. top 10 customers) that can update dynamically and be referenced in calculations. A saved colour palette is a formatting preference. A data source connection is how Tableau reaches data. A scheduled refresh updates extracts on a timer and is unrelated to sets. -
When you drag a discrete dimension onto the Color shelf in the Marks card, Tableau will:
Correct answer: B. A discrete dimension on Color gives each member its own distinct colour. A continuous colour gradient appears when a continuous measure is on Color, not a discrete dimension. Dimensions are not summed by default. Dropping a field on Color does not publish anything. -
Which is the correct order, from earliest to latest, in Tableau's filter sequence?
Correct answer: C. The order runs extract -> data source -> context -> dimension -> measure -> table calculation, so extract before context before dimension before measure is correct. Putting a measure filter before a context filter reverses the sequence. Table-calculation filters are last, not first. Dimension filters come after the extract and context stages, not before them. -
The primary reason to create a hierarchy (for example, Country > State > City) in Tableau is to:
Correct answer: B. A hierarchy lets users drill down by expanding or collapsing related levels in the view. It does not encrypt data, which is a security feature. It does not change connection speed, which depends on the data source and extracts. It also does not replace calculations, which serve a different purpose. -
Which tool would you use to format a dashboard's spacing, borders and background?
Correct answer: C. Spacing, borders and background are adjusted in the Format and Layout panes. The data source page is for connecting and shaping data, not visual styling. A table calculation computes values across the view and changes no formatting. A union combines table rows and has nothing to do with appearance. -
A tooltip in Tableau:
Correct answer: A. A tooltip is the pop-up detail shown on hover over a mark, and it is customisable. A join key links tables on the data source page, not in a tooltip. The extract refresh schedule is set when publishing. Who can view a workbook is governed by server permissions, not tooltips.
Practice questions FAQ
- Are these real Tableau Desktop Specialist exam questions?
- No. These are original study questions written to test understanding. They are not real exam questions, exam dumps, or copied from any provider.
- How should I use these practice questions?
- Answer each one, read the explanation (including why the wrong options are wrong), and use the per-domain score below to focus your revision on weak areas. Revisit before exam day.
- How many questions should I do before the exam?
- Enough to score consistently across every domain, alongside full-length practice from official or reputable providers. Understanding why each answer is right matters more than raw volume.
- What score means I am ready?
- A good signal is consistently scoring around 80% or higher across all domains on questions you have not seen before, and being able to explain why the wrong options are wrong.
- Should I use exam dumps?
- No. Dumps (real or leaked questions) breach provider policy, can void your certification, and do not build the understanding the exam actually tests.