I85PREP
⌘ K
Tableau Desktop Specialist study materials
Tableau Desktop Specialist study resources

Tableau Desktop Specialist practice questions

One question at a time. Build your Tableau Desktop Specialist understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Connect to and Prepare Data

What is the primary purpose of creating a data extract in Tableau Desktop?

  1. To store a local copy of the data for faster queries Correct answer.
  2. To define a logical relationship between two tables in the same database
  3. To publish a workbook to Tableau Server
  4. To convert a measure into a dimension

Explanation

An extract is a saved, compressed snapshot of the data stored locally as a .hyper file, which speeds up queries and lets you work without a live connection. Extracts can be refreshed on demand or on a schedule.

Question 2Connect to and Prepare Data

You connect live to a database. Which statement describes how Tableau reads the data?

  1. Tableau sends queries to the database each time the view changes. Correct answer.
  2. Tableau caches the data on Tableau Server.
  3. Tableau refreshes the data every hour automatically.
  4. Tableau copies the tables into a .hyper file at connection time.

Explanation

With a live connection Tableau issues queries to the source database whenever the view needs data, so results reflect the current state of the database. No local copy is kept unless you create an extract.

Question 3Connect to and Prepare Data

When should you turn on the Data Interpreter?

  1. When the connection uses a custom SQL query
  2. When the workbook needs to be saved as a packaged workbook file
  3. When an Excel sheet has merged cells or extra headers Correct answer.
  4. When the data source contains rows that need to be unioned together

Explanation

The Data Interpreter scans a worksheet for the real table structure and strips out titles, footers, blank rows and merged-cell artifacts before the data is read. It is intended for messy Excel and some text sources rather than for reshaping tidy data.

Question 4Connect to and Prepare Data

Which connection option is available when you connect to a CSV file in Tableau Desktop?

  1. Specifying the field separator and character set Correct answer.
  2. Creating a relationship to a cube
  3. Setting the aggregation level
  4. Choosing a map layer

Explanation

The text-file connection dialog lets you set the separator, text qualifier, character set and whether the first row contains field names. These settings tell Tableau how to parse the file into columns.

Question 5Connect to and Prepare Data

A field containing ZIP codes such as 01234 imports as a number and loses its leading zero. What change preserves the leading zero?

  1. Set the field's geographic role to ZIP Code
  2. Set the field's data type to String Correct answer.
  3. Convert the field to a measure
  4. Add the field to the Filters shelf

Explanation

A leading zero is meaningful only when the value is stored as text, because numeric types drop it. Changing the data type to String preserves the characters exactly, and a geographic role can still be applied afterwards.

Question 6Connect to and Prepare Data

How do you make Tableau recognize a field of country names as mappable?

  1. Add the field to the Measure Values card
  2. Convert the field to a measure with a SUM aggregation
  3. Change the field to a dimension and place it on the Columns shelf
  4. Assign the Country/Region geographic role to the field Correct answer.

Explanation

Geographic roles tell Tableau which geocoding scheme to use for a field, such as Country/Region, State/Province or ZIP Code. Without a geographic role the field is treated as ordinary text and cannot generate a map.

Question 7Connect to and Prepare Data

What does creating an alias for a dimension member do?

  1. It duplicates the member as a new row in the data source.
  2. It permanently renames the value in the underlying database for every user.
  3. It shows a friendlier label but leaves the underlying value unchanged. Correct answer.
  4. It converts the dimension into a measure.

Explanation

An alias changes only how members are displayed in the view and in filters; the stored values used for calculations and joins stay the same. Aliases are set from the dimension's context menu.

Question 8Connect to and Prepare Data

In a left join between an Orders table (left) and a Returns table (right), what happens to orders with no matching return?

  1. They are duplicated once for each unmatched return.
  2. They are removed from the result.
  3. They appear only after a union is applied.
  4. They are kept, with null values in the Returns columns. Correct answer.

Explanation

A left join returns every row from the left table plus matching rows from the right table. Where no right-side row matches, the right-side columns contain nulls.

Question 9Connect to and Prepare Data

Which join type returns every row from both tables, matching records where a key exists?

  1. Inner join
  2. Full outer join Correct answer.
  3. Right join
  4. Left join

Explanation

A full outer join keeps unmatched rows from both sides, filling the missing side with nulls. Inner joins keep only matches, while left and right joins keep all rows from one side only.

Question 10Connect to and Prepare Data

You need to append the rows of a 2023 sales table to a 2024 sales table that has identical columns. Which feature do you use?

  1. A relationship built on a calculated key
  2. A data blend on the year field
  3. A left join on the order ID
  4. A union of the two tables Correct answer.

Explanation

A union stacks the rows of two tables that share the same column structure. Columns that exist in only one table are padded with nulls rather than causing an error.

Question 11Connect to and Prepare Data

A spreadsheet has one row per customer and one column per month (Jan, Feb, Mar, and so on). You want month to become a single field. Which feature do you use?

  1. Split
  2. Pivot Correct answer.
  3. Data Interpreter
  4. Union

Explanation

Pivoting turns columns into rows, creating a field for the month and a field for the value, which normalizes a crosstab layout. It is the standard fix when header names are really data values.

Question 12Connect to and Prepare Data

A field holds values such as 'Smith, John'. Which feature separates the last name from the first name?

  1. Split Correct answer.
  2. Group
  3. Hierarchy
  4. Alias

Explanation

Split uses a delimiter or a repeating pattern to break one field into several. Splitting 'Smith, John' on the comma yields a last-name field and a first-name field.

Question 13Connect to and Prepare Data

You want a text table in which Sales, Profit and Quantity each appear on its own row for every Region. Which field must go on the Rows shelf along with Region?

  1. Multiple Values
  2. Number of Records
  3. Measure Names Correct answer.
  4. Measure Values

Explanation

Measure Names is a special dimension that holds the names of the measures in the data source. With Measure Values on the Text card, placing Measure Names on Rows creates one row per measure.

Question 14Connect to and Prepare Data

An extract of a very large table takes too long to refresh. Which approach reduces the extract size while keeping only relevant records?

  1. Changing the workbook's number format
  2. Adding a context filter to a worksheet
  3. Adding a data source filter before creating the extract Correct answer.
  4. Placing Measure Values on the Text card

Explanation

A data source filter limits the rows Tableau reads, so the extract itself contains fewer records and refreshes faster. Worksheet filters and context filters do not shrink the extract.

Question 15Connect to and Prepare Data

You want to share only the connection details of a data source, with no data and no worksheets. Which file do you save?

  1. .tdsx
  2. .hyper
  3. .twbx
  4. .tds Correct answer.

Explanation

A .tds file stores only connection information and data source customizations, not the data or the worksheets. A .tdsx packages the data source together with its data, and a .twbx packages a whole workbook.

Question 16Connect to and Prepare Data

You hide a field in the Data pane. What is the effect?

  1. The underlying column is dropped from the extract.
  2. It is removed from the Data pane but still exists in the source. Correct answer.
  3. The field can no longer be used in any calculation.
  4. The field is deleted from the data source for all users.

Explanation

Hiding a field only removes it from the Data pane; the field remains in the data source and can still be referenced by calculations and existing worksheets. Deleting a field removes it from the data source entirely.

Question 17Connect to and Prepare Data

You drag the Sales measure to the Filters shelf and choose SUM(Sales) greater than 1,000. What kind of filter is created?

  1. A data source filter applied before any other filter
  2. An aggregate filter evaluated after dimension filters Correct answer.
  3. An extract filter applied when the extract refreshes
  4. A context filter that creates a temporary table

Explanation

When a measure is placed on Filters, Tableau aggregates it and applies the filter after dimension filters have been evaluated. Adding the filter to Context changes that order, because context filters run first.

Question 18Connect to and Prepare Data

Which situation calls for data blending rather than a join?

  1. Two sources cannot be joined and have different levels of detail. Correct answer.
  2. One Excel sheet needs its merged headers cleaned.
  3. Two tables with identical structure need appended rows.
  4. Two tables in the same database share a common key.

Explanation

Blending combines two sources at the worksheet level when they cannot be joined, for example because they live in different systems or have different granularity. A join requires the tables to be combined inside one data source.

Question 19Connect to and Prepare Data

A workbook points to a test database, and you want to switch it to a production database with an identical schema. Which command preserves the existing worksheets?

  1. Replace Data Source Correct answer.
  2. Refresh the extract
  3. Create a new data source and rebuild the sheets
  4. Edit Connection and then create a new extract

Explanation

Replace Data Source swaps one connection for another and remaps fields by name, so worksheets and calculations keep working. It is the standard way to promote a workbook from test to production.

Question 20Connect to and Prepare Data

How does Tableau treat a null value in a numeric measure by default?

  1. As a separate category that can never be filtered
  2. As a missing value ignored by most aggregations Correct answer.
  3. As an error that blocks the view from rendering
  4. As zero in every calculation and display

Explanation

Nulls represent missing data and are excluded from most aggregations such as SUM and AVG; ZN() converts them to zero when arithmetic requires a value. Special Values settings control whether nulls are displayed or filtered out.

Question 21Connect to and Prepare Data

What distinguishes a relationship from a physical join in Tableau's logical layer?

  1. It joins at the sheet's level of detail and does not duplicate rows. Correct answer.
  2. It cannot be used when the data source is an extract.
  3. It always performs a full outer join between the tables.
  4. It requires both tables to come from the same database connection.

Explanation

Relationships are logical: Tableau decides the join type and aggregation at query time based on the sheets that use the tables, which prevents row duplication. Physical joins are computed in the data source and can multiply rows.

Question 22Connect to and Prepare Data

What happens when you add a filter to Context?

  1. It applies only to the current worksheet, unlike other filters.
  2. It disables the use of Measure Names in the view.
  3. It runs before other filters, so later filters see only the context rows. Correct answer.
  4. It converts the data source to an extract automatically.

Explanation

Context filters are computed first and produce a temporary result set; subsequent filters and FIXED level-of-detail calculations operate on that reduced set. This is why context filters are used together with Top N filters and LOD expressions.

Question 23Connect to and Prepare Data

A field contains values such as 'A-B-C-D'. You need only the final two segments as separate fields. Which option do you use?

  1. Automatic Split with a hyphen delimiter
  2. Pivot with the field placed on Rows
  3. Group the field values by their first letter
  4. Custom Split with a hyphen separator, splitting off the last two fields Correct answer.

Explanation

Custom Split lets you choose the separator and then split off the first or last N fields, or split at fixed character positions. Automatic Split would instead create a field for every segment.

Question 24Connect to and Prepare Data

Which statement about cross-database joins in Tableau Desktop is correct?

  1. Tableau performs the join, so it can be slower than an in-database join. Correct answer.
  2. Cross-database joins require the tables to be extracted first.
  3. Cross-database joins are always performed by the underlying database server.
  4. Cross-database joins can only combine tables from the same connection.

Explanation

With a cross-database join Tableau pulls data from each connection and performs the join itself, which can be slower than a join executed inside a single database. It exists so tables from different connections can be combined.

Question 25Connect to and Prepare Data

A calculated field uses both [Sales] and [Region] and returns an error about mixing aggregate and non-aggregate arguments. Which change resolves the error?

  1. Convert the measure to a dimension before using it.
  2. Wrap the dimension in an aggregation such as ATTR([Region]). Correct answer.
  3. Place the calculation on the Filters shelf.
  4. Change the connection to use an extract.

Explanation

Within a single calculation every argument must be at the same level of aggregation. Wrapping the dimension in an aggregate such as ATTR, MIN or MAX, or removing the aggregation from the other term, resolves the conflict.

Question 26Connect to and Prepare Data

After connecting to a new data source, which area of the workbook shows the connected tables, the field data types, and a preview of the rows before any worksheet is built?

  1. The Data Source page Correct answer.
  2. The Format pane on a worksheet
  3. The Analytics pane on a worksheet
  4. The dashboard layout tree

Explanation

The Data Source page is the workspace where connections, tables, field data types and a preview of the rows are reviewed before any analysis begins. The other panes listed only affect an existing worksheet or dashboard.

Question 27Connect to and Prepare Data

An Excel file begins with a report title, two blank rows, and a merged header band above the real table. Which feature should you turn on so Tableau finds the actual column headers?

  1. Data Interpreter Correct answer.
  2. Top N filter
  3. Incremental refresh
  4. Data blending

Explanation

Data Interpreter is a Tableau option that strips out titles, blank rows, footnotes and merged cells so the true header row becomes the first row of the table. It is available for Excel, text and some other file connections.

Question 28Connect to and Prepare Data

Which connection mode stores a local copy of the data that can be refreshed on a schedule?

  1. Extract Correct answer.
  2. Data blend
  3. Live connection
  4. Custom SQL connection

Explanation

An extract saves a copy of the data in Tableau's own format, which can be refreshed on demand or on a schedule and often performs faster. A live connection queries the source each time instead of storing a copy.

Question 29Connect to and Prepare Data

A field named Customer ID holds whole numbers and Tableau aggregates it by default. You want it listed as a discrete identifier instead. What should you do?

  1. Create an alias for each member of the field
  2. Add the field as the lowest level of a new hierarchy
  3. Change the field's default number format to a text pattern
  4. Convert to Dimension Correct answer.

Explanation

The role of a field decides whether Tableau aggregates it (measure) or groups by it (dimension). Converting the numeric identifier to a dimension makes Tableau treat each value as a discrete header rather than a sum.

Question 30Connect to and Prepare Data

You want Country, State, and City to drill from one to the next as a single field in the Data pane. What should you build?

  1. A group
  2. A hierarchy Correct answer.
  3. A parameter
  4. A set

Explanation

A hierarchy stacks related fields so users can drill down or roll up through levels in a single view. Dragging one field onto another in the Data pane creates a hierarchy automatically.

Question 31Connect to and Prepare Data

When you drag a numeric measure such as Sales onto a shelf, which aggregation does Tableau apply by default?

  1. COUNT
  2. SUM Correct answer.
  3. AVG
  4. MAX

Explanation

Tableau's default aggregation for a measure is SUM, so Sales is totaled at whatever level of detail the view uses. The aggregation can be changed from the field's pill menu or from the field's default properties.

Question 32Connect to and Prepare Data

You want several individual states to appear as one member called "Mountain" in a view, without editing the source data. Which feature do you use?

  1. A parameter
  2. A group Correct answer.
  3. A hierarchy
  4. An alias

Explanation

A group lets you combine selected dimension members into a single new member that exists only in Tableau, leaving the underlying data untouched. Selecting members and choosing Group creates the combined member.

Question 33Connect to and Prepare Data

Which file extension identifies a Tableau extract?

  1. .twb
  2. .tds
  3. .twbx
  4. .hyper Correct answer.

Explanation

Extracts are stored as .hyper files in Tableau's columnar engine format. The other extensions denote a data source file, a workbook, and a packaged workbook respectively.

Question 34Connect to and Prepare Data

You want every worksheet that uses a given data source to see only orders from 2024, and you want that restriction applied before other filters. Which filter should you create?

  1. A data source filter Correct answer.
  2. A table calculation filter
  3. A quick filter on one worksheet
  4. A context filter on each sheet

Explanation

A data source filter is saved with the data source, so it applies to every worksheet built on it and is evaluated ahead of worksheet filters. It can also be used to limit what an extract contains.

Question 35Connect to and Prepare Data

You want a view that always shows only the 10 products with the highest SUM(Sales), recalculating as data changes. Which filter type fits?

  1. A wildcard match filter on Product
  2. A data source filter on Product
  3. A Top N filter on Product by Sales Correct answer.
  4. An extract filter on Product

Explanation

A Top N filter ranks dimension members by a measure and keeps the top (or bottom) N, refreshing as the data changes. It is configured from the Top tab of a dimension filter.

Question 36Connect to and Prepare Data

A quick filter for Region was created on Sheet 1. Sheet 2 uses the same data source and needs the same filter. What is the most efficient step?

  1. Copy the second sheet's filter card from the first
  2. Apply the filter to All Using This Data Source Correct answer.
  3. Manually recreate the identical quick filter on the second sheet
  4. Add Region to the Context of the second sheet

Explanation

The Apply to Worksheets option on a filter card can push one filter to every sheet that uses the same data source, keeping the filter definition in one place. Recreating filters sheet by sheet risks drift between views.

Question 37Connect to and Prepare Data

When you create a new relationship between two logical tables, which cardinality does Tableau use if it cannot determine it from the data?

  1. One-to-one
  2. One-to-many
  3. Many-to-one
  4. Many-to-many Correct answer.

Explanation

Tableau defaults an undetermined relationship to many-to-many, which is the most permissive setting and cannot drop records. The cardinality can be changed later from the relationship's properties.

Question 38Connect to and Prepare Data

Two tables have no common key: one stores email in lowercase, the other in mixed case. Which approach lets a join succeed?

  1. A pivot that rotates email into rows
  2. A union that stacks both tables into one
  3. A join calculation using LOWER() on both fields Correct answer.
  4. A data blend that links the two email fields

Explanation

A join calculation creates a temporary matching key in Tableau, so functions such as LOWER() can normalize both sides before matching. This avoids altering either underlying table.

Question 39Connect to and Prepare Data

A .csv file uses semicolons as separators and Tableau shows the entire row in one column. What should you change?

  1. The field separator in the text file options Correct answer.
  2. The workbook's default locale setting
  3. The field's data type from string to number
  4. The connection mode from live to extract

Explanation

Text file connections expose a separator setting, and Tableau only detects common delimiters automatically. Setting the separator to semicolon parses each line into the correct columns.

Question 40Connect to and Prepare Data

A CSV column holds values such as 1200 and N/A. Which data type does Tableau assign to the column?

  1. Number (whole)
  2. Boolean
  3. String Correct answer.
  4. Number (decimal)

Explanation

When a single column mixes numeric and non-numeric text, Tableau treats the field as a string so no values are lost. The field can be retyped manually once the offending values are handled.

Question 41Connect to and Prepare Data

On the Data Source page, which area shows each field's name, data type, and the remote column it comes from?

  1. The metadata grid Correct answer.
  2. The data grid preview
  3. The Analytics pane
  4. The filter shelf

Explanation

The metadata grid sits above the data grid and lists field-level details such as name, data type and remote source column. The data grid below it shows the actual row values.

Question 42Connect to and Prepare Data

You must send a colleague a data source that includes its local Excel file so it opens on their machine without access to your drive. Which file do you save?

  1. A packaged data source (.tdsx) Correct answer.
  2. A workbook file (.twb)
  3. A data source file (.tds)
  4. A bookmark file (.tbm)

Explanation

A packaged data source bundles the connection information together with the underlying local file, so it can be opened elsewhere. A plain data source file stores only the connection details and assumes the file is reachable.

Question 43Connect to and Prepare Data

You rename "Cust Name" to "Customer" in the Data pane. What happens in the underlying database?

  1. A new calculated column is written to the database
  2. All dependent worksheets break until the data is refreshed
  3. Nothing; only the Tableau field name changes Correct answer.
  4. The database column is renamed to Customer

Explanation

Renaming in the Data pane changes only the label Tableau uses for the field; the source column keeps its original name. Views that reference the field update automatically because they point to the field, not the label.

Question 44Connect to and Prepare Data

You want Sales shown with a currency format in every worksheet that uses it. Where do you set this?

  1. The Format pane, one worksheet at a time
  2. The Edit Axis dialog of every view
  3. The workbook locale option in the Data menu
  4. Default Properties > Number Format on the field Correct answer.

Explanation

Default Properties on a field store workbook-level defaults such as number format and aggregation, so the setting carries into every worksheet that uses the field. Per-sheet formatting overrides can still be applied afterward.

Question 45Connect to and Prepare Data

You need to connect to a database table but must first filter and reshape it with SQL that runs on the server. Which connection option do you use?

  1. A relationship between two tables
  2. A wildcard union
  3. Data Interpreter
  4. Custom SQL Correct answer.

Explanation

Custom SQL lets you supply your own query as the data source, so filtering and shaping happen on the database server before Tableau sees the results. It is available on relational connections rather than file-based ones.

Question 46Connect to and Prepare Data

Which extract setting lets Tableau know that join keys are guaranteed to match, allowing some join clauses to be omitted from queries on the extract?

  1. Extract filters
  2. Assume Referential Integrity Correct answer.
  3. Hide unused fields
  4. Incremental refresh

Explanation

Assume Referential Integrity tells Tableau the join keys are valid, so queries can skip joins that would only be needed to eliminate unmatched rows. It can improve performance when the data truly satisfies that condition.

Question 47Connect to and Prepare Data

An Orders table is joined to a Returns table where one order can have several returns. What happens to SUM(Sales) in the view?

  1. It inflates because order rows repeat for each return Correct answer.
  2. It becomes null for orders that have returns
  3. It shrinks because returns subtract from sales
  4. It is unaffected, since Tableau sums only distinct order values

Explanation

A physical join produces one row per matching combination, so an order with three returns appears three times and its Sales is counted three times. This row inflation is resolved by changing the join, the level of detail, or by using a relationship.

Question 48Connect to and Prepare Data

Where is an extract filter applied?

  1. Each time a worksheet queries the data source
  2. Only when the workbook is first opened
  3. After table calculations are computed
  4. When the extract is created or refreshed Correct answer.

Explanation

Extract filters are evaluated while the extract is built or refreshed, so the excluded rows never enter the extract file. Because the data is already gone, the filter cannot be overridden later by a worksheet filter.

Question 49Connect to and Prepare Data

On the Data Source page, what happens when you drag a second table and drop it directly onto an existing table on the canvas?

  1. A blend is created between the two tables
  2. A union is created, stacking the rows of both tables
  3. A physical join is created between the two tables Correct answer.
  4. A relationship is created in the logical layer

Explanation

Dropping a table onto another table nests them in the physical layer and defines a join, with join type and clauses editable there. Dropping a table on empty canvas space next to an existing table creates a logical relationship instead.

Question 50Connect to and Prepare Data

An Orders table is related to an Order Line table at a different level of detail. Shipping Cost exists only in Orders. What does Tableau return when you show Shipping Cost by Product, a field from Order Line?

  1. It repeats Shipping Cost once per order line, inflating totals
  2. It aggregates Shipping Cost at the Orders level Correct answer.
  3. It blocks the view until the tables are joined
  4. It returns null for products on multi-line orders

Explanation

In the logical layer each table keeps its own level of detail, so a measure from Orders is aggregated at the Orders grain and is not duplicated across order lines. This is the key difference from a physical join, where the Orders value would repeat per line.