Specialist 3

Your view has a numeric field set as a discrete measure and a dimension. Which of the following visualizations can you create with these fields? (select all that apply) -Line chart -Text tables -Highlight table -Histogram

Text tables.

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

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 a map -The workbook does not include any fields with a geographic role of state, city, country, or zip code -The workbook does not include custom geocoding -All locations are ambiguous or unknown

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? (select all that apply) -Header -Axis -Caption -Tooltip

Tooltip.

For which of the following is it not possible to adjust the size of the marks? -Bar chart -Tree map -Pie chart -Heat maps

Tree map

Which of the following does Tableau automatically put into a hierarchy? -Date fields (year > month > day) -Geographic fields (country > city > state) -Field with field name containing the keyword "sub-" (product category, product sub-category) -Numeric fields (Millions > Thousands > Ones)

Date fields (year > month > day)

Which visualization always represents a measure using color?

Highlight table

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

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

Profit and Sales are continuous measures in the workbook. Order ID is a dimension. Which of the following will most likely not be aggregated when it is added to the view? -{FIXED [Order ID] : max([Sales])} -SUM([Sales]) -[Sales] - [Profit] -Year([Order Date])

SUM([Sales])

Which of the following fields is most likely to be a dimension? -Unique Order Count -Sales (bin) -Sales -Measure Values

Sales (bin)

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

Selecting "Multiple Table" rather than "Single Tables"

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.

Set.Calculation.

Which of the following can you use to create a calculated field that shows the change from the prior month total? Select all that apply -An aggregate calculation -A table calculation -A basic calculation -A subtraction calculation

A table calculation.

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

Which of the following will increase the granularity of the view? -Adding a dimension to the marks area -Adding a measure to the marks area -Adding a dimension as a filter -Adding a measures as a filter

Adding a dimension to the marks area

A histogram must include which of the following? (select all that Apply)

Bin.Count.

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 is an example of metadata that can be managed in Tableau? Select all that apply. -The data type of the data in the source database -Which fields are hidden -The number of rows in the data -The default aggregation for a field

Which fields are hidden.The default aggregation for a field