Tableau Desktop Certification Practice Exam 3

1. Calculated Fields 2. Default Field Properties 3. Data Source Type

A Tableau Data Source File (.tds) contains which of the following?

Increase in the number of rows

A union of two tables usually results in an _____________________

No

Are animations enabled by default in Tableau?

.hyper

Beginning in version 10.5, when you create a new extract, it uses the _________ format instead of the .tde format.

2

Creating a scatter plot requires a minimum of how many measures?

Tree Map

For which of the following charts, does the Size option on the Marks card not work?

From the Data pane, drag a field to color on the marks card

How can you add color to marks in the view in Tableau?

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

How can you format an axis as Bold in Tableau?

1. Improve Query Performance 2. To include only the data of interest

If you are working with a huge dataset, which of the following are strong reasons to use a context filter?

By clicking on the 2 lines on top and dragging the filter

If you have a dashboard and are displaying its filter, how can you rearrange it?

headers

If you see a Blue field, generally it will add _____________ to the view

1. Analyzing real time data from production systems 2. Analyzing and tracking real time flight updates 3. Analyzing real time stock prices

In which of the following scenarios would having a live connection be more beneficial than using an extract?

Yes

Is it possible to make a Measure discrete?

If dragged to row shelf: 14 marks; If dragged to column shelf : 7 marks

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?

By dragging another dimension to Color on the Marks Card

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?

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

Suppose you have a bar chart. When we group by labels in a view, which of the following happens?

1. A bar chart can be used a floating item 2. Floating items can be layered over other objects 3. Tiled items dont overlap

Which of the following are true about Dashboards in Tableau?

False

True or False: Physical tables remain distinct (normalized), not merged in the data source whereas logical tables are merged into a single, flat table.

Discrete and Continuous

What do the colours Blue and Green represent in Tableau?

Toggle the highlighting on/off

What does the following marker/icon do in Tableau?

A single worksheet or dashboard

What is a story point in Tableau?

Both field names are present in the Union, but contain several null values

When field names in the Union do not match, then:

When we drag a continuous field to the row/column shelf

When is an axis created for the visualisation in Tableau?

diverging

When there are both negative and positive values for a field, the default range of values will use two color ranges. This is known as a ______________ palette.

1. Easier to compare visualizations side by side 2. Helps in faster analysis 3. Provides the ability to use one sheet as a filter for other

Which of the following are benefits of combining sheets using dashboards?

1. Dates are mostly placed in dimensions by default for relational data sources 2. They affect the level of detail in the view 3. They contain qualitative values (names/dates/geographical data)

Which of the following are true about dimensions?

1. Automatic 2. Range 3. Fixed Size

Which of the following are valid Dashboard size options?

1. Vertical Container 2. Horizontal Container

Which of the following are valid Layout Container types when using Dashboards in Tableau?

1. Help Improve Performance 2. To support additional functionality such as count distinct 3. Fast to create

Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?

1. Right click on rows or columns, and choose format. In the font option click on bold. 2. Choose format from the menus bar, select row or column, and select Bold under the header option

Which of the following are valid way(s) to make either of Rows or Columns Bold without affecting the other?

1. Click on tooltip in the Marks Card, and select bold. 2. Right click, click format and then under the default worksheet formatting, choose Tooltip and make it bold. 3. Click on Worksheet in the Menu bar, followed by Tooltip and select the bold option.

Which of the following are valid ways to Bold the Tooltip content in Tableau?

Click on Dashboard in the Menu bar followed by Copy Image

Which of the following are valid ways to export a dashboard with multiple visualisations as an image?

1. Click on Format in the Menu bar, choose Font, and then edit the Tooltip options to italicize the font 2. Click on worksheet in the menu bar, select tooltip, and then use the italics option 3. Click on tooltip in the marks card, select the text, then use the italics option

Which of the following are valid ways to italicize Tooltip content in Tableau?

1. Increase the font size 2. Use a clear and readable font 3. Make the font color sharper / darker than the background

Which of the following are valid ways to make the font more readable in Tableau?

1. Standard Deviation 2. Variance

Which of the following calculations DO NOT need a quick table calculation?

Highlighters

Which of the following can help us focus on specific data without removing data in the visualization?

1. Calculated Fields 2. Measures

Which of the following can you add a reference line to?

Choose Format from the menu on top and then specify the formatting in the new Format workbook pane

Which of the following describes the best way to change the formatting at a workbook level?

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)?

If we want a static view of the visualization

Which of the following is a compelling reason to export a sheet in Tableau to a PDF?

Layout Containers

Which of the following lets you group related dashboard items together so you can quickly position them?

They are numerical, quantitative

Which of the following options best describe measures?

Combined Sets

Which of the following sets would you use to compare the members?

Measure Names

Which one of the following is a dimension?

padding

While borders and background colors let you visually highlight items on a dashboard, _________ lets you precisely space items.