Tableau Specialist Exam
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
A worksheet uses a color gradient, but the color legend is not shown. How would you show the legend?
1) Analysis > Legends > Color legend 2) Worksheet > show cards > reset cards 3) Right click in the space below the Marks card and select legends > color legend
Describe two ways to create a union of two tables.
1) On the data source page, drag the first table into the canvas. Then drag a second table onto the canvas, below the first table 2) On the data source page, double-click the "New Union" icon. A union menu will appear. Drag both tables to the Union menu, then click OK.
What are two ways to describe the Measure Names field?
1) 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 text table that shows multiple measures. 2) 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 Latitude and Longitude
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])
What are two ways groups are best described?
A method for combining values of a measure A method for combining values of a dimension
With a data source that uses relationships, which describes what is shown in the data source preview pane when you're viewing the logical layer?
A preview of the data for the table currently selected
Which visualizations allow you to set the shape of marks?
Scatter plots, circle views
If a continuous measure with all positive values is added to the color area of the marks card, what is the default?
A sequential color gradient
What can you use to create a calculated field that shows the change from the prior month total?
A table calculation
What describes the result of a full outer join?
A table that contains all values from both tables. When there is no match on the join criteria, the columns for the table where the match could not be found will have null values
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 the other 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
What will increase the granularity of the view?
Adding a dimension to the marks area
Which have predefined geographic roles?
Airports, zip codes
Which feature will allow you to show more relevant or descriptive dimension values in your view than what the original data provides?
Alias
Which task would it make most sense to use a parameter?
Allow the user to change the measure shown in the view. For example, to switch from seeing sale per order to seeing the count of distinct customers
What mark type cannot be adjusted using the size slider?
Area
A histogram must include what?
Bin, Count or count distinct
What uses a primary and secondary data source?
Blending
Which of the following functions can be used on string to create a measure?
COUNTD
Give examples of dashboard actions
Change set values, change parameter
You have a scatter plot showing sales and profit by product sub-category. You wish to create a set from a cluster of high values sub-categories. What steps should you take?
Click and hold down the mouse, drawing a rectangle to select the sub-categories of interest. Right click and select 'create set'
A relative date filter works relative to:
the anchor date
What is one way you can create a dashboard option?
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 2 steps and check center on zero
You have a dashboard containing multiple worksheets. One of the worksheets in the dashboard has a scroll bar. What steps can you take to remove the scroll bar?
Click the more options arrow, select fit, and select fit height
What method can be used to replace a worksheet in a dashboard with a different worksheet?
Click the swap sheet icon next to the new worksheet on the dashboard pane
What will remove a legend on a dashboard?
Click the x to remove it from the dashboard, click the arrow on the legend and select "Remove from dashboard", or select the legend by clicking it and drag it out of the dashboard canvas
You would like to create a view showing the top 5 products by sales. What type of filter should e used with state?
Context filter
You'd like to create a set with the Top 10 highest-grossing movies based on filters selected by the worksheet viewer. What type of filter should you use?
Context filter
Bins can be created for which type of field?
Continuous measure
A histogram shows the distribution of ________ data by creating bins that are _______.
Continuous, discrete
What is automatically organized as a hierarchy?
Date fields
Which dashboard layouts are created automatically by default?
Default, Phone
What field type will create a color palate?
Discrete
Which field types are more common?
Discrete dimension, continuous measure
You want to create a dual axis chart showing the monthly average "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 dual lines on the show me menu
What are options for the scope of a reference line?
Entire Table, Per pane
What can be renamed?
Field names, parameters, and sets
When creating a union between tables, what will happen if the field names do not match?
Fields in the union that do not have matching field names will contain null values
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?
Filter action, highlight action
What can use an anchor date?
Filters
What feature is most helpful in combining all values of a field containing a given string?
Group
In the Southern Region Superstore data, the Product Category, Product Subcategory, and Product Name might be combined using what?
Hierarchy
Which visualization always represents a measure using color?
Highlight table
Which chart type is best for viewing the distribution of a measure?
Histograms
What could best be accomplished using a parameter?
In a view showing the top customers, allow the user to show how many customers to show Allow the worksheet viewer to adjust the bin size for a histogram
If you drag a field called Sales to the filter area, and you do not get a menu, but are immediately taken to the filter menu, what does this indicate about sales?
It is set as a dimension
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
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 a geographic role available in Tableau?
Latitude, Airport, Country
This type of join will include all values from the left table
Left
What should be used if, for security purposes, you'd like users to enter their database credentials in order to access the workbook?
Live connection
What sort type should be used to have sort order Low, Medium, High?
Manual
What steps can be followed to create a tds file?
On Data pane, right-click the data source, and then select Add to Saved Data Sources
When the Use as Filter option is selected for a worksheet in a dashboard, what is the default for how the action is run?
On select
What options can be used to export data as a CSV file?
On the Data source page, select Data. Then select export data to CSV. Right-click the data source name in the data pane, then select "Export data to CSV" On a worksheet tab, click the View Data icon in the Data pane, and click the Export All button
What steps can be used in creating a view with a reference line?
On the analytics pane, click on reference line and drag into the view OR on the Show me menu, select bullet graph
What file types can include an extract?
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 use to let the user select the interest rate?
Parameter
Which mark type cannot have its size adjusted?
Polygon
What are two options for mark sizes?
Reversed, by range
How would you change the font color of the tooltip?
Right click on the view, select "format" and select the dropdown next to tooltip. Then select the color.
What steps would you follow to create a cumulative sum of the values shown in the view?
Right click the pill for the measure in the view, select quick table calculation and then select "running total"
A worksheet has a line graph showing sales by month. How could this be modified to show total sales to date for each month?
Right-click sales, then select Quick Table Calculation menu option, then select running total
Profit and sales are continuous measures in the workbook. Order ID is a dimension. What will most likely not have further aggregation applied when it is added to the view?
SUM([Sales])
What field is most likely to be a dimension?
Sales (bin)
Which chart type will best visualize the relationship between two continuous measures?
Scatter plot
Which type of visualization is not typically effective in showing change
Scatter plot
After modifying an existing story point, which option creates a new story point with the modifications, while preserving the existing story point before modifications?
Selecting "Save as New" on the existing story point
What is most likely to reduce the size of an extract?
Selecting the physical tables data storage option
What action type can be used to create proportional brushing?
Set action
Your data 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 would like to divide your customers into two categories - those with sales above a certain threshold and those with sales below that threshold. What tools will allow you to do this?
Set, calculation
Which properties can be assigned to a dimension?
Shape, color, sort
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. What would be the most appropriate to show this?
Size
Which type of filter usually works best with date fields?
Slider filters
Which of the following is not a default property which can be set for a measure?
Sort
How would you describe a relationship?
Tables are connected by a flexible noodle in the logical layer
Your view has a numeric field set as a discrete measure and a dimension. What visualization can you create with these fields?
Text tables
Describe the effect of changing the filters for a sorted bar chart with sequential animation turned on.
The animation will show the bar sizes changing, then shows the bars reordering according to the sort
What type of chart is it not possible to adjust the size of the marks?
Tree map
A worksheet with a text table has the dimension PRODUCTS and the measure AVG(Discount). If totals are added to the worksheet, what default method will be used to calculate the totals?
The average of discount per row in the underlying data source
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 an 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 into Tableau?
The date values are set to the number of days since 1/1/1900 and the text value is set to null
Relationships are created in which layer?
The logical layer
If a Tableau workbook does not include the fields of Latitude (generated) and Longitude (generated) this indicates what?
The workbook does not include any fields with a geographic role such as state, city, country, or zip code
In which case would you most likely want to use a parameter?
To allow the viewer to select which measure to show in a bar chart
What is a reason to use a join rather than a relationship?
To create an extract using the denormalized table
Editing the font at the worksheet level applies the changes you make to all text fields in view except for what?
Tooltip
Which types of plots are most often used to visualize the distribution of a single continuous measure?
Tree maps, box plots, histogram
The most important items on a dashboard should be positioned where?
Upper left
What can have an alias?
Values of a discrete dimensions, Parameter
In what situation would an outer join be preferred to a blend?
When you need to include all rows from both tables, even when the join or blend criteria is not met
Which of the following can be configured when creating an extract?
Whether to store logical or physical tables, whether to limit the data extracted using filters Whether to aggregate measures for visible dimensions
What is an example of metadata that can be managed in Tableau?
Which fields are hidden
What is the best reason to create a saved data source as a .TDS file?
You want to save the default field properties such as number formats and sort order
What is the best reason to use a relationship instead of a join?
You wish to avoid data duplication when combining tables with different granularity
What is required to combine columns from an Excel worksheet with columns from a database table?
two connections and one data source
Which file types preserve connection properties such as file locations and database server addresses?
tds, tdsx
A bullet chart combines a bar chart with:
reference lines