Tableau Practice Test 1 — Questions and Answers

Question 1: 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
Wildcard Search (Correct answer)
Union Search

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 2: In Tableau, what is a story point?

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

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 3: Is it able to discretize a Measure?

A) No
B) Yes (Correct answer)

Correct answer: B) Yes

Yes, it is possible to discretize a Measure in Tableau. While measures are typically continuous and represented by green pills, you can convert them to discrete fields. This can be done by changing the field's data type to discrete or by creating bins from a continuous measure, which effectively categorizes the continuous data into discrete ranges.

Question 4: In Tableau, how do you make an axis bold?

By right clicking on the axis, choosing format, and then setting its font to bold. (Correct answer)
By clicking on Format on the main menu bar, choosing field labels, and setting it to bold.
By choosing the axis and selecting Command/Control + B on your keyboard
By right clicking on the axis, choosing Edit Axis, and then setting its font to bold.

Correct answer: By right clicking on the axis, choosing format, and then setting its font to bold.

To make an axis bold in Tableau, you typically right-click directly on the axis in your view. From the context menu that appears, you select 'Format,' which opens the Format pane. Within this pane, you can then navigate to the 'Font' section and set the desired font style, including bold, for the axis labels and title.

Question 5: Assume you have a bar graph. Which of the following happens when we group by labels in a view?

The colors of the members selected are now the same, and different for the rest of the members.
A new mark (bar) is created, which consolidates all members of the group. (Correct answer)
Nothing changes in the view, but a group is created in the Dimensions shelf.
None of the above

Correct answer: A new mark (bar) is created, which consolidates all members of the group.

When you group by labels (or marks) in a Tableau view, such as selecting multiple bars in a bar graph, Tableau consolidates the selected members into a single, new mark. This new mark (e.g., a single bar) represents the aggregated value of all the members within that group, effectively combining them visually in the chart. Additionally, a new group field is created in the Dimensions pane.

Question 6: True/False: Two fixed points cannot be used to create a Reference Band.

A) True
B) False (Correct answer)

Correct answer: B) False

This statement is False. A Reference Band in Tableau is specifically designed to shade an area between two values on an axis. These two values can indeed be fixed points (constant values), parameters, or computed values from a field, defining the upper and lower boundaries of the band.

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

A) False (Correct answer)
B) True

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 8: When __________________, the aggregation method attr() returns a *.

There are more than one value in all rows in the group (Correct answer)
There is a single value for all rows in the group.
The data is not present at the desired level.
It is a null value.

Correct answer: There are more than one value in all rows in the group

The aggregation method ATTR() (Attribute) in Tableau returns an asterisk (*) when there is more than one distinct value for the expression within all rows in the group. If there is only a single, unique value for all rows in the group, ATTR() will return that specific value. It's useful for checking if a dimension is unique at a certain level of detail.

Question 9: Which of the following is not a model with a trend line?

Binomial Trend Line (Correct answer)
Linear Trend Line
Logarithmic Trend Line
Exponential Trend Line

Correct answer: Binomial Trend Line

Tableau offers several types of trend line models to analyze patterns in data, including Linear, Logarithmic, Exponential, and Polynomial. A 'Binomial Trend Line' is not a standard or available trend line model option within Tableau's analytics pane for fitting data. Binomial typically refers to a probability distribution, not a regression model for trend analysis.

Question 10: True/False: For the entire worksheet, the Highlighting action can be turned off.

A) False
B) True (Correct answer)

Correct answer: B) True

This statement is True. Highlighting actions in Tableau can be configured and managed. You can specifically turn off the highlighting action for an entire worksheet or dashboard, preventing marks from being highlighted when selections are made in other views or within the same view. This provides control over the interactive behavior of your visualizations.

Question 11: Is it able to use a URL action on a dashboard object to open a Web Page within a dashboard instead of the system's default web browser?

True, with the use of a Web Page object (Correct answer)
True, with the use of Tableau Server
True, requires a plug-in
False, not possible

Correct answer: True, with the use of a Web Page object

Yes, it is possible to use a URL action on a dashboard object to open a web page directly within the dashboard itself, rather than launching the system's default web browser. This is achieved by first adding a 'Web Page' object to your dashboard and then configuring the URL action to target that specific Web Page object.

Question 12: Is it allowed to utilize the same measure in various views (for example, SUM and AVG)?

A) Yes (Correct answer)
B) No

Correct answer: A) Yes

Yes, it is absolutely allowed to utilize the same measure in various views with different aggregations in Tableau. You can drag a measure like 'Sales' onto the view multiple times and then set each instance to a different aggregation, such as SUM(Sales) and AVG(Sales), allowing for diverse analyses and comparisons within a single worksheet or across multiple views.

Question 13: We use _________________ to make variable-size bins.

Calculated fields (Correct answer)
Sets
Table Calculations
Groups

Correct answer: Calculated fields

To create variable-size bins in Tableau, you typically use calculated fields. While Tableau's built-in bin feature creates bins of equal size, calculated fields allow you to define custom logic using IF/ELSEIF statements or other functions to categorize your data into ranges of different widths or specific criteria, thus creating variable-sized bins.

Question 14: Tableau, by definition, shows measurements over time as a ____________.

Line (Correct answer)
Bar
Scatter Plots
Histogram

Correct answer: Line

Tableau, by default, shows measurements over time as a Line chart. This is because line charts are highly effective for visualizing trends, patterns, and changes in data over a continuous period, making them the standard choice when a date or time dimension is used on an axis with a measure.

Question 15: A ______________ is the icon associated with the field that has been grouped.

Hash
Paper Clip (Correct answer)
Equal To
Set

Correct answer: Paper Clip

In Tableau, a Paper Clip icon is associated with a field that has been grouped. This visual cue helps users quickly identify grouped fields in the Data pane, distinguishing them from regular dimensions, measures, sets, or parameters.

Question 16: What is the profitably moving average for November 2013, including the four months before and after?

$8,441 (Correct answer)
$8,000
$7,500
$8,200

Correct answer: $8,441

To calculate the profitability moving average for November 2013, including the four months before and four months after, you would sum the profitability values for the nine months from July 2013 to March 2014 (inclusive). Then, you would divide this sum by nine to get the average. The specific value of $8,441 would be derived from the underlying data provided in the original context of the question.

Question 17: In your view, the best trend model is the one that has?

P-Value more than 1
R-Squared value closest to 1 (Correct answer)
R-Squared value equal to P-Value
R-Squared value greater than 1

Correct answer: R-Squared value closest to 1

In Tableau, the best trend model is generally the one that has an R-Squared value closest to 1. R-Squared (Coefficient of Determination) indicates the proportion of the variance in the dependent variable that is predictable from the independent variable(s). A value closer to 1 signifies that the model explains a larger proportion of the variance and thus provides a better fit to the data.

Question 18: In the event of blended data sources, what is the default join type?

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

Correct answer: Left outer Join

In the event of blended data sources in Tableau, the default join type is effectively a Left Outer Join. When blending, Tableau queries the primary data source for all its rows and then queries the secondary data source for rows that match the linking fields, bringing in only the matching data from the secondary source.

Question 19: True/False: Dimensions cannot be used to form bins.

A) False
B) True (Correct answer)

Correct answer: B) True

This statement is True. In Tableau, bins are specifically created from *measures*, which are typically continuous numerical data. Bins allow you to group these continuous values into discrete, equal-sized ranges. Dimensions, by nature, are already discrete or categorical, so the concept of creating bins from them does not apply in the same way.

Question 20: True/False: In a dashboard, the highlight action is comparable to the filtering action in a worksheet.

A) False (Correct answer)
B) True

Correct answer: A) False

This statement is False. While both highlighting and filtering actions are interactive features in Tableau, they serve different purposes. A highlighting action visually emphasizes related marks across different worksheets or dashboards without removing any data from the view, whereas a filtering action *removes* non-selected data from the view, thereby changing the data displayed. They are not comparable in their fundamental effect on the data.

Question 21: True/False: In a calculated field, groups can be used.

A) False
B) True (Correct answer)

Correct answer: B) True

This statement is True. Groups in Tableau create new categorical fields that can be referenced and utilized within calculated fields. You can write calculations that perform different operations or return different values based on which group a particular data point belongs to, allowing for more complex and conditional analyses.

Question 22: 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 23: True/False: The Analytics pane does not allow you to add a Reference Line.

A) False (Correct answer)
B) True

Correct answer: A) False

This statement is False. The Analytics pane in Tableau is precisely where you can add a Reference Line, along with other analytical objects like Reference Bands, Distribution Bands, and Trend Lines. You simply drag the 'Reference Line' option from the Analytics pane onto the desired axis or the entire table in your view to apply it.

Question 24: True/False: The underlying data source's records are returned after disaggregation.

A) False
B) True (Correct answer)

Correct answer: B) True

Disaggregation in Tableau means viewing individual data records rather than aggregated summaries. When data is disaggregated, Tableau displays every row from the underlying data source, allowing for a detailed examination of each record. This process essentially reverses aggregation, showing the raw, granular data.

Question 25: A compelling reason to employ a bullet graph.

Comparing the actual against the target sales (Correct answer)
Displaying the sales growth for a particular year
Analyzing the trend for a time period
Adding data to bins and calculating count measure

Correct answer: Comparing the actual against the target sales

A bullet graph is specifically designed for comparing a primary measure (like actual sales) against a target value (like target sales) and qualitative ranges (e.g., poor, satisfactory, good). It efficiently displays performance relative to a goal within a compact space. This makes it ideal for dashboards where quick performance assessments are needed.

Tableau Practice Test 1

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.