Salesforce Certified Tableau Desktop Foundations — Practice Set 3

Question 1

A retail chain's data team notices that opening their Tableau workbook on a laptop with no network access still works fully, including all visualizations. What does this suggest about how the workbook connects to its data?

Accepted Answer

An extract stores a portable snapshot of the data within the workbook or a local .hyper file, so it functions fully offline with no network access. A live connection, by contrast, requires ongoing network access to the source database and would fail or show stale/blank data offline. Every workbook must reference some data source, and publishing to Server is unrelated to offline functionality on a laptop.

Question 2

A colleague asks why their workbook keeps showing the same numbers even after new rows were added to the source spreadsheet yesterday. What is the most likely cause?

Accepted Answer

If a workbook is built on an extract, it will not reflect new source data until that extract is manually or automatically refreshed — this is the most common and direct explanation for stale results. Renaming the file, deleting calculated fields, or converting field types are unrelated issues that would typically produce errors or different symptoms, not simply 'the same old numbers.'

Question 3

An author has an Employees table and a Departments table, each at a different level of detail (one row per employee vs. one row per department), and wants each table to retain its own native granularity while still being usable together in the same data source. Which feature should the author use to combine them?

Accepted Answer

Relationships allow tables with different levels of detail to coexist in one data source, each preserving its own native granularity, while Tableau determines the appropriate join context per worksheet. A join, by contrast, physically flattens tables into a single combined table, which would force a shared grain. A union stacks rows from similarly structured tables, and a group only combines dimension members, not entire tables.

Question 4

A field named 'is_active' contains only the values 1 and 0, and the author wants Tableau to treat it as a true/false flag rather than a number. What should the author do?

Accepted Answer

Changing the field's data type to Boolean tells Tableau to interpret its values as true/false rather than numeric, which changes available behaviors such as filtering and default aggregation. A geographic role only applies to location-based fields, hierarchies organize related dimensions for drill-down, and creating an extract has no bearing on how an individual field's type is interpreted.

Question 5

An author notices that a Revenue field defaults to SUM whenever it's dropped into a view, but they want it to default to AVG instead for every future worksheet using this data source. What should they change?

Accepted Answer

Changing a field's default aggregation (one of its default properties) sets the aggregation that Tableau applies automatically whenever that field is dropped into a new worksheet in this data source. Geographic role affects mapping only, an alias changes displayed value labels rather than aggregation behavior, and connection type describes how Tableau accesses the source, not per-field aggregation defaults.

Question 6

A data source combines a live connection to an on-premises SQL Server table with an Excel spreadsheet of external benchmark data, joined on a shared Product ID field. What has the author built?

Accepted Answer

Combining tables from two different connection types (SQL Server and Excel) into one data source is precisely what a data source with multiple connections (cross-database join) enables. It is not a single-connection extract since two distinct connection types are involved, and it is unrelated to calculated fields or parameters, which operate on already-connected data.

Question 7

An operations analyst wants to compare the geographic distribution of warehouse locations along with their inventory levels shown by marker size. Which chart type is most appropriate?

Accepted Answer

A map using geographic data plots locations (such as warehouses) spatially, and marker size can be used to encode a measure like inventory levels, making geographic distribution and magnitude visible together. A crosstab is a plain numeric table without spatial context, a stacked bar chart sums categorical parts, and a dual axis line chart compares two measures on separate scales rather than geographic position.

Question 8

An analyst has SUM(Sales) and SUM(Profit) on the same axis, both scaled to a single shared range, but Profit values are much smaller than Sales, making the Profit bars nearly invisible. Which alternative chart approach would resolve this visibility problem while still showing both measures together?

Accepted Answer

A dual axis chart gives each measure its own independently scaled axis, which directly solves the problem of one measure being visually dwarfed by another when forced onto a single shared axis. Switching measures to discrete fields would fundamentally change how they're treated and wouldn't fix scale visibility; adding measures to Filters restricts rows rather than adjusting axis scale; removing a measure abandons the requirement to show both together.

Question 9

A support team wants a quick visual table where each cell's background color intensity reflects the number of support tickets for a given day and agent, at a glance. Which chart type fits best?

Accepted Answer

A highlight table is a crosstab where cell background colors encode a measure's magnitude, letting patterns across two dimensions (day and agent) be spotted quickly. A scatterplot compares two continuous measures as points, a line chart shows trend over a continuous dimension, and a density map is specifically for geographic point concentration, not tabular day/agent combinations.

Question 10

A regional manager wants 'New York', 'New Jersey', and 'Connecticut' combined into a single category labeled 'Tri-State Area' for reporting, using an ad hoc grouping created directly in the view rather than editing the source data. Which feature should be used?

Accepted Answer

A group lets an author select multiple dimension members (three states) directly in the view or data pane and combine them under one new label, without writing any calculation. A parameter accepts user input rather than combining members; a CASE-based calculated field could technically achieve similar output but requires writing a calculation, which the scenario says to avoid; changing a geographic role affects mapping, not categorical grouping.

Question 11

A dashboard needs a Product hierarchy where users can drill from Category down to Sub-Category down to individual Product Name, all within the same worksheet without needing separate views. What should the author configure?

Accepted Answer

A hierarchy nests related dimensions from broad to granular (Category > Sub-Category > Product Name), letting users expand/collapse levels of detail directly within the same view. A set defines custom conditional membership rather than a drill path, a parameter is a single user-adjustable value, and a bin groups continuous numeric ranges rather than nesting categorical levels.

Question 12

An HR analyst wants to filter a workforce report so it only shows employees hired in the current calendar quarter, automatically rolling forward each quarter. What filter type should be used?

Accepted Answer

A relative date filter can be configured to always reflect the current calendar quarter, automatically rolling forward without manual adjustment. A fixed date range hardcoded to Q1 would not update in subsequent quarters; a quick table calculation performs computations, not row filtering; a reference line only annotates a value on an axis.

Question 13

Which of the following describe valid uses of a parameter in Tableau Desktop? (Choose two.)

Accepted Answer

Parameters are commonly used to let users dynamically swap which measure/dimension is displayed, or to enter a custom value (like a threshold) referenced by a calculated field. Detecting geographic roles is an automatic Tableau field-recognition behavior unrelated to parameters, and scheduling live-connection refreshes is a server/data-management feature, not something parameters control.

Question 14

An analyst wants to create a new field that concatenates a customer's First Name and Last Name into one combined 'Full Name' string for display in tooltips. What should the analyst create?

Accepted Answer

A calculated field can use string functions (or the '+' operator) to concatenate First Name and Last Name into a new combined field, which is a common example given in the exam guide's coverage of calculated fields (e.g., string, date, simple arithmetic). A parameter is a user input control, a group combines existing dimension members without creating new derived text, and a geographic role only affects mapping interpretation.

Question 15

A worksheet displaying SUM(Sales) by Product Category needs a subtotal shown beneath each category grouping as well as an overall grand total. Which feature provides this?

Accepted Answer

Show Totals can add both subtotal rows/columns for each grouping level and an overall grand total, aggregating the values already present in the view. A quick table calculation recomputes values (e.g., running totals) rather than adding total rows, a reference line only marks a value on an axis, and a bin groups continuous values into ranges.

Question 16

A dashboard author wants text labels showing the exact SUM(Sales) value to appear directly above each bar in a bar chart. Which Marks card property should be used?

Accepted Answer

The Label property on the Marks card displays text (such as a measure's value) directly on or near each mark, which is exactly what's needed to show SUM(Sales) above each bar. Detail adds fields to increase granularity without displaying text, Shape changes the icon used for marks, and Size scales marks by a measure rather than displaying labels.

Question 17

A dashboard author wants clicking a specific product bar in one worksheet to visually emphasize related marks in a second worksheet on the same dashboard, without changing what data those marks actually show. Which dashboard action is most appropriate?

Accepted Answer

A highlight action visually emphasizes related marks in other worksheets based on a selection, without removing or filtering out the other, unselected data — exactly the 'emphasize but don't change what's shown' requirement. A filter action would instead remove non-matching data from the other worksheets, a URL action opens an external link, and a parameter action sets a parameter's value rather than highlighting.

Question 18

A dashboard author wants viewers to be able to show or hide a filter control directly on the published dashboard, rather than needing to edit the workbook. What should the author enable?

Accepted Answer

Show filters exposes an interactive filter card/control directly on the dashboard so viewers can adjust filtering themselves without editing the underlying workbook. Viz animations only transition visual states, the data highlighter is for searching/highlighting marks, and a story point is a narrative slide, not a filter-exposure feature.

Question 19

A dashboard is built with several worksheets arranged in a specific grid, and the author wants that same layout to automatically rearrange into a single stacked column when viewed on a phone. What should the author configure?

Accepted Answer

Configuring a phone-specific dashboard layout lets the author define an alternate arrangement of the same objects (e.g., stacked in a single column) tailored to small screens, distinct from the default desktop layout. A story is a sequential narrative of captured states, not a responsive layout mechanism, and parameter/set actions control interactivity, not device-based layout switching.

Question 20

An analyst wants to distribute a single static snapshot of a dashboard for inclusion in an email, with no interactivity required by the recipient. Which export is most suitable?

Accepted Answer

Exporting the dashboard as a static image produces a simple, non-interactive snapshot suitable for pasting into an email, exactly matching the stated requirement. Publishing to Server and saving as a .twbx would both preserve interactivity (more than needed and requiring Tableau to view), and a .tds file only contains data source metadata, not a visual snapshot.

Question 21

A business stakeholder without Tableau installed asks for the workbook's dashboards embedded directly into a slide deck they will edit and present themselves. Which native export best satisfies this?

Accepted Answer

Tableau's native PowerPoint export converts dashboards, worksheets, or stories into slides that can be directly edited and presented without needing Tableau installed. A .hyper extract is a data storage file, not a presentation format; creating a set or adding a filter action are analysis/interactivity features unrelated to exporting to a slide deck.

Question 22

A field called Order ID contains a unique numeric identifier for every order and is never intended to be summed or averaged, only used to distinguish records. How should this field most appropriately be treated in Tableau?

Accepted Answer

Even though Order ID is numeric, its purpose is to identify/categorize individual records rather than to be aggregated, which is the defining characteristic of a dimension — so it's typically best treated (or manually converted) as a dimension despite Tableau sometimes defaulting numeric fields to measures. Treating it purely as a measure would encourage inappropriate aggregation like summing IDs. It is not a parameter or geographic role, which serve entirely different purposes.

Question 23

Which visual cue does Tableau use to indicate that a field pill on a shelf is being treated as discrete rather than continuous?

Accepted Answer

Tableau colors discrete field pills blue and continuous field pills green, giving a quick visual cue about how a field is currently being treated in the view. Red and gray pills are not part of Tableau's standard discrete/continuous color convention.

Question 24

An author changes a date field from a discrete 'Quarter' date part to a continuous 'Quarter' date value on the Columns shelf. What is the most direct effect on the resulting view?

Accepted Answer

Switching from a discrete date part to a continuous date value changes the axis from grouping same-named periods together (e.g., all Q1s combined) to plotting each period instance along one unbroken chronological timeline (Q1 2024 separate from Q1 2025). The field remains recognized as a date, measures are unaffected, and nothing about this change triggers a geographic map.

Question 25

A view shows COUNTD(Customer ID) with no dimensions in the view, returning one overall count. The author then adds Region to Rows. Why does the count change per row instead of just repeating the original total?

Accepted Answer

Adding a dimension to the view changes the granularity at which an aggregated measure — including a distinct count — is computed, so COUNTD(Customer ID) is recalculated separately within each region rather than repeating one overall figure. The aggregation function itself does not automatically change to SUM, Region remains a dimension, and distinct-count aggregations are affected by added dimensions just like any other aggregation.

Analytics-101 — Salesforce Certified Tableau Desktop Foundations