I85PREP
⌘ K
Tableau Data Analyst study materials
Tableau Data Analyst study resources

Tableau Data Analyst practice questions

One question at a time. Build your Tableau Data Analyst 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 1Data Preparation and Connection

In Tableau, which file type stores an extract of a data source as a compressed snapshot that can be refreshed independently of the original connection?

  1. A .tds data source file
  2. A .tde connection file
  3. A .hyper extract file Correct answer.
  4. A .twb workbook file

Explanation

Tableau extracts are saved in the .hyper format, which holds a compressed snapshot of the data that can be refreshed on a schedule. Workbooks (.twb) and data source definitions (.tds) store metadata and connection details rather than the extracted rows.

Question 2Data Preparation and Connection

A user wants to combine two tables where every row from the left table is kept and matching rows from the right table are added where available. Which join type should be used?

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

Explanation

A left join preserves all rows from the left table and appends matching columns from the right table, filling nulls where no match exists. Inner joins keep only matches, right joins preserve the right table, and full outer joins preserve both sides.

Question 3Data Preparation and Connection

What is the primary purpose of a union in Tableau's physical layer?

  1. To append rows from one table beneath another Correct answer.
  2. To aggregate measures before loading
  3. To match rows across tables on a key
  4. To rename fields for clarity

Explanation

A union stacks the rows of two or more tables into a single result, adding rows rather than columns. Joins combine columns by matching keys, and renaming or aggregating are separate operations.

Question 4Data Preparation and Connection

Which Tableau feature lets an analyst define a reusable logical grouping of members, such as combining several product codes into one category, without altering the underlying data?

  1. A calculated field using IF
  2. A parameter
  3. A bin
  4. A group Correct answer.

Explanation

Groups create a named cluster of dimension members that behave as a single value in views. Calculated fields create new fields, bins bucket continuous measures, and parameters supply user-controlled values rather than remapping members.

Question 5Data Preparation and Connection

What does the Data Interpreter do when enabled on a connection?

  1. It repairs broken joins automatically
  2. It encrypts the connection credentials
  3. It removes extra header, title, and footer rows so the table is read cleanly Correct answer.
  4. It converts all measures to dimensions

Explanation

The Data Interpreter cleans up common spreadsheet clutter such as titles, blank rows, and merged headers so the actual table is parsed correctly. It does not alter joins, field roles, or security.

Question 6Data Preparation and Connection

An analyst needs to relate two tables that have different levels of detail but should remain independent, without merging them into a single flat table. Which relationship approach is appropriate?

  1. Use a logical relationship between the tables Correct answer.
  2. Use a pivot of both tables
  3. Use a union of both tables
  4. Use a physical join with a full outer join

Explanation

Logical relationships keep tables independent at their own level of detail and match records at query time based on the fields used in the view. Joins, unions, and pivots all alter the physical table structure instead.

Question 7Data Preparation and Connection

Which data type should a field containing values like '2023-04-15' be assigned so Tableau treats it as a date rather than text?

  1. String
  2. Boolean
  3. Date Correct answer.
  4. Integer

Explanation

Assigning the Date data type lets Tableau parse and use the values for date-based calculations and continuous or discrete date axes. String, Boolean, and Integer types would not interpret the values as calendar dates.

Question 8Data Preparation and Connection

What is the effect of setting a field's role to Measure in Tableau?

  1. The field is always shown as a discrete header
  2. The field is converted to a string
  3. The field is aggregated by default when placed on a shelf Correct answer.
  4. The field is excluded from extracts

Explanation

Measure-role fields are treated as numeric quantities that aggregate by default when used in a view. Dimensions provide the level of detail, and role assignment does not affect extract inclusion or data type.

Question 9Data Preparation and Connection

A source table stores monthly sales in separate columns named Jan, Feb, and Mar. The analyst wants a single Sales field with a Month column. Which Tableau operation accomplishes this?

  1. Union the table with itself
  2. Group the three columns
  3. Join the table to a calendar table
  4. Pivot the three columns into rows Correct answer.

Explanation

Pivoting reshapes wide data by turning multiple columns into a single column of values plus a column of names, producing the desired Month and Sales structure. Unions, joins, and groups do not change column layout.

Question 10Data Preparation and Connection

An analyst wants each row's value split into fixed-width numeric ranges for a histogram. Which feature creates these ranges?

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

Explanation

Bins divide a continuous measure into equal-width intervals, which is the basis for a histogram. Groups merge categorical members, sets define membership conditions, and hierarchies organize drill paths.

Question 11Data Preparation and Connection

A calculated field must return the string 'High' when Sales exceeds 10000 and 'Low' otherwise. Which calculation correctly implements this?

  1. CASE [Sales] > 10000 THEN 'High' END
  2. IF [Sales] > 10000 'High' ELSE 'Low'
  3. IIF([Sales], 'High', 'Low')
  4. IF [Sales] > 10000 THEN 'High' ELSE 'Low' END Correct answer.

Explanation

The IF...THEN...ELSE...END structure is the valid conditional syntax, requiring THEN and a closing END. Missing keywords or an incomplete CASE or IIF structure will fail to parse.

Question 12Data Preparation and Connection

A user connects to a database and wants to rename a field and change its default number format without editing the original database. Where should these changes be made so they persist in the data source?

  1. In the workbook's story points
  2. In the worksheet tooltip settings
  3. In the dashboard layout container
  4. In the data source's field default properties Correct answer.

Explanation

Field default properties in the data source let you rename fields and set default formats, which then apply everywhere the field is used. Worksheet, story, and dashboard settings affect presentation only, not the data source definition.

Question 13Data Preparation and Connection

When blending two data sources in a worksheet, what determines which records are included in the result?

  1. Records are matched by row position
  2. All records from both sources are always included
  3. Only records from the primary source are included
  4. Only records matching on the linking fields are included Correct answer.

Explanation

Data blending links a primary and secondary source on common fields and returns only the matching records from the secondary source. It does not combine all records, restrict to primary only, or align by row position.

Question 14Data Preparation and Connection

An analyst connects to a CSV file and needs to include a second CSV with the same column structure as additional rows. Which combination should be used?

  1. Relate the two files
  2. Union the two files Correct answer.
  3. Blend the two files
  4. Join on a shared key

Explanation

Unioning appends rows from files with matching column structure into one table, which fits adding more records of the same shape. Joins, blends, and relationships match on keys or fields rather than stacking rows.

Question 15Data Preparation and Connection

What is the main benefit of using a live connection instead of an extract?

  1. It compresses data to reduce file size
  2. It works offline without the source
  3. It returns the most current data from the source on each query Correct answer.
  4. It permanently stores a snapshot for fast reload

Explanation

A live connection queries the underlying source directly, so views reflect the current state of the data. Compression, offline use, and stored snapshots are characteristics of extracts.

Question 16Data Preparation and Connection

A field contains values with leading and trailing spaces that break grouping. Which calculated field function removes those spaces?

  1. UPPER([Field])
  2. LEFT([Field], 5)
  3. TRIM([Field]) Correct answer.
  4. LEN([Field])

Explanation

TRIM removes leading and trailing whitespace from a string, which normalizes values for grouping. LEN returns length, UPPER changes case, and LEFT returns a substring.

Question 17Data Preparation and Connection

Which statement best describes the difference between a logical table and a physical table in Tableau's data model?

  1. Logical tables apply filters; physical tables apply formatting
  2. Logical tables store extracts; physical tables store live data
  3. Logical tables hold joins; physical tables hold relationships
  4. Logical tables hold relationships; physical tables hold joins and unions Correct answer.

Explanation

The logical layer contains tables connected by relationships, while the physical layer contains tables combined by joins and unions within each logical table. Extracts, live data, filters, and formatting are separate concerns.

Question 18Data Preparation and Connection

An analyst needs to create a reusable connection definition, including custom calculations and renamed fields, that can be shared across multiple workbooks without the data itself. Which artifact should be saved?

  1. A data source file (.tds) Correct answer.
  2. A data extract (.hyper)
  3. A packaged workbook (.twbx)
  4. A bookmark (.tbm)

Explanation

A .tds file stores the connection, metadata, and calculations for a data source so it can be reused across workbooks. A packaged workbook bundles data, a bookmark stores worksheet views, and an extract stores data rows.

Question 19Data Preparation and Connection

A user wants rows where Region equals 'East' or 'West' to be treated as a single value in a view but still needs to drill into the original regions. Which feature best supports this?

  1. A group that combines the members and can be expanded Correct answer.
  2. A parameter replacing Region
  3. A bin on Region
  4. A calculated field that overwrites Region

Explanation

Groups combine dimension members into a single value while still allowing expansion to the original members. Overwriting the field loses the detail, bins require continuous data, and parameters substitute values rather than cluster members.

Question 20Data Preparation and Connection

Two tables are related in the logical layer, and a view uses fields from both. How does Tableau determine the level of detail for the result?

  1. It uses the grain of the physical join only
  2. It uses the dimensions placed in the view to set the grain Correct answer.
  3. It always uses the grain of the secondary table
  4. It uses the row order of the primary table

Explanation

With relationships, Tableau queries each logical table at the level of detail required by the dimensions in the view and matches records on the related fields. The grain is not fixed to a single table or to physical join behavior.

Question 21Data Preparation and Connection

A blended view shows nulls for a secondary measure even though matching records exist. Which condition most likely explains the nulls?

  1. The measure uses a SUM aggregation
  2. The primary source uses an extract
  3. The linking field is missing from the primary source's view Correct answer.
  4. The secondary source is a live connection

Explanation

Blending requires the linking field from the primary source to be present in the view for the match to occur; without it, secondary values return as nulls. Connection type, extract use, and aggregation choice do not cause this behavior.

Question 22Data Preparation and Connection

An analyst unions two files, but the second file has an extra column not present in the first. What happens to that column in the union result?

  1. The extra column values are copied into an existing column
  2. Rows from the first file receive nulls for the extra column Correct answer.
  3. The extra column is dropped from the result
  4. The union fails and cannot be created

Explanation

A union aligns columns by name, so columns present in only one input produce nulls for rows from the other input. The union still succeeds, the column is retained, and values are not merged into other fields.

Question 23Data Preparation and Connection

A calculated field uses a row-level expression in a blended view, but results appear inconsistent across sources. What is the most reliable way to ensure the calculation evaluates at the intended level?

  1. Move the calculation into the primary source or aggregate explicitly Correct answer.
  2. Rely on automatic aggregation of the blended measure
  3. Change the mark type to Text
  4. Convert the calculation to a parameter

Explanation

Row-level calculations in blended views can behave inconsistently because blending aggregates at the source level; placing the logic in the source or aggregating explicitly yields predictable results. Automatic aggregation, parameters, and mark type do not resolve the level-of-detail mismatch.

Question 24Data Preparation and Connection

A data source contains a field whose values mix numbers and text, causing aggregation errors. Which approach best resolves the issue while preserving usable numeric values?

  1. Convert the field to a bin
  2. Add the field to a hierarchy
  3. Change the field role to Dimension
  4. Use a calculation with a numeric conversion function and handle non-numeric values Correct answer.

Explanation

Mixed-type fields should be cleaned with a conversion function such as INT or FLOAT, ideally guarded so non-numeric values do not break the calculation. Changing role, adding a hierarchy, or binning does not fix the underlying type problem.

Question 25Data Preparation and Connection

An analyst needs to refresh an extract on a recurring schedule without manually opening the workbook. Which capability supports this?

  1. Enabling the Data Interpreter
  2. Adding the data source to a hierarchy
  3. Setting an extract refresh schedule on Tableau Server or Cloud Correct answer.
  4. Saving the workbook as a packaged workbook

Explanation

Extract refresh schedules configured on Tableau Server or Cloud refresh published extracts automatically. Packaging, hierarchies, and the Data Interpreter do not provide scheduled refresh.

Question 26Data Preparation and Connection

Which file type does Tableau Desktop connect to natively as a flat file data source?

  1. CSV Correct answer.
  2. PPTX
  3. DOCX
  4. PDF

Explanation

Tableau Desktop supports text-based flat files such as CSV and TXT directly as data sources. PDF, DOCX, and PPTX are document formats that Tableau does not treat as tabular data sources.

Question 27Data Preparation and Connection

Which connection type keeps a direct link to the source database so that every query reflects the current data at the time the view is rendered?

  1. Data blend
  2. Live connection Correct answer.
  3. Cross-database join
  4. Extract

Explanation

A live connection queries the underlying source each time a view is rendered, so results reflect the current state of the database. An extract stores a snapshot that must be refreshed to reflect changes.

Question 28Data Preparation and Connection

In Tableau, what does the data interpreter do when enabled on a Microsoft Excel connection?

  1. It creates a live connection to the Excel file instead of an extract.
  2. It detects and removes extra header rows, footers, and merged cells to clean up the table structure. Correct answer.
  3. It translates field names into the user's preferred language.
  4. It converts all text fields into measures automatically.

Explanation

The data interpreter examines the Excel sheet and removes extraneous rows, merged cells, and other formatting artifacts so the data begins at the correct header row. It does not change field roles, connection mode, or field-name language.

Question 29Data Preparation and Connection

Which Tableau feature lets an analyst pivot columns into rows so that several similarly named columns become a single field with a companion dimension?

  1. Split
  2. Join
  3. Pivot Correct answer.
  4. Union

Explanation

Pivoting reshapes a wide table into a tall table by turning selected columns into a single field, with a companion field identifying the original column. Split divides a single field's values, union appends rows, and join combines tables side by side.

Question 30Data Preparation and Connection

Which data type should be assigned to a field whose values are whole numbers that will be summed in a view?

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

Explanation

Whole numbers used in aggregation should be typed as Number (whole) so Tableau can sum them numerically. String, Boolean, and Date types do not support numeric aggregation such as sum.

Question 31Data Preparation and Connection

What is the purpose of a join in Tableau's physical layer?

  1. It combines columns from two tables based on matching key fields. Correct answer.
  2. It aggregates measures before the query is sent to the database.
  3. It creates a relationship between logical tables without merging them.
  4. It appends rows from two tables with identical structure.

Explanation

A join merges two physical tables horizontally by matching key values, producing a single combined table. Appending rows is a union, and relating logical tables is handled by relationships rather than joins.

Question 32Data Preparation and Connection

Which Tableau object stores a reusable set of connection details and published data that other workbooks can connect to?

  1. Parameter
  2. Calculated field
  3. Published data source Correct answer.
  4. Set

Explanation

A published data source packages connection information, tables, and metadata so multiple workbooks can reuse it. Calculated fields, parameters, and sets are workbook-level objects, not reusable connection definitions.

Question 33Data Preparation and Connection

What does a union do when applied to two tables in Tableau?

  1. It creates a relationship between the tables in the logical layer.
  2. It matches rows by key and adds columns side by side.
  3. It appends the rows of one table below the rows of the other. Correct answer.
  4. It removes duplicate rows from a single table.

Explanation

A union stacks the rows of multiple tables into one longer table, aligning columns by name or position. Matching rows by key to add columns is a join, and relationships are a separate logical-layer construct.

Question 34Data Preparation and Connection

An analyst wants to combine a table of orders with a table of returns so that every order row is kept even when no return exists. Which join type should be used?

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

Explanation

A left join keeps all rows from the left table and adds matching rows from the right table, leaving nulls where no match exists. An inner join would drop orders without returns, and a right join would keep all returns instead.

Question 35Data Preparation and Connection

A field contains values such as 'A-1024' and 'B-2048'. The analyst needs two separate fields: the letter prefix and the numeric suffix. Which Tableau feature accomplishes this?

  1. Group
  2. Split Correct answer.
  3. Bin
  4. Pivot

Explanation

The Split feature divides a field's values at a delimiter or pattern into multiple new fields. Pivot reshapes columns, group combines member values, and bin creates numeric ranges.

Question 36Data Preparation and Connection

Which calculation correctly returns only the first three characters of a Product Code field?

  1. MID([Product Code], 3)
  2. RIGHT([Product Code], 3)
  3. LEFT([Product Code], 3) Correct answer.
  4. LEN([Product Code], 3)

Explanation

The LEFT function returns a specified number of characters from the start of a string. RIGHT returns characters from the end, MID returns characters starting at a given position, and LEN returns the length of the string.

Question 37Data Preparation and Connection

An analyst needs to replace every occurrence of 'N/A' in a text field with a null value. Which function is most appropriate?

  1. REPLACE Correct answer.
  2. STARTSWITH
  3. CONTAINS
  4. FIND

Explanation

REPLACE substitutes all occurrences of a substring with a new string, which can be an empty or null value. FIND locates a substring, CONTAINS returns a Boolean, and STARTSWITH tests a prefix.

Question 38Data Preparation and Connection

A database table contains a field named Order Date stored as a string in the format 'YYYY-MM-DD'. Which step converts it to a true date field in Tableau?

  1. Add the field to the Filters shelf.
  2. Change the field's role to Dimension.
  3. Change the field's data type to Date. Correct answer.
  4. Create a group on the field.

Explanation

Changing the data type to Date tells Tableau to interpret the string values as dates. Changing the role, filtering, or grouping does not alter how the underlying values are typed.

Question 39Data Preparation and Connection

Which statement accurately describes the difference between a relationship and a join in Tableau?

  1. A relationship connects logical tables without merging them, while a join merges physical tables into one. Correct answer.
  2. A relationship and a join both merge physical tables but differ only in syntax.
  3. A relationship can only be used with extracts, while a join can only be used with live connections.
  4. A relationship merges physical tables, while a join connects logical tables.

Explanation

Relationships operate in the logical layer and keep tables independent, with Tableau determining the appropriate join at query time. Joins operate in the physical layer and produce a single merged table.

Question 40Data Preparation and Connection

An analyst creates a relationship between an Orders table and a Customers table using Customer ID. What does Tableau use to determine the join type at query time?

  1. The default number format of the key field.
  2. The number of rows in each table.
  3. The order in which the tables were added to the data source.
  4. The referential integrity settings and the fields used in the view. Correct answer.

Explanation

Tableau uses the declared referential integrity and the fields referenced in the view to choose an appropriate join for the relationship. Table order, row counts, and number formats do not drive join selection.

Question 41Data Preparation and Connection

Which Tableau feature creates a reusable named group of members from a dimension, such as combining several regions into a 'Coastal' group?

  1. Group Correct answer.
  2. Set
  3. Parameter
  4. Bin

Explanation

A group combines selected dimension members into a single member that can be used in views. A set creates a subset based on a condition, a parameter is an input value, and a bin creates numeric ranges.

Question 42Data Preparation and Connection

An analyst needs to create fixed-size numeric ranges from a Sales measure to build a histogram. Which Tableau feature should be used?

  1. Group
  2. Parameter
  3. Bin Correct answer.
  4. Set

Explanation

Bins divide a numeric measure into equal-sized ranges, which is the basis for a histogram. Groups combine categorical members, sets define subsets, and parameters supply input values.

Question 43Data Preparation and Connection

A text field contains values with inconsistent casing, such as 'east', 'East', and 'EAST'. Which function standardizes the casing so all values match?

  1. LEN
  2. UPPER Correct answer.
  3. TRIM
  4. FIND

Explanation

UPPER converts all characters to uppercase, making the values consistent. TRIM removes surrounding spaces, LEN returns length, and FIND locates a substring.

Question 44Data Preparation and Connection

Which statement best describes the result of creating an extract from a data source?

  1. It publishes the data source for other users to connect to.
  2. It creates a live query that always reflects the source database.
  3. It converts all dimensions into measures.
  4. It saves a snapshot of the data in a local file that can be refreshed on demand. Correct answer.

Explanation

An extract stores a snapshot of the data in a local file and can be refreshed to pick up changes. A live query is the alternative to an extract, and publishing is a separate sharing operation.

Question 45Data Preparation and Connection

An analyst connects to a database and wants to reduce the extract size by including only rows where Order Date is in the current year. Which extract option should be used?

  1. Parameters
  2. Table calculations
  3. Data source filters Correct answer.
  4. Context filters

Explanation

Data source filters are applied before the extract is created, so only matching rows are stored. Context filters, table calculations, and parameters operate at the workbook level and do not limit extract contents.

Question 46Data Preparation and Connection

A workbook uses a published data source that has been updated with a new calculated field. What must the analyst do to see the new field in an existing workbook?

  1. Change the field's role to Measure.
  2. Refresh the data source connection in the workbook. Correct answer.
  3. Convert the live connection to an extract.
  4. Recreate the workbook from scratch.

Explanation

Refreshing the published data source connection updates the workbook's metadata to include new fields. Recreating the workbook is unnecessary, and changing connection mode or field role does not bring in new metadata.

Question 47Data Preparation and Connection

An analyst joins two tables on a date field, but the join returns far more rows than expected. Which cause is most likely?

  1. The tables have different numbers of columns.
  2. The date field contains duplicate values on both sides of the join. Correct answer.
  3. The join type is set to inner.
  4. The date field is formatted as a string.

Explanation

When key values are duplicated on both sides of a join, each matching pair produces a row, inflating the result. Join type, display formatting, and column count do not by themselves multiply rows.

Question 48Data Preparation and Connection

A calculated field references a field from a secondary data source in a blended view, but results differ from expectations. What is the most likely cause?

  1. The primary source is using an extract instead of a live connection.
  2. The workbook contains more than one worksheet.
  3. The calculated field uses a string function.
  4. The blend relationship uses a field with mismatched data types or granularity. Correct answer.

Explanation

Blends require a common link field with compatible data types and matching granularity; mismatches cause incorrect or null results. Connection mode, function type, and worksheet count do not determine blend correctness.

Question 49Data Preparation and Connection

An analyst needs to ensure that a field's values are treated as a continuous measure for aggregation but displayed as discrete categories in a view. Which approach is appropriate?

  1. Change the field's data type to string.
  2. Convert the measure to a dimension in the data pane.
  3. Create a group on the measure.
  4. Place the measure on a shelf and change its setting to Discrete. Correct answer.

Explanation

A continuous measure can be placed on a shelf and switched to Discrete so it aggregates numerically but displays as distinct categories. Converting to a dimension or string changes how the field is treated, and grouping does not address continuous versus discrete display.

Question 50Data Preparation and Connection

A field contains a mix of numeric values and text such as 'unknown', causing aggregation errors. Which approach best resolves the issue while preserving the numeric data?

  1. Use a calculation with ISNUMERIC or a type conversion to isolate numeric values and handle non-numeric ones. Correct answer.
  2. Change the field's data type to string.
  3. Create a group on the field.
  4. Remove the field from the data source.

Explanation

A calculation can test whether values are numeric and convert or replace non-numeric entries, preserving valid numbers for aggregation. Changing to string or removing the field loses numeric analysis, and grouping does not fix type errors.