Salesforce Certified Tableau Desktop Foundations — Practice Set 4

Question 1

A candidate is timed during the exam and needs to quickly decide: for a dataset that changes every few minutes and must always show the latest figures the moment the workbook is opened, which connection type should be chosen?

Accepted Answer

A live connection queries the source directly each time, so it reflects near-real-time changes as long as network access to the source is available — matching the requirement for always-current data. An extract would need to be refreshed to pick up new changes, and 'packaged workbook' and 'data source alias' are not connection types at all.

Question 2

During a scenario-based question, you're told an author saved metadata properties — including calculated fields and formatting — separately from the raw data, so the configuration could be reused across projects. Which file format does this describe?

Accepted Answer

The .TDS format stores only the connection metadata and customizations (calculated fields, formatting, aliases) without embedding the raw data, making it reusable across different workbooks/projects. .TWBX bundles the data as well, .HYPER is the extract engine's data file, and .CSV is a plain raw data export, not a metadata-only format.

Question 3

You are given: a Products table (one row per SKU) and a Sales Transactions table (many rows per SKU, since each purchase is its own row), and the requirement to build a single data source where each table keeps its native granularity, letting Tableau determine the correct aggregation context per worksheet automatically. What is the correct technique?

Accepted Answer

A relationship is the correct technique because it explicitly preserves each table's native level of detail (SKUs vs. individual transactions) and lets Tableau determine the appropriate aggregation context automatically per worksheet — the defining behavior contrasted with a join in the exam guide's 'join versus relationship' objective. A join would flatten both tables to one shared grain, a union stacks similarly-structured tables, and an extract refresh schedule is unrelated to table-combination technique.

Question 4

A field named 'zip_code' is currently treated as a plain number and does not appear as an option when building a map. What is the most likely fix?

Accepted Answer

Assigning the ZIP Code geographic role tells Tableau to interpret the field's values as postal codes so they can be plotted on a map — this is the specific fix for the described symptom. Converting to Boolean, creating a union, or simply renaming the field would not give Tableau the geographic context needed for mapping.

Question 5

Under exam time pressure, you see this scenario: an author wants every worksheet using a Discount field to automatically show values as a percentage (e.g., 15%) instead of a raw decimal (0.15), without manually formatting each new sheet. What single change accomplishes this most efficiently?

Accepted Answer

Changing the field's default number format applies that formatting automatically wherever the field is used going forward, satisfying the 'without manually formatting each new sheet' requirement efficiently. Filtering doesn't affect display format, creating a new calculated field per worksheet is the opposite of efficient reuse, and geographic role is unrelated to numeric formatting.

Question 6

A candidate reviews an exam item describing a field where each stored value like 'M' and 'F' should instead display as 'Male' and 'Female' throughout the workbook, without altering the raw data. Which feature satisfies this?

Accepted Answer

Assigning aliases changes only the displayed labels for specific stored values (e.g., 'M' shown as 'Male') without altering the underlying raw data, which is exactly the described requirement. Changing data type, creating an extract, or adding to a hierarchy do not address relabeling individual value displays.

Question 7

A candidate must choose the best chart for showing monthly revenue trending upward over the past 24 months, with the ability to spot seasonal dips clearly. Which chart type should be selected?

Accepted Answer

A line chart is the standard choice for visualizing a trend over a continuous time dimension, making upward trends and seasonal dips easy to identify. A density map addresses geographic concentration, a crosstab is a numeric table without a visual trend line, and a scatterplot compares two measures as points rather than showing change over time.

Question 8

A scenario describes SUM(Units Sold) as bars and SUM(Revenue) as a line, where Revenue values are roughly 100x larger than Units Sold, and both need to remain visible and readable together with independent scaling. What should the candidate implement?

Accepted Answer

A dual axis chart is specifically designed for this situation — two measures with very different magnitudes, each needing its own independently scaled axis to remain visually readable together. A combined axis chart would force both onto one shared scale, likely making Units Sold nearly invisible; dropping one measure abandons the requirement; a crosstab does not provide the visual axis comparison requested.

Question 9

In a timed exam scenario, you must quickly identify which chart type is best to visualize correlation between Advertising Spend and Units Sold across many campaigns, at the individual campaign level.

Accepted Answer

A scatterplot plots two continuous measures against each other at the individual record level, making it the standard choice for visualizing correlation between two numeric variables like Advertising Spend and Units Sold. A stacked bar sums categorical segments, a highlight table encodes magnitude via cell color in a table, and a density map addresses geographic point concentration.

Question 10

The exam presents this scenario: three product SKUs need to be treated as one combined 'Legacy Products' category for a single report, without modifying the source data or writing a calculation. Which feature should the candidate select?

Accepted Answer

A group is created directly in the view or data pane to combine specific dimension members into a new category, with no calculation required and no change to the source data — matching this exact requirement. A set typically models conditional or dynamic membership (like top-N), a parameter accepts user input, and a hierarchy organizes drill-down levels rather than combining members into one label.

Question 11

A scenario item asks the candidate to enable drilling from Year down to Quarter down to Month within a single worksheet using the plus/minus icons on headers. What must be configured first?

Accepted Answer

A hierarchy nesting Year, Quarter, and Month allows users to click expand/collapse icons on headers to drill up and down between levels within the same view — exactly what's being asked for. A set defines custom conditional membership, a parameter is a single adjustable input, and a bin groups continuous values into fixed-width buckets rather than nesting hierarchical drill levels.

Question 12

In a simulated exam question, a dashboard must only ever display transactions from the trailing 7 days regardless of when it's viewed, with no manual updates required. Which filter satisfies this?

Accepted Answer

A relative date filter recalculates its window (such as 'last 7 days') automatically based on the current date, requiring no manual updates — precisely satisfying the requirement. A fixed date range or a context filter with an exact date would both need to be manually changed to stay current, and a quick table calculation performs computations rather than filtering rows.

Question 13

During the exam, a question describes segmenting a continuous 'Order Value' measure into $0-$50, $50-$100, $100-$150, etc., fixed-width buckets to analyze the distribution of order sizes. Which feature is required?

Accepted Answer

A bin divides a continuous measure into fixed-size intervals, which is exactly the technique for building fixed-width buckets like $0-$50, $50-$100, etc., to analyze a distribution. A hierarchy nests categorical drill-down levels, a group combines existing categorical members, and a set defines conditional/dynamic membership — none of which segment a continuous range into equal-width buckets.

Question 14

A scenario-based item states: management wants to see each region's percentage contribution to total company sales, recalculated automatically as filters change. Which feature is the most direct fit?

Accepted Answer

The 'percent of total' quick table calculation automatically computes each row's/mark's share of the overall total and recalculates as filters are applied — directly matching this requirement. A reference line only annotates a fixed or computed value on an axis, a geographic role affects mapping, and an alias only changes a value's display label.

Question 15

The exam asks: a finance report needs an additional row summarizing the sum of all regional values shown above it. What feature should be enabled to add this?

Accepted Answer

Show Totals adds a summarizing grand total (and/or subtotal) row or column reflecting the aggregation of the values already in view, matching this requirement directly. The data highlighter searches/highlights marks, viz animation transitions between states, and a URL action opens external links — none of which add a totals row.

Question 16

In a simulated question, an author needs bars colored on a gradient from light to dark based on SUM(Profit), so higher-profit bars appear visually darker. Which Marks card property achieves this?

Accepted Answer

Placing SUM(Profit) on the Color property applies a gradient encoding to the marks based on that measure's values, achieving the light-to-dark shading described. Detail only adds granularity without a visual encoding, tooltip controls hover-over text, and label displays text values on marks rather than applying color.

Question 17

The exam presents a scenario where clicking a customer's name in one worksheet should filter every other worksheet on the dashboard down to just that customer's data. Which dashboard action should be configured?

Accepted Answer

A filter action propagates a selected value (like a clicked customer name) as a filter to other worksheets on the same dashboard, exactly matching the requirement. A highlight action would emphasize matching marks without filtering out the rest of the data, a URL action opens external links, and a parameter control is a manual input widget rather than a click-driven filter mechanism.

Question 18

A scenario-based item describes a dashboard that must rearrange its layout automatically for tablet users compared to the default desktop arrangement. What should the candidate configure?

Accepted Answer

Configuring a tablet-specific dashboard layout allows the author to define an alternate arrangement of dashboard objects tailored to tablet screens, separate from the default layout. A story point sequence addresses narrative presentation, not responsive layout; a calculated field and a data source filter are unrelated to device-based layout adjustments.

Question 19

During the exam, a question describes building a guided walkthrough of five captured dashboard states to present quarterly results to executives step by step. What should be created?

Accepted Answer

A story with multiple story points is Tableau's built-in mechanism for presenting a sequential, guided narrative through several captured worksheet/dashboard states — matching the description exactly. Parameters, sets, and bins are unrelated analysis features and do not provide sequential narrative presentation.

Question 20

The exam scenario states an analyst must inspect and then export the individual transaction records behind an aggregated 'Total Sales' bar for a specific region. What is the correct first step?

Accepted Answer

Viewing the underlying data for the selected mark reveals the individual, disaggregated records that make up that bar, and provides an option to export them — directly addressing the request. Changing a date field's treatment, adding a reference line, or publishing to Server do not surface or export row-level records behind a mark.

Question 21

A scenario asks which export format is most appropriate for embedding an interactive Tableau dashboard directly into a live board presentation, retaining full visual formatting but not necessarily requiring the recipient to have Tableau installed for viewing images of it.

Accepted Answer

Exporting to Microsoft PowerPoint converts dashboards into editable, presentable slides suitable for a board meeting without requiring Tableau to be installed to view them. A .csv export loses all visual formatting, a .tds file stores only connection metadata, and a .hyper file is a raw extract data file — none suited to a slide presentation.

Question 22

A scenario-based exam question describes a Customer Satisfaction Score field that is numeric but is only ever used to categorize customers into rating buckets, never summed. Which field type designation best fits typical usage here?

Accepted Answer

Even though the score is numeric, its intended use — categorizing customers rather than being aggregated — matches the definition of a dimension, which is used to segment and categorize data. Measures are meant for aggregation (sums, averages), and parameters and hierarchies are unrelated field type designations.

Question 23

The exam asks which color Tableau uses by default to indicate a field pill is being treated as continuous.

Accepted Answer

Tableau's standard convention colors continuous field pills green and discrete field pills blue, providing an immediate visual cue about how a field is currently treated. Orange and purple are not part of this standard discrete/continuous convention.

Question 24

A scenario describes a candidate comparing two versions of the same worksheet: one showing 'Year' as a discrete field and one showing 'Year' as a continuous field on Columns. What is the key visual difference the candidate should expect?

Accepted Answer

This is the fundamental visual distinction the exam tests: discrete fields render as distinct, separated headers, while continuous fields render as a smooth, unbroken axis. Year does not change its fundamental field type when displayed continuously (it becomes a continuous date treatment, not a dimension conversion), and neither treatment automatically adds a trend line.

Question 25

The final scenario in this set: a worksheet shows MAX(Order Date) with no dimensions in view, returning a single most-recent date. The candidate adds Sales Rep to Rows and the value shown per row changes. What explains this?

Accepted Answer

Adding a dimension to the view changes the level of detail an aggregated measure is computed at, so MAX(Order Date) is recalculated separately per sales rep rather than repeating one overall figure. Tableau does not auto-swap MAX to MIN, and Order Date's underlying type designation doesn't change just because it's being aggregated with MAX.

Analytics-101 — Salesforce Certified Tableau Desktop Foundations