Question 1

True or False: A reference line cannot be added from the Analytics Pane

Accepted Answer

You can add a reference line to any continuous axis in the view. To add a reference line:
Drag Reference Line from the Analytics pane into the view. Tableau shows the possible destinations. The range of choices varies depending on the type of item
and the current view.
In a simple case, the drop target area offers three options:
Reference: https://help.tableau.com/current/pro/desktop/en-us/reference_lines.htm

Question 2

Which of the following would you use to connect to multiple tables in a single data source at once?

Accepted Answer

The data that you analyze in Tableau is often made up of a collection of tables that are related by specific fields (that is, columns). Joining is a method for
combining data on based on those common fields. The result of combining data using a join is a virtual table that is typically extended horizontally by adding
columns of data.
For example, consider the following two tables originating from a single data source:
We can combine these 2 tables, simply by joining the tables on ID to answer questions like, "How much was paid in royalties for authors from a given publisher?".
By combining tables using a join, you can view and use related data from different tables in your analysis.
Reference: https://help.tableau.com/current/pro/desktop/en-us/joining_tables.htm

Question 3

When creating a histogram in Tableau, to what does bin size refer?

Accepted Answer

When creating a histogram in Tableau, bin size refers to the range of the continuous measure counted in each bin. A histogram is a chart that displays the shape
of a distribution of a continuous measure. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins. The basic building
blocks for a histogram are as follows: Mark type: Automatic; Rows shelf: Continuous measure (aggregated by Count or Count Distinct); Columns shelf: Bin
(continuous or discrete)4 To create bins from a continuous measure, you need to specify the size of bins, which determines how many bins are created and how
wide they are. The size of bins is equal to the difference between consecutive values along the axis that represents the bins. For example, if you have bins with
values 0-10, 10-20, 20-30, etc., then the size of bins is 10. You can either enter a value for the size of bins manually or have Tableau suggest an optimal bin size
based on a formula that considers the number of distinct rows and the minimum and maximum values in the data5 The other options are not valid definitions of bin
size when creating a histogram in Tableau. The minimum number of axis ticks in the view is determined by Tableau’s automatic scaling and formatting of axes,
which can be adjusted manually if needed. The count distinct (COUNTD) of items on either axis is an aggregation function that returns the number of unique
values in a field, which can be used as a measure in a histogram but not as bin size. The maximum number of marks in the view is limited by the performance and
readability of the visualization, which can be improved by filtering, sorting, or aggregating the data4

Question 4

A _______ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package
your work for sharing with others who don’t have access to the original data.

Accepted Answer

According to the official Tableau documentation:
Tableau packaged workbooks have the .twbx file extension. A packaged workbook is a single zip file that contains a workbook along with any supporting local file
data and background images. This format is the best way to package your work for sharing with others who don’t have access to the original data. For more
information, see Packaged Workbooks.
Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm

Question 5

How can you MANUALLY assign geographic roles to a dimension from the data pane?

Accepted Answer

From the data pane, simply right click on the dimension, choose geographic role, and then select the appropriate role as follows:

(314 New Questions)

Question 6

Suppose I have the following view. What will be the total number of marks if I drag a new measure to the row shelf vs the column shelf?

Accepted Answer

This is a tricky question often asked in the exam.
If we drag a new measure to the row shelf, the following happens:
We now have 2 rows, and the same 7 columns for both these rows. Therefore, 2x7 = 14 marks!
But if we drag the same measure to the column shelf, we have just 1 row and a chart created for each of the columns. So (1x7) = 7 marks!
Reference and notes: https://medium.com/@justindixon91/tableau-specialist-exam-notes- part-4-understanding-tableau-concepts-f78de83fdd35

Question 7

What are three ways to access bolding options for the text in a tooltip? Choose three.

Accepted Answer

To access bolding options for the text in a tooltip in Tableau, you can:
? Select Tooltip on the Marks card, which allows you to edit the tooltip for the specific marks.
? Select Worksheet on the menu, and then Tooltip, to open the tooltip editor for the worksheet.
? Right-click on the Field and select Format, which lets you format the text including bolding options in the tooltip.

Question 8

In order to avoid any confusions, what should you do after creating a Dual-axis chart?

(314 New Questions)

Accepted Answer

After creating a dual axis chart, make sure to synchronise their axis since they both might not be having the same y-axis.
To align the two axes in a dual axes chart to use the same scale, right-click (control-click on Mac) the secondary axis, and select Synchronize Axis. This aligns the
scale of the secondary axis to the scale of the primary axis.
In this example, the Sales axis is the secondary axis and the Profit axis is the primary axis. If you would like to change which axis is the primary, and which axis is
the secondary, select the field on the Columns or Rows shelf that is the secondary, and drag it in front of the primary field on the shelf until you see an orange
triangle appear.
In this example, you can select the SUM(Sales) field on the Rows shelf, and drag it in front of the SUM(Profit) field. The Sales axis is now the primary and the
Profit axis is the secondary.
Reference: https://help.tableau.com/current/pro/desktop/en-us/multiple_measures.htm

Question 9

______ can only create header. ______ will create header and axis both.

Accepted Answer

Using the Sample superstore as a reference:
1) Let's plot a bar chart showing SUM(Quantity) for each Segment:
2) Right click on the x-axis (Segment):
Notice we don't have an option to edit the axis, only header. This is because only continous values form the AXIS.
3) Similarly, right click on the y-axis (Quantity):
Now we have the option to edit BOTH the axis and the header.
Reference: https://help.tableau.com/current/pro/desktop/en-us/view_parts.htm
2) Right click on the x-axis (Segment):
Notice we don't have an option to edit the axis, only header. This is because only continous values form the AXIS.
3) Similarly, right click on the y-axis (Quantity):
Now we have the option to edit BOTH the axis and the header.
Reference: https://help.tableau.com/current/pro/desktop/en-us/view_parts.htm

Question 10

Tableau auto-generates ______ dimension(s) and ______ measure(s) for us

(314 New Questions)

Accepted Answer

Tableau auto-generates :
1 Dimension - Measure Names
4 Measures - Latitude, Longitude, Number of records, Measure Values
Starting with Tableau 2020.2, every table in a data source has a Count field, in the form of NameofTable(Count). The table count field is an automatically
generated, calculated field. (THIS IS NOT PRESENT IN VERSION 2020.1 ON WHICH THE EXAM IS CURRENTLY BASED)
Reference: https://help.tableau.com/current/pro/desktop/en- us/datafields_understanddatawindow.htm