Tableau Desktop Certification
Beginning in version 10.5, when you create a new extract, it uses the ___ format instead of the .tde format
.hyper
Which of the following are valid ways of grouping data?
1. From the dimensions shelf 2. Using labels in the view 3. Using marks in the view
What is the minimum number of measures needed to build a scatter plot?
2
we can join a maximum of __ tables in Tableau
32
Which of the following best represents the difference between Highlight Tables and Heat Maps?
A heat map uses both size and color. A highlight table only makes use of color
Suppose you have a bar chart. When we group by labels in a view, which of the following happens?
A new mark (bar is created), which consolidates all members of the group
When data from an Excel file is loaded into Tableau, how are blank cells from the source represented?
As null values
Continuous fields form _______ whereas discrete fields will form _____
Axis, headers
Discrete are what color
Blue
Which data type in Tableau does this icon represent? T|F
Boolean
When field names in the Union do not match, then:
Both field names are present in the Union, but contain several null values
How can you change the default Tableau repository location?
By clicking File --> Repository location and choosing a new location
If you have a dashboard and are displaying its filter, how can you rearrange it?
By clicking on the 2 lines on top and dragging the filter
Suppose you create a bar chart by dragging a dimension to the column shelf and a measure to the rows shelf. Which of the following would create a stacked bar chart?
By dragging another dimension to Color on the Marks card
Is SUM a table calculcation?
No
When creating a dashboard for multiple devices, which of the following Device options are available in the Device Preview section?
Default, Phone, Tablet, Desktop
Which of the following is NOT an aggregation provided by Tableau?
Difference
What does the color blue represent in tableau?
Discrete
Dragging a ____ to color creates distinct colors for each item whereas dragging a ___ to color creates a gradient
Discrete Value, Continuous Value
Which of the following are benefits of combining sheets using dashboards?
Easier to compare visualizations side by side Provides the ability to use one sheet as a filter for other Helps in faster analysis
True or False: A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story
False
True or False: You can use multiple sheets/ dashboards within a single story point
False
True or false: Renaming a field in Tableau will also automatically rename the field in the original data source
False
Which of the following are the dashboard sizing options available in tableau?
Fixed Range Automatic
Which of the following is NOT a valid trend line in Tableau?
Gaussian
A __________ action is a hyperlink that points to a web page, file, or other web-based resource outside Tableau
Go to URL
Continuous are what color
Green
Which of the following are valid reasons to use Extracts over Live Connections?
Help improve performance Provide offline access to your data Support additional functionality like computing count distinct
Which of the following is a compelling reason to export a sheet in Tableau to PDF?
If we want a static view of the visualization
Which of the following are valid objects when creating a dashboard in Tableau?
Image Extension Web Page Text
Is it possible to add both a dashboard and a worksheet at the same time to a story point in Tableau?
No
A union of two tables usually results in an ________
Increase in the number of rows
Data blending simulates a traditional ____ join
Left
Which of the following joins does a blend replicate
Left join
which of the following connection types would you use if your work demands that you use the freshest possible data at all times?
Live
An axis for a numeric value can use a linear scale. Which of these is another scaling option for an axis in a Tableau chart?
Logarithmic
For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.
Manual
Which of the following is an example of date value?
March 2018
Which of the following would you use to edit the Shape, Color and Text of your visualizations?
Marks Card
Which of the following is a dimension?
Measure names
What is a visual cue to know that we are using a measure?
Measures are aggregated by default
Can aggregate ____ but not _____
Measures, but not dimensions
When working with a bar graph, Tableau includes an option to "Explain Data" for a particular bar. What type of information would be available in such a view for a categorical field?
Outliers in the category
Which of the following would you use to dynamically adjust the bin size when using Histograms in Tableau?
Parameters
Dimensions contain ____ values
Qualitative
Measures contain ___ values
Quantitative
When using continuous fields with Color on the marks card, which of the following palettes do you get?
Quantitative palette
What is the default aggregation performed by Tableau for a numeric value conveyed on a chart?
SUM
You have cleaned a data source properly, created some calculated fields and renamed some columns. You want to save these changes in the data source for future use cases. Which of the following would BEST satisfy this requirement?
Save it as a .twbx file
Which of the following mark types is used when we create a heat map in Tableau?
Square
Which of these column types is a split option available for?
String
_____ is a snapshot of the data that Tableau stores locally. Good for very large datasets which we only need few fields
Tableau Data Extract (.tde)
Which of the following options best describe measures?
They are numerical, quantitative
Which of the following is a benefit of using a Tableau Data Source (.tds)?
To not contain the actual data, but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields etc.
Which of the following is a benefit of using a tableau data source (.tds)?
To not contain the actual data, but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields etc.
For which of the following charts, does the Size option on the marks card not work?
Tree map
True or false: A dashboard can use multiple sheets inside it
True
Which of the following are interactive elements that can be added to a dashboard for users
URL Action Highlight Action Filter Action
Can a measure be discrete?
Yes
Yes or No: The number of marks will increase when you increase the number of dimensions in a view
Yes
True or False: There is a difference in the filtering options for Discrete fields vs. Continuous fields
Yes, they are different
You can create _____ for members in a dimension so that their labels appear differently in the view
aliases
You can create ________ for members in a dimension so that their labels appear differently in the view
aliases
Green will always be
axis
When using blends, the primary data source is represented by the color ____ and the secondary data source by the color ____
blue, orange
Green measures and dimensions are
continuous
Dimensions affect level of
detail
Dates in tableau are typically treated as
dimensions
Blue measures and dimensions are
discrete
Which of these file types can NOT be loaded into Tableau?
exe
True or False: Viz animations are enabled by default in tableau
false
Blue will always be
header
If you see a blue field, generally it will add ____ to the view
headers
When you use an ___ join to combine tables, the result is a table that contains values that have matches in both tables
inner
If you use a percent difference Quick Table Calculation, what value will be the first data value?
null
Which of the following would be best suited as a dimension
the name of someone
When working with Excel, text file data, JSON file, .pdf file data, you can use ____ to union fields across folders, and worksheets across workbooks. Search is scoped to the selected connection
wildcard search