Practice Tests

Minimum of how many measures does a bullet graph need

2

which of the following is recommended to optimize workbook performance?

- Strings & dates are slow #s & Booleans are fast - Upgrading to the newest version may boot performance without needing anything else - while reducing the data, make sure you use filters efficiently

What are the device types option for the Dashboard

- Tablet - Desktop

What is the difference between a full refresh and an incremental refresh

- by defaults, extracts are configured to full refresh - incremental refresh adds rows that are new since the precious fresh - if the data structure of the data changes, you will need to do a full extract refresh before you can start doing incremental refreshes again

Which of the following can you edit from the manage metadata screen

- data type - geographical role - field name

what re the benefits of using data extracts in tableau

- improved performance - ability to use the data offline - faster to work with - support large datasets - fast to create - support additional functionality

What does a magnitude chart include

- line chart - bar chart - packed bubble chart

tableau displays an axis when you drop this into the rows or columns shelf

- measure values - continuous field

With Tableau Reader you can

- open & interact with Tableau workbooks - export views or data - publish views as PDF files - print views - prevent views as a slideshow

You can connect your data to public domain that are available on cloud database source, such as

- salesforce - google analytics - amazon redshitft

What function will the function left(3, Tableau) return?

An error

How is it possible to deploy a URL action on a dashboard object to open a web page within a dashboard rather than opening the systems web browser

with use of a web page object

State the best reason for using an extract instead of a live connection

you need to apply an aggregation that takes too long when using a live connection

What is Tableaus order of operations

1. Extract Filter 2. Data Source Filter 3. Context filter 4. filters on dimensions 5. filters on measures

how can you change the default Tableau repository location

1. Select file > Repository Location 2. Select a new folder that will act as the n ew repository location in the select a Repository dialog box 3. restart tableau so that it uses the new repository 4. changing the repository location does not move the files contained in the original repository. Instead, Tableau creates a new repository where you can store your files

You have an existing area chart. How can you convert it to an area fill chart?

Add a data category as a color mark

You want the rows in your dashboards to show fields A, B, &C, in this order? How should you arrange them?

Add fields A, B, C to the rows shelf in this order

When using a blend, what is the color of the tick mark on the primary and secondary data sources respectively?

Blue, White

Which graph types provide information on the distribution of a continuous measure

Box plot

Link to data is shown in which tab

Data Source

What is the keyboard shortcut for switching in and out of presentation mode in tableau

F7, CTRL + H

What returns data independent of the Data Granularity

Fixed LOD

How does Tableau determine which color to change your text to?

It is based on the background color

If you wanted forest to appear on your map, which map layer would you select?

Land Cover

Which of the below is a discrete data field

November

What actions let your audience change a parameter value through direct interaction with a visualization such as clicking or selecting a mark

Parameter actions

Which chart types always includes bars sorted in descending order?

Pareto chart

How can you combine two sets into one?

Press CTRL+ click to highlight two sets & right click either set to displays shortcut menu that allows you to create combined set

Jordan wanted to change the data values in the Southeast set. How did she open this dialog box?

She right clicked the Southeast set pill & then selected Edit Set

Showing the airport terminal with the most foot traffic or a map of all sales across the country are examples of which map?

Spatial maps

You dragged the forecast into your worksheet as a mark to show the future trend. How can you completely remove it?

Stop showing the forecast from the Analytics menu

Which of the following is a snapshot of the data that Tableau stores locally. Good for very large datasets of when we only need few fileds

Tableau data Extract (.tde)

In presentation mode, what happens when you switch between different worksheets?

The display will stay in presentation mode

For a given histogram, you reduce the size of the bin from 10 to 5. How will this affect the visualization?

They will likely be more bars, and they will be narrow

What will you use custom regions for?

To define regions that are specific to your business

What is true about union

To union your data in Tableau data source, the tables must come from the same connection

An aggregated calculation can be multiplied by a non aggregated constant

True

What is exported from your worksheet when you export it to PowerPoint?

a static image of the worksheet visualization

Which of the following can be used for creating variable size bins

calculated fields

A table in your data stores patient information & has Patient ID & Patient Name fields. Which scenario requires using a joins?

connecting those patients to records in a different table

How do you turn a bar chart into a stacked bar chart?

drag a dimensions to color

What is one critical difference between normal calculated fields and the calculated fields created after data blending

fields used in blends must be aggregated

When a sheet is used as a filter, selecting an element in it will ___.

filter all other sheets

How do you identify a continuous field in Tableau

it is defined by a green pill in a visualization

Which do you not see while creating a story

layout pane

A workbook variable such as a #, data or string that can replace a constant value in a calculation, filter, or reference line is called

parameter

Which annotation options is offered in Tableau

sheet

Which of the following shapes does a heat map use by default

square

what does the box in a box plot present?

the range of the middle half of the data points

A highlight table is used for ___.

visualize the relative proportion of values in a table

Sets can be created on

dimensions

What is the best use of the bar graph

- to see data at a glance -= used to compare data across categories