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