Tableau Specialist Exam practice

Which of the following can you use to create a calculated field that returns data independent of the datagranularity in a view?

A FIXED LOD calculation.

vWhich of the following will increase the granularity of the view?

Adding a dimension to the marks area

A field that shows average home values for the United States in 2016 is most likely:

An aggregated measure.

Which of the following is a table calculation? A. SUM B. TOTAL C. AVG D. STDEV

B. Total

A histogram must include which of the following?

Bin Count Count Distinct

You have a dashboard and you want to add a feature so that selecting an element on one of the worksheets on the dashboard causes a change on another worksheet in the same dashboard. What features will do this? (select all that apply)

Filter action & Highlight action A filter action can filter items on another worksheet, and a highlight action can highlight items on another worksheet

Which visualization always represents a measure using color?

Highlight Table

A bullet chart combines a bar chart with

Reference Lines

Which of the following uses a primary and secondary data source?

-Blending -Data Blending involves a primary and secondary data source

Which of the following is not a default property which can be set for a measure?

Sort -Sort is a default property for dimensions but not for measures.

After setting up two data source connections, how can you create a blend?

-Add at least one field from the primary data source to your view. Then, in the Data pane, click the data -Editing the relationship will not by itself establish a blend

You would like to divide your customers into two categories - those with sales above a certain threshold and those with sales below that threshold. Which of the following tools will allow you to do this? Select all that apply.

A Set & a Calculation

Which feature will allow you to show more relevant or descriptive dimension values in your view than what the original data provides?

Alias -Aliasing is the alternative name that you can assign to a value in a dimension field. You can use aliases to rename specific values within a dimension. This can be useful when you want to show more relevant or descriptive dimension values in your view than what the original dataprovides.

In the ______ data set, the Product Category, Product Subcategory, and Product Name might be combined using which of the following...

Hierarchy -Hierarchies allow you to combine similar fields while groups and sets combine values within a field. Parameters allow the user to change a value, which can then be used in calculations, filters, and reference lines.

A relative date filter works relative to:

The anchor date -Relative date filters work relative to the anchor date. By default this will be the current date, but this can be changed

A line chart is broken into separate sections by year. What does this indicate about the date used in the line chart?

The date is a discrete dimension

You connect Tableau to a Excel file which includes a column that has mostly numeric data, but has a few date and text values mixed in. Tableau set the data type for this field as Number. What happens to the date and text values when the data is imported to Tableau?

The date values are set to the number of days since 1/1/1900 and the text value is set to null.

If a Tableau workbook does not include the fields Latitude (generated) and Longitude (generated) this indicates which of the following:

The workbook does not include any fields with a geographic role of state, city, country, or zip code

Editing the font at the worksheet level applies the changes you make to all text fields in view except for which of the following?

Tooltip

For which of the following is it not possible to adjust the size of the marks?

Tree map

Interactive elements that you can add to a dash for users include ________ & _________?

URL Actions & Filter Actions

The most important items on a dashboard should be positioned where?

Upper Left. -Place the most important view at the top of your dashboard, or in the upper left corner. When looking at a dashboard, your eye is usually drawn to that corner first.

Which of the following is true? a. A dashboard cannot include a story, but a story can include a dashboard b. A dashboard can include a story, but a story cannot include a dashboard c. A dashboard can include a story, and a story can include a dashboard d. A dashboard cannot include a story, and a story cannot include a dashboard

a. A dashboard cannot include a story, but a story can include a dashboard

Which of the following will result in an "Error"" a. A calculation that includes more than one aggregation b. Aggregation on a field that is already aggregated c. A table calculation on a field that is already aggregated. d. An aggregation on a level of detail expression

b. Aggregation on a field that is already aggregated -If you try to aggregate an aggregated field , you will get the error message saying that an aggregate cannot be further aggregated

Bins can be created for which type of field?

Continuous measure -A bin can be created on a continuous measure or numeric dimension

Which of the following is the best reason to create a saved data source as a .TDS file?

Correct answer is B. -TDS files save the data source metadata, such as the connection information, default field formatting, and sort order. -They do not save the data source itself, and hence you should use this format if everyone who will use the data source has access to the underlying file or database defined in the connection information.

When creating a union between tables, what will happen if the field names do not match?

Correct answer is C - if the field names do not match, the fields will be included in the UNION but will contain null values for the rows from the table that is missing the field.

Which of the following mark types cannot be adjusted using the Size slider? A. Line B. Pie C. Bar D. Area

D. Area

Profit and Sales are continuous measures in the workbook. Order ID is a dimension. Which of the following will most likely not have further aggregation applied when it is added to the view?

SUM([Sales])

Which chart type will best visualize the relationship between two continuous measures?

Scatter Plot -Scatter plots to visualize relationships between numerical variables. -Bar charts to compare data across categories. --Line charts compare numeric data over time. ----Stacked bar charts compare numeric data over two dimensions.

Which type of visualization is not typically effective in showing change over time?

Scatter Plot -Some of the best visualizations for showing trends over time are line charts, area charts, and bar charts

What steps should you take to add a phone view to a dashboard?

Select Device Preview, then select Phone for Device Type, then click the button labeled "Add Phone Layout"

Which of the following is most likely to reduce the size of the extract?

Selecting "Multiple Table" rather than "Single Tables"

Your data has a column which should be treated as a date, but when you change the data type to date you see a lot of null values or obviously incorrect dates like 12/30/1899. What can you do next since the date conversion did not work?

Set the type back to string, then try date conversion functions like DateParse and Date -

You have a scatter plot showing sales on the x-axis and profit on the y-axis, with each dot representing a different product subcategory. You want to show how the points on the scatter plot vary based on Net Profit, a third continuous variable. Which would be most appropriate? (Select all that apply)

Size & Color -Size would be most appropriate, because with size it is clear that larger values are respresened by larger points on the plot. This is easier for the eye to process than understanding which color or size is associated with the larger values than it is to read a label or tooltip value on each point in the scatter plot. The Visual Analysis Best Practices Guidebook explains, "a rule of thumb is to put the most important data on the X- or Y- axis and less important data oncolor, size, or shape."

Which type of filter usually works best with date fields

Slider Filters

You would like to a view that displays a filter allowing you to select the state, and use a Set to displaying the top 5 products with the greatest total sales within the selected state. What type of filter should you use to filter on the state?

-Context Filter -You would like to filter on the state, and then select the top 5 products with the greatest sales from within the selected state. Therefore, you need a filter which will execute before the Set. Dimension filters execute after sets, so they are the wrong choice. If you make the filter on the state a context filter, Tableau will filter on the state, and then the set will determine the top 5 products by sales within the selected state.

What are two ways to change the font color of the tooltip?

1. Right-click on the view, select "format" and select the dropdown next to tooltip. Then select color 2. Click on the tooltip button in the marks area, highlight the text, and select the desired color using the dropdown

Which of the following fields will have AGG in front of it when you add it to the view?

A calculated field with the formula SUM([Profit]) -since this is a measure that has an aggregation already built in, when you add it to the view you will see AGG in front of the field name

If you have bar chart with a single bar, but you want to subdivide that bar into multiple categories, what should you add to your view?

A dimension needs to be added

Which of the following should be used if, for security purposes, you'd like users to enter theirdatabase credentials in order to access the workbook:

A live Connection -"If your organization enforces user-level permissions to databases, use a live connection for workbooks that connect to those databases. That way, users who interact with workbooks and data sources that require authentication will be prompted for credentials."

Which of the following can you use to create a calculated field that shows the change from the prior month total?

A table calculation.

You add two fields to your Tableau view, "Profit" and "Average Profit." When you add Profit to the view, you see a pill with the label, "SUM(Profit)" but when you add Average Profit to the view, you see a pill with the label, "AGG(Average Profit)." Why does one field have SUM and another AGG?

AGG indicates that the "Average Profit" already includes some type of aggregation. "Profit" does not include aggregation, so an aggregate function is applied when the field is added to the view.

If you are creating a geographic map with cities, but some of the locations are showing as ambiguous, how might you correct this?

Add a field called "State" to the view

You have a dashboard containing multiple worksheets. One of the worksheets in the dashboard has a scroll bar. Which of the following steps can you take to remove the scroll bar?

Click the more options arrow, select fit, and select fit height.

Which of the following describes the Measure Names field (select all that apply) A. It is a Measure automatically created by Tableau B. When you create a view with multiple measures on a single continuous axis, tableau will automatically add measure names to the view C. When you add measure names to a view, all of the measure names appear as row or column headers in the view. The headers include each measure name. This feature becomes useful when you are working with a test table that shows multiple measures. D. Measure Names is a system generated field that contains the names of all the measures in your Tableau workbook, including the system generated measures such as Latitudeand Longitude.

B. When you create a view with multiple measures on a single continuous axis, tableau will automatically add measure names to the view C. When you add measure names to a view, all of the measure names appear as row or column headers in the view. The headers include each measure name. This feature becomes useful when you are working with a test table that shows multiple measures.

Which types of plots are most often used to visualize the distribution of a single continuous measure? (select all that apply)

Box Plot & Histogram

Which of the following action types can be used to create proportional brushing? A. URL Action B. Filter Action C. Set Action D. Sheet Action

C. Set Action

Which of the following functions can be used on string to create a measure?

COUNTD -Of these functions, only COUNTD will take a string and return a measure.

Which of the following will create a dashboard action?

Click the "More Options" arrow on the worksheet included in the dashboard layout, then select "use as filter"

Your view has a histogram showing the distribution of Sales. You'd like to use a color gradient to shade the bars according to the value of Profit. You drag profit to the color mark. How would you adjust the colors so that all negative values are shown in one color and all positive values are shown in a second color?

Click the arrow on the colors mark, select edit colors, select a diverging palette from the dropdown and check stepped color with two steps and check center on zero.

Which of the following does Tableau automatically put into a hierarchy?

Date fields (year > month > day)

Which field types are more common?

Discrete dimension, continuous measure

You want to create a line chart showing the daily "Open" and "Close" values for a stock. The y- axis shows the opening stock price and the x-axis shows the date. What steps should you take?

Drag the field "Close" to the row shelf, then select the dual lines on the worksheet menu.

You created a group by selecting field labels in a view. How can you remove members from the group?

In the data pane, right-click the drop and select edit group

You start with a blank worksheet and add a continuous field to the row shelf. How will this new field change your view?

It will add a vertical axis

This type of join will include all values from the left table

Left

You have SUM([Minutes of Delay]) in your view. If aggregate measures is unchecked, what will the view show instead of SUM([Minutes of Delay])

Minutes of Delay -disaggregating will show the underlying values. The aggregation will be removed, so we will see just "Minutes of Delay"

Which file type can include an extract? Select all that apply.

Packaged Data Source (.tdsx) & Packaged Workbooks (.twbx).

You would like the person using your dashboard to select the year, and based on the year to adjust the interest rate in some related calculated fields. You will like the year selection to limit the data in the view. What Tableau element should you to let the user select the interest rate?

Parameter -A parameter will allow the user to set a value which you can then use in a calculated field. You can also use a parameter in a calculation, and then use that calculated field in a filter to limit the data in the view.

Which of the following is an example of metadata that can be managed in Tableau? Select all that apply.

Which fields are hidden & The default aggregation for a field

Which of the following is the best reason to use an extract instead of a live connection? a. Your data source only supports a live connection via ODBC. b. You need the freshest possible data at all times. c. You need to apply an aggregation that takes too long when using a live connection. d. You need to join tables that are in the data source.

c. You need to apply an aggregation that takes too long when using a live connection.

A histogram shows the distribution of ________ data by creating bins that are _________.

continuous, discrete -A histogram uses bins to subdivide a continuous measure into a discrete bins.

Which of the following field types will create a color palette? a. Measure b. Dimension c. Continuous d. Discrete

d. Discrete A continuous field will create a color gradient, while a discrete field will create a color palette.