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