Tableau Certified Associate Exam — Questions and Answers

Question 1: You need to create a calculated field to show the sales for the most recent year in the dataset. Which of the following calculations correctly isolates the sales for the latest year?

IF ATTR(YEAR([Order Date])) = WINDOW_MAX(MAX(YEAR([Order Date]))) THEN SUM([Sales]) END
IF YEAR([Order Date]) = MAX(YEAR([Order Date])) THEN [Sales] END
IF YEAR([Order Date]) = YEAR(TODAY()) THEN [Sales] END
IF YEAR([Order Date]) = {MAX(YEAR([Order Date]))} THEN [Sales] END (Correct answer)

Correct answer: IF YEAR([Order Date]) = {MAX(YEAR([Order Date]))} THEN [Sales] END

This calculation uses a table-scoped FIXED LOD `{MAX(YEAR([Order Date]))}` to find the single latest year in the entire dataset. It then compares each row's Order Date year to this fixed maximum year. This is a row-level calculation that correctly flags sales from only the most recent year. The other options are incorrect because `MAX(YEAR([Order Date]))` would be an aggregate and cause an error, `YEAR(TODAY())` assumes the data is current, and the `WINDOW_MAX` option is an unnecessarily complex table calculation.

Question 2: Which of the following visual encodings is controlled directly from the Marks card in a Tableau worksheet?

Creating a calculated field.
Changing the size of the entire dashboard.
Adding a reference line to an axis.
Encoding the color, size, and shape of data points. (Correct answer)

Correct answer: Encoding the color, size, and shape of data points.

The Marks card is a fundamental component of the Tableau worksheet used to control the visual properties of the data points (marks). It contains shelves for Color, Size, Label, Detail, Tooltip, and Shape, which allow you to encode your data visually.

Question 3: What does the 'Show Me' panel in Tableau help users do?

Suggest appropriate chart types based on selected fields (Correct answer)
Manage user permissions
Export to PDF
Write SQL queries

Correct answer: Suggest appropriate chart types based on selected fields

Show Me recommends and applies chart types suited to the fields you have selected.

Question 4: In Tableau, what is a story point?

A collection of both worksheets and dashboards
A single worksheet or dashboard (Correct answer)
A collection of dashboards
A collection of worksheets

Correct answer: A single worksheet or dashboard

In Tableau, a story point is a single page within a 'story,' which is a feature designed to present data insights in a guided narrative format. Each story point can contain either a single worksheet or a single dashboard, along with text annotations to explain the insights being presented. It serves as a snapshot of a particular view or analysis.

Question 5: An analyst needs to combine sales data from a corporate SQL database with sales targets stored in a separate Google Sheet. Which method is most appropriate for combining these two disparate data sources within Tableau for analysis on a single worksheet?

Join
Data Blending (Correct answer)
Relationship
Union

Correct answer: Data Blending

Data blending is the correct method when you need to combine data from different, or disparate, data sources, such as a SQL database and a Google Sheet. Joins and Relationships are used to combine tables from the same data source. Data blending works by querying each data source independently and then aggregating the results together in the view at the worksheet level.

Question 6: Which Tableau file type packages the workbook together with its data extracts and images into a single shareable file?

.hyper
.tds
.twb
.twbx (Correct answer)

Correct answer: .twbx

A .twbx is a packaged workbook that bundles the workbook plus its data sources and resources.

Question 7: An analyst wants to empower users to dynamically change the measure displayed in a time-series chart. For example, the user should be able to click on text labels for 'Sales', 'Profit', or 'Quantity' on the dashboard to switch the measure shown in the chart. Which combination of features is required to enable this functionality?

A Set Action and a group.
A Highlight Action and a quick filter.
A Parameter, a calculated field, and a Parameter Action. (Correct answer)
A Filter Action and a calculated field.

Correct answer: A Parameter, a calculated field, and a Parameter Action.

This functionality is achieved using a Parameter to store the user's measure choice, a Parameter Action to update that parameter's value when a user clicks a label, and a calculated field that uses the parameter's current value to determine which measure to display in the chart.

Question 8: An analyst needs to combine data from a published Tableau Server data source with a local Excel file. A join is not possible. Which method should be used to bring data from both sources into a single worksheet?

Cross-database join
Union
Relationship
Data Blending (Correct answer)

Correct answer: Data Blending

Data blending is the appropriate method when you need to combine data from a published Tableau Server data source with another source, like a local Excel file. Relationships and joins cannot be created with published data sources. Data blending queries each data source independently and then aggregates the results in the view.

Question 9: When creating a map of US cities, an indicator appears in the lower-right corner of the map view stating '12 unknown'. When you click on the indicator, the 'Edit Locations' dialog shows several cities are 'Ambiguous'. What does this status indicate?

The data source does not contain the required latitude and longitude fields.
The city names contain spelling errors that Tableau cannot recognize.
The geographic role for the city field has not been correctly assigned.
The city names exist in more than one state or country in Tableau's geographic database. (Correct answer)

Correct answer: The city names exist in more than one state or country in Tableau's geographic database.

An 'Ambiguous' location status means Tableau found multiple possible locations for a given name. For example, the city 'Springfield' exists in many US states. The 'Edit Locations' dialog allows the user to resolve this ambiguity by specifying the correct state or country for each ambiguous city name, often by using information from another field in the data.

Question 10: A company has a dataset of its proprietary sales territories, which are not standard geographic boundaries like zip codes or counties. To map data by these custom territories, the analyst needs to import them into Tableau. Which of the following describes a valid method for achieving this?

Use a 'Group' function on the State field to create the custom territories.
Merge the territory data directly into Tableau's default map server database.
Prepare a CSV file with columns for territory names and standard geographic roles (e.g., Country, State, Lat/Long), then import it via the Map menu. (Correct answer)
Create a `.tms` (Tableau Map Source) file and connect to it as a background map.

Correct answer: Prepare a CSV file with columns for territory names and standard geographic roles (e.g., Country, State, Lat/Long), then import it via the Map menu.

Tableau allows users to extend its built-in geocoding by importing custom geographic locations. The standard process involves creating a CSV file that includes the custom geography names along with columns for standard roles. This file is then imported using the `Map > Geocoding > Import Custom Geocoding` option, allowing Tableau to recognize and plot the new territories.

Question 11: In the order of operations, where do FIXED LOD expressions get evaluated relative to dimension filters?

After dimension filters
After table calculations
Before dimension filters (Correct answer)
Same time as measure filters

Correct answer: Before dimension filters

FIXED LODs are computed before dimension filters are applied, so those filters do not affect them unless added to context.

Question 12: An analyst is comparing the performance of individual products. The view shows `SUM(Sales)` by `[Product Name]`. They want to add a column that shows the average sales for the `[Sub-Category]` that each product belongs to. What is the most direct way to create this calculation?

{FIXED [Sub-Category] : AVG([Sales])} (Correct answer)
{INCLUDE [Product Name] : AVG([Sales])}
TOTAL(AVG([Sales]))
AVG([Sales])

Correct answer: {FIXED [Sub-Category] : AVG([Sales])}

The goal is to compute an average at the `[Sub-Category]` level and display it for each product. A `FIXED` LOD is perfect for this because it calculates the average sales for each `[Sub-Category]` independently of the `[Product Name]` dimension in the view. This value will then be repeated for each product within the same sub-category.

Question 13: Which Tableau product is used to publish and share dashboards with others on a self-hosted environment?

Tableau Prep
Tableau Public
Tableau Reader
Tableau Server (Correct answer)

Correct answer: Tableau Server

Tableau Server is the on-premises platform for sharing and managing content internally.

Question 14: What is the effect of setting a filter action to run on 'Hover'?

It disables tooltips
It requires a double-click
It only works on mobile
The target updates as the user moves the mouse over marks (Correct answer)

Correct answer: The target updates as the user moves the mouse over marks

Hover triggers the action immediately as the cursor passes over a mark.

Question 15: You can utilize _________________ to union files across folders and worksheets across workbooks while working with Excel, text file data, JSON file data, or.pdf file data. The search is restricted to the connection that has been selected.

Pattern Search
Regex Search
Union Search
Wildcard Search (Correct answer)

Correct answer: Wildcard Search

Wildcard Search (or Wildcard Union) is a powerful feature in Tableau that allows users to combine multiple files or worksheets that share a common naming pattern from a specified folder or workbook into a single logical table. This is particularly useful for data sources like Excel, text files, JSON, or PDF, enabling efficient unioning of data without manually adding each individual file or sheet. The search is indeed restricted to the currently selected connection.

Question 16: You are combining two tables in Tableau. The first table contains sales transaction data at a daily level, and the second contains monthly sales targets. To avoid duplicating the monthly target for every daily transaction, which data combination method is most appropriate and flexible?

Relationships (Correct answer)
Inner Join
Full Outer Join
Union

Correct answer: Relationships

Relationships are the recommended method for combining tables with different levels of detail (LOD). They maintain the separate nature of the tables and query them at their native LOD, preventing data duplication that would occur with a join. Joins would merge the tables into a single table, causing the monthly targets to be repeated for each day's sales.

Question 17: What is the primary advantage of publishing a data source to Tableau Server or Tableau Cloud separately from the workbooks that use it?

It automatically creates a live connection, which is always faster than an extract.
It allows for a single, managed, and certified source of truth that can be used across multiple workbooks. (Correct answer)
It reduces the file size of individual workbooks.
It is the only way to enable user-specific filtering.

Correct answer: It allows for a single, managed, and certified source of truth that can be used across multiple workbooks.

Publishing a data source separately allows an organization to create a centralized, governed, and reusable data model. This ensures consistency, as multiple authors can connect to the same certified source of truth, reducing data duplication and maintenance efforts.

Question 18: Which of the following best describes a key difference between a FIXED Level of Detail expression and an INCLUDE/EXCLUDE LOD expression in relation to filters?

FIXED LOD expressions are computed before regular dimension filters are applied, whereas INCLUDE/EXCLUDE expressions are computed after. (Correct answer)
All LOD expressions are calculated after dimension filters in the Tableau Order of Operations.
FIXED LODs ignore all filters, including Context Filters.
INCLUDE/EXCLUDE LODs are calculated before dimension filters, while FIXED LODs are calculated after.

Correct answer: FIXED LOD expressions are computed before regular dimension filters are applied, whereas INCLUDE/EXCLUDE expressions are computed after.

According to Tableau's Order of Operations, FIXED LOD expressions are computed before dimension filters. This means that unless the filter is added to context, a standard dimension filter will not affect the result of a FIXED LOD. In contrast, INCLUDE and EXCLUDE LOD expressions are calculated after dimension filters, so their results will be affected by them.

Question 19: What does a green pill on a Tableau shelf indicate about the field?

It is continuous (Correct answer)
It is a parameter
It is a filter only
It is discrete

Correct answer: It is continuous

Green pills represent continuous fields that produce an axis, while blue pills are discrete.

Question 20: Which of the following is a built-in Quick Table Calculation available in Tableau?

FIXED
INCLUDE
Running Total (Correct answer)
COUNTD

Correct answer: Running Total

Running Total is one of Tableau's built-in Quick Table Calculations; FIXED and INCLUDE are LOD expression keywords, and COUNTD is an aggregation function.

Question 21: When a quantitative field (a measure) is first dragged into the view, what is the default aggregation Tableau applies to it?

ATTR() (Attribute)
AVG() (Average)
MEDIAN() (Median)
SUM() (Summation) (Correct answer)

Correct answer: SUM() (Summation)

By default, Tableau automatically aggregates measures using Summation (SUM) when they are brought into the view. This is because summing up values is one of the most common analytical operations. The user can then change this aggregation to Average, Median, Count, or others as needed.

Question 22: In Tableau, what does the 'X unknown' indicator in the lower-right of a map typically mean?

The data source is offline
Some location values could not be matched to the map (Correct answer)
The license is invalid
The map style is unknown

Correct answer: Some location values could not be matched to the map

The unknown indicator counts location values Tableau could not geocode or match.

Question 23: In Tableau, what is the purpose of the 'Input' step in Tableau Prep Builder when building a flow?

To define calculated fields before cleaning
To specify the data source and initial connection settings (Correct answer)
To merge multiple data sources via blending
To output cleaned data to a published extract

Correct answer: To specify the data source and initial connection settings

The Input step in Tableau Prep Builder is where you connect to your data source and configure initial connection settings such as filters and sampling.

Question 24: A business analyst is working with an Excel spreadsheet that contains multiple sub-tables, titles, and footers. When connecting this file to Tableau, the data appears disorganized. Which Tableau feature should the analyst use to automatically identify and clean the dataset?

Pivot
Relationships
Data Blending
Data Interpreter (Correct answer)

Correct answer: Data Interpreter

The Data Interpreter in Tableau is designed to clean data from sources like Excel, CSV, and Google Sheets. It can automatically detect and bypass extraneous information such as titles, notes, footers, and empty cells to identify the actual fields and values in the dataset.

Question 25: When editing a relationship between two tables in Tableau's data model, what is the default join type used behind the scenes?

Full outer join
Left outer join (Correct answer)
Inner join
Cross join

Correct answer: Left outer join

Relationships in Tableau use left outer joins by default, preserving all records from the primary table even when no match exists in the related table.

Question 26: True/False: It is possible to change a dimension's geographic duties.

A) False
B) True (Correct answer)

Correct answer: B) True

This statement is True. In Tableau, it is possible to change a dimension's geographic role. If Tableau doesn't automatically assign the correct geographic role or if you need to specify a different level of geographic detail (e.g., changing a string field from 'None' to 'State/Province'), you can manually select the desired geographic role from the field's context menu in the Data pane.

Question 27: An analyst wants to create a bar chart showing the total sales for each Sub-Category. They also want to display a reference line showing the average sales for the corresponding product Category for comparison. The view contains [Category] and [Sub-Category] on the Rows shelf. Which calculation will correctly compute the average sales at the Category level, regardless of the Sub-Category detail in the view?

SUM({EXCLUDE [Sub-Category] : AVG([Sales])})
WINDOW_AVG(SUM([Sales]))
{FIXED [Category] : AVG([Sales])} (Correct answer)
{INCLUDE [Category] : AVG([Sales])}

Correct answer: {FIXED [Category] : AVG([Sales])}

A FIXED LOD expression computes a value using specified dimensions without reference to other dimensions in the view. `{FIXED [Category] : AVG([Sales])}` calculates the average sales for each Category and will return the same value for all sub-categories within that category, making it ideal for a reference line. EXCLUDE would be relative to the view, INCLUDE would make the calculation more granular, and WINDOW_AVG is a table calculation that operates on the values currently in the visualization.

Question 28: Which Tableau object lets you assemble multiple worksheets onto a single canvas for combined viewing?

Dashboard (Correct answer)
Data source
Extract
Bin

Correct answer: Dashboard

A dashboard arranges multiple worksheets and objects on one canvas.

Question 29: Which of the following statements is TRUE regarding the relationship between the Default dashboard layout and a custom Phone layout in Tableau?

Once a custom Phone layout is created, any new worksheet added to the Default layout must be manually added to the Phone layout. (Correct answer)
Worksheets can be added to the Phone layout without first being present on the Default layout.
All formatting changes, such as color and font size, made in the Default layout are automatically applied to the Phone layout.
Deleting a filter from the Phone layout also deletes it from the Default layout.

Correct answer: Once a custom Phone layout is created, any new worksheet added to the Default layout must be manually added to the Phone layout.

After you create a custom device layout (like for a phone), it becomes a distinct version of the dashboard. While it inherits the initial state, subsequent changes to the Default layout, such as adding new worksheets or objects, do not automatically appear in the custom layout; they must be added manually.

Question 30: What is the result type of the expression IIF([Sales] > 1000, 'High', 'Low')?

Date
Boolean
String (Correct answer)
Number

Correct answer: String

IIF returns the second or third argument here, both strings, so the result is a string.

Question 31: Which of the following dashboard objects is used to display content from an external website or internal web application directly within a Tableau dashboard?

Text Object
Image Object
Web Page Object (Correct answer)
Navigation Object

Correct answer: Web Page Object

The Web Page object allows you to embed a fully functional web browser within your dashboard. This can be used to display web pages from the internet or an intranet, and can be made dynamic using URL Actions.

Question 32: You are creating a view that shows Sales by [Region] and [State]. You need to calculate the percentage of total sales that each state contributed to its region. Which of the following LOD expressions would be most appropriate for the denominator in your percentage calculation (i.e., the total sales for the region)?

{FIXED [Region], [State] : SUM([Sales])}
{FIXED : SUM([Sales])}
{INCLUDE [State] : SUM([Sales])}
{EXCLUDE [State] : SUM([Sales])} (Correct answer)

Correct answer: {EXCLUDE [State] : SUM([Sales])}

The `EXCLUDE` LOD expression is ideal for 'percent of total' scenarios where you need to compute an aggregation at a less granular level than the view. Since the view is at the [State] level, `{EXCLUDE [State] : SUM([Sales])}` will remove the [State] dimension from the calculation's context, effectively summing sales at the [Region] level, which is the correct denominator.

Question 33: Which feature lets you build a single dashboard layout optimized for desktop, tablet, and phone?

Device-specific dashboard layouts (Correct answer)
Custom SQL
Data blending
Story points

Correct answer: Device-specific dashboard layouts

Device Designer/device layouts let one dashboard render differently per device type.

Question 34: Which keyword makes an INCLUDE LOD differ from the view's grain?

It removes all dimensions
It disables aggregation
It adds dimensions into the calculation not present in the view (Correct answer)
It fixes a constant

Correct answer: It adds dimensions into the calculation not present in the view

INCLUDE computes at a finer grain by adding the listed dimensions, then aggregates up to the view level.

Question 35: When building a dashboard, you need to place a company logo image in the top-right corner so that it overlaps a worksheet containing a title. Which layout property must be applied to the image object to allow it to be placed on top of another object?

Floating (Correct answer)
Horizontal Container
Vertical Container
Tiled

Correct answer: Floating

Floating objects can be placed anywhere on the dashboard, including on top of other tiled or floating objects. Tiled objects are arranged in a grid and cannot overlap.

Question 36: What is the result of the expression INT(3.99) in Tableau?

3.99
3 (Correct answer)
0
4

Correct answer: 3

INT() truncates toward zero, so 3.99 becomes 3.

Question 37: Which of the following best describes the primary difference between a live connection and a Tableau data extract?

Live connections store the data within the Tableau workbook file (.twb).
Live connections are always faster than extracts because they don't require data ingestion.
Extracts create a static subset of data, which can improve performance and enable offline work. (Correct answer)
Extracts can only be created from file-based data sources like Excel and CSV.

Correct answer: Extracts create a static subset of data, which can improve performance and enable offline work.

A Tableau data extract is a compressed snapshot of the data that is stored locally. This can significantly improve performance by reducing query load on the original data source and allows for analysis even when disconnected from the source. Live connections query the source data directly, which can be slower depending on the source system and network.

Question 38: When working with data in the Data Source page, which of the following is NOT considered a metadata management task in Tableau?

Renaming a data field
Filtering out a specific category of data (Correct answer)
Creating a new calculated field
Changing a field's data type from Number to String

Correct answer: Filtering out a specific category of data

Metadata management involves managing the structure and properties of the data, not the data itself. Changing data types, renaming fields, and creating calculated fields are all modifications to the metadata. Filtering data, however, is an operation that removes rows of data from the dataset being used in the visualization, which is a data-level operation, not a metadata change.

Question 39: In the Tableau interface, a field on a shelf is colored green. What does this color signify about the field?

The field is a calculated field.
The field is being treated as a continuous value, which generates an axis in the view. (Correct answer)
The field has been added to the context.
The field is a dimension.

Correct answer: The field is being treated as a continuous value, which generates an axis in the view.

Green pills in Tableau signify that a field is being treated as continuous. Continuous fields are treated as an infinite range of values and draw an axis in the view. Blue pills signify discrete fields, which are treated as finite, individual values and draw headers. While measures are often continuous (green) and dimensions are often discrete (blue), this is not a strict rule.

Question 40: Which of the following statements most accurately describes the primary distinction between a dimension and a measure in Tableau?

Dimensions must be placed on the Rows shelf, and measures must be placed on the Columns shelf.
Dimensions are always text or dates, while measures are always numbers.
Dimensions are qualitative and used to segment data, while measures are quantitative and are typically aggregated. (Correct answer)
Dimensions generate headers in the view, while measures generate axes, with no exceptions.

Correct answer: Dimensions are qualitative and used to segment data, while measures are quantitative and are typically aggregated.

The core difference is functional. Dimensions are categorical fields (like names, dates, or regions) used to set the level of detail or 'slice' the data. Measures are numerical fields (like sales or profit) that you can perform mathematical operations on, and Tableau aggregates them by default (e.g., SUM, AVG).

Question 41: Why might a FIXED LOD ignore a quick filter on a dashboard?

Quick filters run after table calcs only
FIXED is computed before dimension filters unless they are in context (Correct answer)
FIXED only works on measures
Quick filters never affect calculations

Correct answer: FIXED is computed before dimension filters unless they are in context

Because FIXED runs before dimension filters, those filters must be added to context to influence the FIXED result.

Question 42: Which shelf must a field be on to create a small-multiple grid of separate charts?

Detail
Tooltip
Pages
Rows and Columns (Correct answer)

Correct answer: Rows and Columns

Placing dimensions on both Rows and Columns creates a grid of small multiples.

Question 43: In Tableau terminology, what is a 'measure'?

A date hierarchy
A worksheet tab
A text label
A numeric field that can be aggregated (Correct answer)

Correct answer: A numeric field that can be aggregated

Measures are typically quantitative fields that Tableau aggregates by default.

Question 44: Which LOD expression computes a value at a coarser level of detail than the view, ignoring the dimensions in the view except those listed?

FIXED (Correct answer)
EXCLUDE
INCLUDE
RAWSQL

Correct answer: FIXED

FIXED computes a value using only the specified dimensions, regardless of any other dimensions in the view.

Question 45: When connecting to a PDF file in Tableau Desktop, which of the following is a key limitation?

Only text content is extracted; charts and images are ignored (Correct answer)
PDF connections require a Tableau Server license
PDF files must be under 10 MB
Tableau cannot connect to PDFs at all

Correct answer: Only text content is extracted; charts and images are ignored

When Tableau connects to a PDF, it extracts tabular text data only; graphical charts and images within the PDF are not parsed into usable data.

Question 46: What happens to NULL values when you create a wildcard union in Tableau?

NULLs are converted to empty strings automatically
Columns that don't exist in a particular sheet are filled with NULL (Correct answer)
Wildcard unions reject sheets that contain NULL values
NULLs are automatically filled with zero

Correct answer: Columns that don't exist in a particular sheet are filled with NULL

In a wildcard union, when sheets have differing columns, Tableau fills the missing column values with NULL for rows sourced from sheets that lack those columns.

Question 47: Which Tableau feature allows you to combine rows from two data sources that share the same fields and structure?

Blend
Relationship
Union (Correct answer)
Join

Correct answer: Union

Union stacks rows from tables with matching column structures into a single combined table, unlike joins which combine columns.

Question 48: A calculated field uses the `ATTR()` function on a dimension, like `ATTR([Customer Name])`. In a visualization, this field returns an asterisk (*). What does this signify?

There is more than one distinct [Customer Name] associated with the data for that specific mark in the view. (Correct answer)
The calculation has an error and needs to be corrected.
The [Customer Name] field is being used as a continuous measure.
The [Customer Name] field contains a NULL value for the given mark.

Correct answer: There is more than one distinct [Customer Name] associated with the data for that specific mark in the view.

The ATTR() function tests if a field has a single, unique value within the context of the mark. If MIN(dimension) = MAX(dimension), it returns that value. If there are multiple different values, it returns an asterisk (*) to indicate this.

Question 49: When mapping sales by city, a user notices a small indicator in the bottom-right corner of the map that says '12 ambiguous'. This occurs because a city name like 'Durham' exists in both the UK and the USA within the dataset. What is the most direct way to resolve this ambiguity within the view?

Manually enter the latitude and longitude for each ambiguous city.
Filter out one of the countries.
Add a higher-level geographic field, such as 'Country' or 'State', to Detail on the Marks card. (Correct answer)
Create a separate map for each country and combine them on a dashboard.

Correct answer: Add a higher-level geographic field, such as 'Country' or 'State', to Detail on the Marks card.

Tableau can resolve ambiguous location names when provided with more geographic context. By adding a higher-level geographic dimension (like State, Province, or Country) to the view (typically on the Detail shelf), you give Tableau the necessary information to distinguish between identical lower-level names (e.g., Durham, North Carolina vs. Durham, England).

Question 50: An analyst wants to create a scatter plot of customer locations and then, for each customer, calculate the distance to a specific distribution center located at 40.7128° N, -74.0060° W. Which combination of Tableau spatial functions is best suited for this calculation?

SHAPETYPE() to identify the center and LENGTH() to calculate the distance.
AREA() to define the distribution center and BUFFER() to find customers.
MAKEPOINT() to create a geographic point for the distribution center and DISTANCE() to calculate the distance to customers. (Correct answer)
MAKELINE() to connect customers to the distribution center and INTERSECTS() to find the distance.

Correct answer: MAKEPOINT() to create a geographic point for the distribution center and DISTANCE() to calculate the distance to customers.

The `MAKEPOINT(latitude, longitude)` function is used to create a spatial point from coordinate values. The `DISTANCE(point1, point2, units)` function then calculates the straight-line distance between two spatial points. This combination is ideal for creating a spatial point for the distribution center and then calculating the distance from each customer (point1) to that fixed point (point2).

Question 51: Which function would you use to convert a string '2026-01-15' into a date value in a calculated field?

STR()
DATEPARSE or DATE (Correct answer)
DATENAME()
ISDATE()

Correct answer: DATEPARSE or DATE

DATE() or DATEPARSE() converts string input into a proper date data type.

Question 52: True/False: A continuous axis cannot be used in a Reference Distribution plot.

B) True
A) False (Correct answer)

Correct answer: A) False

This statement is False. A Reference Distribution plot in Tableau is specifically used to shade a range of values along a *continuous* axis. It helps visualize the distribution of data, often using percentages, quantiles, or standard deviations, and therefore requires a continuous measure to define these ranges.

Question 53: What does a symbol map (point map) in Tableau use to represent each location?

A density blur
A line connecting points
A mark such as a circle plotted at the location's coordinates (Correct answer)
A shaded polygon

Correct answer: A mark such as a circle plotted at the location's coordinates

A symbol map places individual marks (often circles) at each location's coordinates.

Question 54: A user wants to connect to a Google Sheets file in Tableau Desktop. Which authentication method is required?

Google account OAuth sign-in (Correct answer)
Tableau Server credential pass-through
API key stored in the workbook
Username and password only

Correct answer: Google account OAuth sign-in

Connecting to Google Sheets in Tableau Desktop requires authenticating via Google's OAuth flow using a Google account.

Question 55: A dashboard creator wants users to click on a specific state in a map view and be directed to that state's official government website. The URL needs to change dynamically based on the state selected. Which dashboard feature should be configured to achieve this?

A Go to Sheet Action that navigates to a different dashboard.
A Filter Action targeting a Web Page object.
A URL Action that uses the state dimension in the URL string. (Correct answer)
A Highlight Action to emphasize the selected state.

Correct answer: A URL Action that uses the state dimension in the URL string.

A URL Action is specifically designed to open external web pages. By inserting a dimension, like the state name, into the URL string within the action's configuration, the link becomes dynamic and will direct to a different page for each selected mark.

Question 56: Which connection type should you choose if you want Tableau to store a copy of the data locally for faster performance?

Web data connector
Extract connection (Correct answer)
Live connection
Published data source

Correct answer: Extract connection

An Extract connection saves a snapshot of the data in Tableau's .hyper format locally, enabling faster query performance independent of the original data source.

Question 57: What is the primary purpose of a dashboard 'container' (horizontal or vertical layout)?

To group and control the arrangement and sizing of objects (Correct answer)
To filter data across sheets
To create a calculated field
To publish the dashboard

Correct answer: To group and control the arrangement and sizing of objects

Containers group objects so they resize and arrange together predictably.

Question 58: After connecting to a data source, you notice a field named 'Cust_ID' which represents the customer identification number. To improve clarity for other users of the data source, you want to change its name to 'Customer ID' within Tableau. This action is an example of:

Creating a Calculated Field
Managing Metadata (Correct answer)
Splitting a Column
Creating a Hierarchy

Correct answer: Managing Metadata

Managing metadata involves modifying the properties of the data fields within Tableau without changing the underlying data source. Renaming a field, changing its data type, assigning a geographic role, or adding a default comment are all examples of metadata management.

Question 59: To make a single legend or filter apply across multiple worksheets on a dashboard, you should:

Use a parameter only
Duplicate the filter on each sheet manually every time
Apply the filter to selected/all worksheets using the same data source (Correct answer)
Disable interactivity

Correct answer: Apply the filter to selected/all worksheets using the same data source

'Apply to Worksheets > All Using This Data Source' shares one filter across sheets.

Question 60: A colleague has asked you to share a Tableau workbook that includes all necessary data, custom images, and calculations so they can open and view the dashboard without needing access to the original data source. Which file type should you send them?

Tableau Data Source (.tds)
Tableau Data Extract (.hyper)
Tableau Workbook (.twb)
Tableau Packaged Workbook (.twbx) (Correct answer)

Correct answer: Tableau Packaged Workbook (.twbx)

A Tableau Packaged Workbook (.twbx) is a zip archive that contains the workbook (.twb) along with any local data sources (like extracts or Excel files) and background images. This makes it a self-contained file ideal for sharing with users who do not have access to the original live data connection.

Tableau Certified Associate Exam

The Tableau Certified Associate exam is administered by Salesforce/Tableau and validates proficiency in using Tableau Desktop to connect to data sources, prepare and visualize data, build interactive dashboards, and apply advanced analytics. The exam tests knowledge of data connections, calculated fields, Level of Detail (LOD) expressions, visualization types, geographic mapping, dashboard interactivity, and core Tableau concepts. It is intended for data analysts, BI developers, and other professionals working with Tableau in a business or technical role.

Questions

120 min

Time Limit

75%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds

These practice questions were written with AI tools. They are not real exam questions. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Not reviewed by a subject-matter expert. Editorial policy