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