Salesforce Certified Tableau Desktop Foundations — Practice Set 1

Question 1

A retail analyst connects Tableau Desktop directly to a live production SQL Server database instead of creating an extract. What is the primary implication of using a live connection?

Accepted Answer

A live connection sends queries directly to the underlying database in real time, so the view always reflects the latest data (subject to the source's own refresh cadence) but depends on network access to the source. An extract, not a live connection, copies data into Tableau's in-memory/.hyper engine for offline use and often faster performance. Live-connected workbooks can still be published to Tableau Server, and live connections do not create .hyper files.

Question 2

A consultant needs to share a Tableau workbook with a client who does not have access to the original database, and the data does not need to update in real time. Which approach best fits this requirement?

Accepted Answer

An extract creates a compressed, portable snapshot of the data stored within (or alongside) the workbook, so it can be opened and analyzed without a live connection to the original source — ideal for offline sharing. Requiring database drivers on the client's machine is unnecessary and impractical for external sharing. Renaming a connection or converting field types has no bearing on offline portability.

Question 3

Which file type allows an author to save just the metadata (connection information, calculated fields, groups, and other customizations) of a data source without saving the actual data?

Accepted Answer

A Tableau Data Source (.TDS) file stores connection metadata and customizations (calculated fields, aliases, groups, etc.) but not the underlying data itself, making it easy to reuse a configured connection across workbooks. .TWBX is a packaged workbook that includes data; .HYPER is Tableau's extract data engine file; .TWB is a workbook file referencing an external data source.

Question 4

An author is building a data source that combines a Sales table from a SQL database with a Regional Targets table from an Excel spreadsheet, matched on a common Region field, within the same logical layer. What has the author created?

Accepted Answer

Combining tables from different connection types (e.g., a SQL Server table and an Excel file) into one data source, related through common fields, is exactly what a data source with multiple connections (cross-database join or relationship) enables. Dashboard actions, parameters, and calculated fields are unrelated Tableau features that operate after the data source is built.

Question 5

When would an author typically use a join instead of a relationship when combining two tables in Tableau Desktop?

Accepted Answer

Joins physically combine rows from two tables into one flattened table at query time, which is appropriate when the data needs to behave as a single table with one level of detail. Relationships, by contrast, keep tables at their native levels of detail and let Tableau determine the appropriate join context per sheet — which is the better fit for option B/C-style scenarios. A single table has nothing to join or relate to.

Question 6

A field named 'cust_region' contains U.S. state abbreviations, but Tableau does not recognize it as location data for mapping. What should the author do to enable geographic visualization?

Accepted Answer

Assigning a geographic role tells Tableau how to interpret a field's values (e.g., as U.S. states) so it can be plotted on a map. Changing the data type to Boolean or converting to a measure would not give Tableau the geographic context it needs, and creating an extract has no effect on how a field's role is interpreted.

Question 7

An analyst wants to compare total sales across product categories using vertical bars, where category is on the Columns shelf and SUM(Sales) is on the Rows shelf. Which chart type is this?

Accepted Answer

A bar chart plots a categorical (discrete) dimension against a continuous measure, commonly with categories on Columns and the aggregated measure on Rows, rendering as bars. A scatterplot compares two measures as points, a density map shows point concentration on a geographic map, and a crosstab is a table of values rather than a bar visualization.

Question 8

An analyst places SUM(Profit) on one axis and SUM(Sales) on a second, independent axis in the same view, both scaled separately, to compare their trends over time on separate scales. What has the analyst built?

Accepted Answer

A dual axis chart places two measures on two separate, independently scaled axes within the same view, allowing each measure's trend to be compared even when their magnitudes differ greatly. A combined axis chart instead plots multiple measures on a single shared axis. A stacked bar chart sums measures within a single bar, and a highlight table is a colored crosstab, not an axis-based chart.

Question 9

Which chart type is best suited for visualizing the relationship between two continuous measures, such as Profit versus Sales, at the individual data-point level?

Accepted Answer

A scatterplot places two continuous measures on the X and Y axes, plotting individual marks to reveal correlation or clustering patterns. A line chart is best for showing a measure trending over a continuous dimension like date; a stacked bar sums categorical parts of a whole; a crosstab is a numeric table, not a point-based visualization.

Question 10

An author wants to bundle 'California', 'Oregon', and 'Washington' into a single member called 'West Coast' directly from the data pane, without writing a calculation. What feature should be used?

Accepted Answer

Groups combine related dimension members into a single higher-level category (e.g., three states into 'West Coast') and can be created directly from marks, headers, or the data pane without calculations. A set is a custom field defining membership based on conditions or a fixed list, more often used for comparison/highlighting rather than simple relabeling. A parameter is a standalone input control, and a hierarchy organizes fields into drill-down levels rather than combining member values.

Question 11

What is the purpose of organizing dimensions such as Country, State, and City into a hierarchy in Tableau Desktop?

Accepted Answer

A hierarchy nests related dimensions (e.g., Country > State > City) so end users can click the plus/minus icons to drill down to more granular levels or roll up to a higher level directly within the view. Hierarchies do not alter measure aggregation, do not create calculated fields, and do not automatically generate maps — geographic roles handle that separately.

Question 12

A manager wants a dashboard that only shows order data from the last 90 days whenever it is opened, updating relative to today's date. What should the analyst add to the view?

Accepted Answer

A relative date filter restricts the view to a rolling window (e.g., 'last 90 days') that recalculates automatically based on the current date each time the workbook is opened or refreshed. A quick table calculation performs running/percent-based computations, not filtering; a reference line annotates a value on an axis; a bin groups continuous data into fixed-size buckets.

Question 13

Which of the following are valid ways to add a manual or computed sort to a Tableau worksheet? (Choose two.)

Accepted Answer

Tableau supports both computed sorting (e.g., clicking the sort toolbar icon to order by an axis measure) and manual sorting (dragging headers into a custom sequence). Assigning a geographic role affects mapping behavior, not sort order, and changing a number format only affects how values are displayed, not their sort order.

Question 14

An analyst creates a calculated field that returns TRUE when SUM(Sales) exceeds a value the end user can adjust interactively via a slider control. Which two Tableau features work together to enable this?

Accepted Answer

A parameter provides a user-adjustable input (like a slider), and a calculated field can reference that parameter's current value in its logic — for example, comparing SUM(Sales) to the parameter to return TRUE/FALSE. Groups and sets combine dimension members rather than accepting freeform numeric input from a slider; hierarchies organize drill-down levels; reference lines annotate values but do not drive calculation logic.

Question 15

What is the purpose of enabling 'Show Totals' on a worksheet containing SUM(Sales) broken down by Region?

Accepted Answer

Show Totals adds grand total and/or subtotal rows or columns that aggregate the values already in the view, giving a quick summary alongside the detailed breakdown. It does not change the aggregation function used for the existing measure, does not create a new calculated field, and has no effect on active filters.

Question 16

An author wants each bar in a view to be shaded according to its Profit Ratio value, using a color gradient from red to green. Where should Profit Ratio be placed to achieve this?

Accepted Answer

Dragging a measure onto the Color property of the Marks card applies a color encoding (such as a diverging red-to-green gradient) based on that measure's values. The Filters shelf restricts which data appears rather than coloring it; Detail adds granularity without visual encoding; Pages creates a page-through animation control.

Question 17

Which feature allows a dashboard author to make a filter on one worksheet automatically update the data shown in other worksheets on the same dashboard when a user clicks a mark?

Accepted Answer

A filter action passes selected values from one worksheet as a filter to other worksheets on the dashboard, enabling interactive drill-down when a user clicks or hovers a mark. A story point is a narrative slide referencing dashboard/worksheet states, not an interactive filter mechanism; a layout container arranges dashboard objects; device-specific dashboards adjust layout for screen size, not filtering behavior.

Question 18

A presenter wants viewers to see a brief animated transition between two states of a chart (for example, bars re-sorting) to make the change easier to follow. Which feature enables this?

Accepted Answer

Viz animations smoothly transition marks between different states (such as re-sorted bars or a changed filter) so viewers can visually track the change rather than seeing an abrupt jump. The data highlighter lets users search and highlight specific marks; tooltips display detail on hover; show filters exposes filter controls to dashboard viewers.

Question 19

A field author wants each dashboard consumer to interactively type in a keyword to search and highlight matching marks across a view, without filtering out the rest of the data. Which feature should be used?

Accepted Answer

The data highlighter provides a search/select control that visually emphasizes matching marks while keeping all other marks visible (dimmed), rather than removing them from the view. A URL action opens an external link; a parameter control lets a user set a parameter value; a highlight action highlights marks based on selections in another worksheet rather than free-text search.

Question 20

A user wants to share a fully interactive Tableau workbook, including all worksheets and dashboards, as a single file that a colleague can open in Tableau Reader without any live connection. What should they use?

Accepted Answer

A packaged workbook (.twbx) bundles the workbook file together with any local data extracts, images, and custom files into one shareable, self-contained file that can be opened in Tableau Desktop or the free Tableau Reader. Publishing to Server requires server access rather than a portable file; exporting a static image or CSV would lose interactivity or the visual presentation entirely.

Question 21

An executive asks for a printable summary of a Tableau dashboard to include in a slide presentation. Which native export option directly supports this request?

Accepted Answer

Tableau Desktop natively supports exporting a workbook, dashboard, or story directly to Microsoft PowerPoint format, making it straightforward to include in a slide presentation. Saving a .tds file only preserves data source metadata; hierarchies and sorts are analysis features unrelated to exporting to a presentation format.

Question 22

In Tableau, which category typically describes qualitative data used to categorize or segment values, such as Customer Name or Product Category?

Accepted Answer

Dimensions typically hold qualitative, categorical information (names, categories, dates as discrete values) used to slice and segment the data. Measures hold quantitative, numeric information intended to be aggregated. Parameters are standalone user-input values, and extracts are a data storage mechanism, not a field category.

Question 23

A field displayed as distinct, individually colored segments (rather than a continuous gradient) along an axis is being treated as which type of field in Tableau?

Accepted Answer

Discrete fields are rendered as distinct, separated headers or individually colored segments (shown in blue in Tableau's UI), while continuous fields render as a smooth, unbroken axis or gradient (shown in green). 'Aggregated' describes a calculation state (e.g., SUM), not the discrete/continuous distinction, and 'extracted' refers to how data is stored, not how a field is visually rendered.

Question 24

An author drags the Order Date field onto Columns and chooses to display it as discrete 'Month' (e.g., January, February) rather than as a continuous date value. What is the practical effect on the view?

Accepted Answer

Discrete date parts (like 'Month' as a header) group values by that part of the date across all years, so every January across multiple years is combined into one 'January' header — unlike a continuous date value, which would plot a single unbroken timeline across years. Choosing a discrete date part does not change the field's underlying data type, does not create a map, and does not automatically add a trend line.

Question 25

A worksheet shows SUM(Sales) with no dimensions in the view, displaying one grand total bar. The author then adds the Region dimension to Rows. What happens to the displayed value(s), and why?

Accepted Answer

Adding a dimension to the view changes the granularity at which a measure is aggregated — Tableau recalculates SUM(Sales) separately for each distinct value of the added dimension (each region), rather than repeating one grand total. The field's fundamental type (measure) does not change, and the measure remains aggregated rather than reverting to unaggregated row-level detail.

Analytics-101 — Salesforce Certified Tableau Desktop Foundations