Tableau Specialist Exam Questions and
answers Graded A+
What is the best reason to use a relationship instead of a join? - CORRECT
ANSWER-You wish to avoid data duplication when combining tables with
different granularity
Relationships are created in which layer? - CORRECT ANSWER-The logical layer
What is the best reason to create a saved data source as a .TDS file? - CORRECT
ANSWER-You want to save the default field properties such as number formats
and sort order
When creating a union between tables, what will happen if the field names do not
match? - CORRECT ANSWER-Fields in the union that do not have matching
field names will contain null values
In what situation would an outer join be preferred to a blend? - CORRECT
ANSWER-When you need to include all rows from both tables, even when the
join or blend criteria is not met
What uses a primary and secondary data source? - CORRECT ANSWER-Blending
,What can be renamed? - CORRECT ANSWER-Field names, parameters, and sets
What can have an alias? - CORRECT ANSWER-Values of a discrete dimensions,
Parameter
Which have predefined geographic roles? - CORRECT ANSWER-Airports, zip
codes
Which properties can be assigned to a dimension? - CORRECT ANSWER-Shape,
color, sort
You have a scatter plot showing sales and profit by product sub-category. You
wish to create a set from a cluster of high values sub-categories. What steps should
you take? - CORRECT ANSWER-Click and hold down the mouse, drawing a
rectangle to select the sub-categories of interest. Right click and select 'create set'
A worksheet with a text table has the dimension PRODUCTS and the measure
AVG(Discount). If totals are added to the worksheet, what default method will be
used to calculate the totals? - CORRECT ANSWER-The average of discount per
row in the underlying data source
Which task would it make most sense to use a parameter? - CORRECT
ANSWER-Allow the user to change the measure shown in the view. For example,
to switch from seeing sale per order to seeing the count of distinct customers
© 2026 Copyright. All Rights Reserved. This document is
protected by copyright law
, In the Southern Region Superstore data, the Product Category, Product
Subcategory, and Product Name might be combined using what? - CORRECT
ANSWER-Hierarchy
Which chart type will best visualize the relationship between two continuous
measures? - CORRECT ANSWER-Scatter plot
You would like to create a view showing the top 5 products by sales. What type of
filter should e used with state? - CORRECT ANSWER-Context filter
Bins can be created for which type of field? - CORRECT ANSWER-Continuous
measure
What feature is most helpful in combining all values of a field containing a given
string? - CORRECT ANSWER-Group
What steps would you follow to create a cumulative sum of the values shown in
the view? - CORRECT ANSWER-Right click the pill for the measure in the view,
select quick table calculation and then select "running total"
In which case would you most likely want to use a parameter? - CORRECT
ANSWER-To allow the viewer to select which measure to show in a bar chart
What steps can be used in creating a view with a reference line? - CORRECT
ANSWER-On the analytics pane, click on reference line and drag into the view
OR on the Show me menu, select bullet graph
answers Graded A+
What is the best reason to use a relationship instead of a join? - CORRECT
ANSWER-You wish to avoid data duplication when combining tables with
different granularity
Relationships are created in which layer? - CORRECT ANSWER-The logical layer
What is the best reason to create a saved data source as a .TDS file? - CORRECT
ANSWER-You want to save the default field properties such as number formats
and sort order
When creating a union between tables, what will happen if the field names do not
match? - CORRECT ANSWER-Fields in the union that do not have matching
field names will contain null values
In what situation would an outer join be preferred to a blend? - CORRECT
ANSWER-When you need to include all rows from both tables, even when the
join or blend criteria is not met
What uses a primary and secondary data source? - CORRECT ANSWER-Blending
,What can be renamed? - CORRECT ANSWER-Field names, parameters, and sets
What can have an alias? - CORRECT ANSWER-Values of a discrete dimensions,
Parameter
Which have predefined geographic roles? - CORRECT ANSWER-Airports, zip
codes
Which properties can be assigned to a dimension? - CORRECT ANSWER-Shape,
color, sort
You have a scatter plot showing sales and profit by product sub-category. You
wish to create a set from a cluster of high values sub-categories. What steps should
you take? - CORRECT ANSWER-Click and hold down the mouse, drawing a
rectangle to select the sub-categories of interest. Right click and select 'create set'
A worksheet with a text table has the dimension PRODUCTS and the measure
AVG(Discount). If totals are added to the worksheet, what default method will be
used to calculate the totals? - CORRECT ANSWER-The average of discount per
row in the underlying data source
Which task would it make most sense to use a parameter? - CORRECT
ANSWER-Allow the user to change the measure shown in the view. For example,
to switch from seeing sale per order to seeing the count of distinct customers
© 2026 Copyright. All Rights Reserved. This document is
protected by copyright law
, In the Southern Region Superstore data, the Product Category, Product
Subcategory, and Product Name might be combined using what? - CORRECT
ANSWER-Hierarchy
Which chart type will best visualize the relationship between two continuous
measures? - CORRECT ANSWER-Scatter plot
You would like to create a view showing the top 5 products by sales. What type of
filter should e used with state? - CORRECT ANSWER-Context filter
Bins can be created for which type of field? - CORRECT ANSWER-Continuous
measure
What feature is most helpful in combining all values of a field containing a given
string? - CORRECT ANSWER-Group
What steps would you follow to create a cumulative sum of the values shown in
the view? - CORRECT ANSWER-Right click the pill for the measure in the view,
select quick table calculation and then select "running total"
In which case would you most likely want to use a parameter? - CORRECT
ANSWER-To allow the viewer to select which measure to show in a bar chart
What steps can be used in creating a view with a reference line? - CORRECT
ANSWER-On the analytics pane, click on reference line and drag into the view
OR on the Show me menu, select bullet graph
