Tableau Exam ACTUAL UPDATED
Questions and CORRECT Answers
Which of the following is the best reason to create a saved data source as a .TDS file -
CORRECT ANSWER - You want to save the default field properties such as number
formats and sort order.
When creating a union between tables, what will happen if the field names do not match? -
CORRECT ANSWER - Fields in the union that do not have matching field names will
contain null values.
After setting up two data source connections, how can you create a blend? - CORRECT
ANSWER - Add at least one field from the primary data source to your view. Then, in the
Data pane, click the data source that you want to designate as the secondary data source and click
the broken link icon.
Which of the following uses a primary and secondary data source? - CORRECT
ANSWER - Blending
Product Category, Product Subcategory, and Product Name might be combined using which of
the following: - CORRECT ANSWER - Hierarchy
Which chart type will best visualize the relationship between two continuous measures? -
CORRECT ANSWER - Scatter Plot
Which of the following is a table calculation? - CORRECT ANSWER - TOTAL
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? - CORRECT ANSWER - Context Filter
Bins can be created for which type of field? - CORRECT ANSWER - Continuous measure
, The most important items on a dashboard should be positioned where? - CORRECT
ANSWER - Upper left
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) - CORRECT ANSWER - Filter Action &
Highlight Action
What steps should you take to add a phone view to a dashboard? - CORRECT ANSWER -
Select Device Preview, then select Phone for Device Type, then click the button labeled "Add
Phone Layout"
You start with a blank worksheet and add a continuous field to the row shelf. How will this new
field change your view? - CORRECT ANSWER - It will add a vertical axis
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) - CORRECT ANSWER - size & color
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? - CORRECT ANSWER - A dimension
Which of the following fields will have AGG in front of it when you add it to the view? -
CORRECT ANSWER - A calculated field with the formula SUM([Profit])
A histogram shows the distribution of ________ data by creating bins that are _________. -
CORRECT ANSWER - continuous, discrete
Which of the following functions can be used on string to create a measure? - CORRECT
ANSWER - COUNTD
Questions and CORRECT Answers
Which of the following is the best reason to create a saved data source as a .TDS file -
CORRECT ANSWER - You want to save the default field properties such as number
formats and sort order.
When creating a union between tables, what will happen if the field names do not match? -
CORRECT ANSWER - Fields in the union that do not have matching field names will
contain null values.
After setting up two data source connections, how can you create a blend? - CORRECT
ANSWER - Add at least one field from the primary data source to your view. Then, in the
Data pane, click the data source that you want to designate as the secondary data source and click
the broken link icon.
Which of the following uses a primary and secondary data source? - CORRECT
ANSWER - Blending
Product Category, Product Subcategory, and Product Name might be combined using which of
the following: - CORRECT ANSWER - Hierarchy
Which chart type will best visualize the relationship between two continuous measures? -
CORRECT ANSWER - Scatter Plot
Which of the following is a table calculation? - CORRECT ANSWER - TOTAL
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? - CORRECT ANSWER - Context Filter
Bins can be created for which type of field? - CORRECT ANSWER - Continuous measure
, The most important items on a dashboard should be positioned where? - CORRECT
ANSWER - Upper left
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) - CORRECT ANSWER - Filter Action &
Highlight Action
What steps should you take to add a phone view to a dashboard? - CORRECT ANSWER -
Select Device Preview, then select Phone for Device Type, then click the button labeled "Add
Phone Layout"
You start with a blank worksheet and add a continuous field to the row shelf. How will this new
field change your view? - CORRECT ANSWER - It will add a vertical axis
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) - CORRECT ANSWER - size & color
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? - CORRECT ANSWER - A dimension
Which of the following fields will have AGG in front of it when you add it to the view? -
CORRECT ANSWER - A calculated field with the formula SUM([Profit])
A histogram shows the distribution of ________ data by creating bins that are _________. -
CORRECT ANSWER - continuous, discrete
Which of the following functions can be used on string to create a measure? - CORRECT
ANSWER - COUNTD
