Tableau Practice Exam
When a sheet is used as a filter, selecting an element in it will ____?
filter all other sheets
Which file type saves both the connection information (for example the database server address), calculations and groups that you've added, along with an extract of the data?
.tdsx
What is the level of confidence that Tableau uses when it shows a confidence band?
95%
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
Which of the following returns the Absolute Value of a given number
ABS (Number)
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've created a bar chart showing Sales by Category, but you'd like the user to be able to choose to have other measures shown in the same format. How could this be achieved?
Add a parameter
Which of the following can be used to combine tables at different levels of granularity without duplicating data? [select two]
Blend and Relationship
In the Device Preview screen, what is similar between the desktop and mobile device types?
Both allow for element resizing
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
Which resource in Tableau can you use to ask questions, get answers, and connect with other Tableau users?
Community
A table in your data stores patient information, and has PatientID and PatientName fields. Which scenario requires using a join operation?
Connecting those patients to records in a different table
What steps should you take to place a filter on an Order Date field so that one of the worksheets in the workbook shows only orders placed in the current month when the viz is opened?
Drag the date field to the filters area. Select Relative Dates. Then select Months and This Month.
You have a scatter plots of products with Sales on the X-axis and Profit on the Y-axis. What should you do so that the points on the plot are larger depending on the total quantity sold? [select two]
Drag the pill for the Quantity Sold field to the Size card..Drag the pill for Quanitity Sold field into the center of the chart and release the mouse
Gilbert has an Excel spreadsheet open in Tableau. What did Gilbert have to do to bring the spreadsheet into Tableau?
He connected to an outside data source
You have a scatter plot that uses different symbols to represent different product sub-categories. What steps should you take to replace the symbol for Bookcases with a square? [select two]
In the data pane, select default properties then Shape. In the menu that appears, select bookcases and the square shape. Click Okay. Click the Shapes mark, then select bookcases and the square shape. Click Okay.
A union of two labels usually results in ____
Increase in the number of rows
How does tabluea determine which color to change your text to?
It is based on the background color.
What does it imply if a field has a blue background?
It is discrete
How do you identify a continuous field in Tableau?
It is identified by a green pill in a visualization
How are book and Info combined? The mid section of a venn diagram
Join
Which data summary option is not offered?
Mode
You have a line chart showing total sales by year. How can you change this to a bar chart? [select two]
On the Marks card, select Bar from the drop-down list..On the Show Me menu, select horizontal bars.
How can you combine two sets into one?
Press Ctrl+click to highlight the two sets, and then right clock either set to display a shortcut menu that allows you to create combined set.
What steps will change "Category" to "Product Category"?
Right-click the Category pill in the data pane. Select "Rename" then change the text form "Category" to "Product Category"
Which of the following describe the steps needed to do a manual sort? [select two]
Right-click the pill for the dimension you'd like to sort. Select Sort, then Manual. Use the arrows to manually sort and click okay. Click a header and drag it to the new location.
You've created a crosstab view with dimensions and an aggregated measure. What steps should you take to export the crosstab to Excel?
Select Worksheet > Export > Crosstab to Excel
Your workbook has two different data sources, both sharing a field called "Business Name." How can a single filter be used to filter both data sources on this field?
Select the "All using this data source" option for the filter
How can totals be added to crosstab view? [select two]
Select the Analytics Pane. Drag totals into the view. Release the mouse on the type of total you'd like to add..On the Analysis tab of the toolbar, select Totals. Then select the type of total you'd like to add.
In a calculated field, fields are enclosed in _____.
Square brackets
Which fields shown in the data pane below, when included in a map, will cause the system generated latitude and longitude fields to be added to the view? [select three]
State, City, Country/Region
Which of the following points are true about Viz Animations?
Tableau enables animations for your viz by default
In presentation mode, what happens when you switch between different worksheets?
The display will stay in presentation mode
You have a line chart showing the number of motor vehicle accidents per month. You drag the "accident type" dimension to the color measure. How does this change the line chart?
The number of lines on the chart will increase. The heights of the lines will decrease.
For a given histogram, you reduce the size of the bin from 10 to 5. How will this affect the visualization?
There will be more bars, and they will be narrower
What will you use custom regions for?
To define regions that are specific to your business.
Enabling any other type of sort (Field, alphabetic, or Nested) clears the manual sort we create.
True
Which interactive elements can you add to a dashboard? [select three]
URL, Highlight, and Filter
A Tableau Support case can be opened in which of the following valid ways?
Using the Developer Community Forum
When will you need to download a driver from the Tableau support site?
When you need to conenct to a system not currently listed in the data source connectors.
Can you join the AccountID field in one table with the ProfileNum field in a different table?
Yes, it is possile to join fields with different names
When can you edit an existing filter?
You can edit at any stage
How do you define a level of detail expression?
You define a LOD with curly brackets
Which of the following is the best reason to use a live connection instead of an extract?
You need to refresh the data as often as possible
Which colors are available for you to choose from, when selecting the color for a tab?
a handful of colors from a palette
What does a story in Tableau consist of?
a sequence of worksheets in your workbook
What is exported from your worksheet when you export it to PowerPoint?
a static image of the worksheet visualization
How is a twbx file different from a tde file?
a twbx file stores the visualization as well
You have a crosstab view showing the average listing prices for homes by zipcode. What would be the best way to update the view to remove zip-codes with average listing prices about 300,000?
add a measure filter for the listing price
To dynamically change a reference line using parameter action, you first create a reference parameter. Next, add a parameter action for it. Finally, _____.
add a reference line whose values follows a reference parameter.
You want the rows in your dashboard to show fields A,B,C in order. How should you arrange them?
add fields A, B, and C to the Rows shelf in this order.
When using a radial selection tool to analyze shipping costs from a production facility to different destinations, where should the circle be centered?
at the production facility
Your workbook has one data source and two worksheets visualizing it. What will be included if you save it as a packaged workbook?
both visualizations and the underlying data
Groups are used to ___.
combine multiple items into one
Which of the following sets would you use to compare the members?
combined sets
You have a bar chart showing monthly revenue by store. What should you do to combine the bars for two of the stores?
create a group
What is this entire view referred to as in Tableau?
data pane
What do the colors Blue and Green represent in Tableau respectively?
discrete and continuous
When there are both negative and positve values for a field, the default range of values will use two color ranges. This is known as a ____ palette.
diverging
True or False: Sets can be created on Measures
false
In the Print to PDF dialog box, what does the "Show selections" option do when enabled?
it reflects the dashboard highlights in the resulting PDF
Which of the following lets you group related dashboard items together so you can quickly position them?
layout containers
Your dashboard should show the sum and average as two separate columns. If you use measure names as the column field, what should you use for the marks?
measure values
Which reference line computation requires you to specify the number of tiles?
quantiles
When using a Blend, what is the color of a tick-mark on the primary and secondary data sources respectively?
red, blue
Which of the following would most likely be a measure?
sales tax
Which type of chart would be most appropriate for showing the relationship between two measures?
scatter chart
Which annotation option is not offered in Tableau
sheet
Gretchen wants to change this data into a bar graph or other chart format. Which feature will display all types of charts for Gretchen to choose from?
the Show Me button
Your dashboard shows total cars sold by city. How will the data be impacted if you set a condition filter for sum of cars sold greater than 100?
the dashboard will only show the cities where more than 100 cars were sold.
True or False: Context Filters are executed after Data Source filters
true
What types of data does a scatter plot require?
two measures
Which option creates a dashboard action?
use as filter
What is another name for column charts in Tableau>
vertical bar charts
Default formatting can be set for which of the following?
Dates and Numbers
You wish to organize related dimensions into a series of different levels. Which feature should you use?
Hierarchy
Which of the following chart types is most likely to include a bin?
Histogram
Is it possible to restore a deleted worksheet?
yes, by undoing the deletion
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
You'd like to add the same worksheet multiple times, but with different filters selected. Which feature will support this?
stories only
Which of the following are valid Dashboard size options?
fixed size
A relationship is most similar to which type of join?
Outer
A field value is currently not in any group. What happens when you try adding it to an existing group?
it is removed from the all list and placed under the new group.
What happens when you define a set as a filter?
only the data belonging to the items in this set with show.
The icon associated with the field that has been grouped is a ____ .
paperclip
What is nested sorting useful for?
sorting data values in more than one field
Which of the following calculations DO NOT need a quick table calculation?
standard deviation
Jordan wanted to change the data values in the Southeast set. How did she open this dialog box?
She right-clicked on the Southeast set pill and then selected edit set.
Which of the following will create an axes when it is added to the row or column shelf? [select two]
a continuous measure and dimension
In the dimensions list, what happens when you double-click on an item that has a geographic role?
it is automatically added as a map
A histogram shows ____ and ____.
a measure (in bins); the counts of each bin
Which of the following are most likely to reduce the size of an extract?
Check the aggregate data to visible dimesions option and select hide all unused fields.
William brought some data into his Tableau Book, but the data had some null values and incorrect column headers. What did William have to do to clean up the data?
he had to use the data interpreter
Ravinder has created a bar chart showing product category and product name. He has hidden the legend and displayed the caption at the bottom. How did he do this?
he selected worksheet on the ribbon, then selected show caption
Which of the following can help us focus on specific data without removing data in the visualization?
highlighter
After adding one table to the canvas, what steps should you follow to create a relationship with a second table located on a different database?
Click the Add link to the right of the Connections heading in the Left pane. Switch between data connections in the Left pane, then drag out the desired table to the canvas and release it.
Which of the following describes the relationship between the default dashboard layout and device-specific layouts? [select two]
Items on the default dashboard layout need not be included on the device-specific layouts.Items on the device-specific layouts must also be present on the default layout
If you wanted forests to appear on your map, which lap layer would you select?
Land cover
You have created a polygon map and would like to be able to see all major cities shown on the map. How should you show these?
On the toolbar, select Map and then Map Layers. Check the box next to Cities in the Map Layer pane.
Chandler is using the selection filter so that certain values appear. He wants to show only the western states, but they are crossed out. Why is this happening?
The exclude box is checked, he needs to uncheck it
Which calculation will add the Tax field to the Sales Price field?
[Tax] + [Sales Price]
A highlight table is used to ____?
visualize the relative proportions of values in a table
Katrina would like to break down her company sales by product category. She has all the data, but the chart does not show the individual colors. What should she do in order to create the colors?
select the pie chart icon in the show me area
You add a filter by condition, and set the condition to [Weight]>50. How will this affect your data?
It will only show items whos weight is over 50
Using the Custom Split Data function in Tableau, how is data split?
by a seperator