TABLEAU
EXAM
QUESTIONS
AND ANSWERS
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. - Answers -c. You need to apply
an aggregation that takes too long when using a live connection.
Interactive elements that you can add to a dashboard for users include ______. (Select
all that apply.)
a. URL actions
b. edit tooltip options
c. filter actions
d. hide and unhide all sheet options - Answers -a. URL actions
c. filter actions
A field that shows average home values for the United States in 2016 is most likely:
a. A discrete date part dimension
b. A continuous date value dimension
c. A geographical dimension
d. An aggregated measure - Answers -d. An aggregated measure
A field that shows average product price most likely become a - Answers -continuous
measure
Which of the followings are correct? - Answers -a. discrete dimensions fields are blue
(textual, qualitative data)
i. e.g. (Dates)
, ii. **doesn't mean that blue is dimensions
b. continuous measures fields are green (numeric data)
Measures - Answers -can be discrete or continuous so they can be either blue or green
You created a group by selecting field labels in a view. How can you remove members
from the group?
a. In the view, right-click the group members you want to remove and select Exclude.
b. In the Data pane, right-click the group and select Edit Group. c. In the view, right-click
the group members you want to remove and select Format.
d. On a color legend, right-click a member you want to remove and select Format
legends. - Answers -b. In the Data pane, right-click the group and select Edit Group.
Which of the following can you use to create a calculated field that returns data
independent of the data granularity in a view?
a. An INCLUDE LOD calculation
b. A table calculation
c. A basic calculation
d. A FIXED LOD calculation - Answers -d. A FIXED LOD calculation
A date field is - Answers -a good example of a discrete or continuous dimension
What do you need to create a scatter plot? - Answers -at least 2 continuous measures
What do you need to create a histogram? - Answers -1 continuous measures
Columns name ends with "ID" - Answers -Tableau considers it dimension even if it's
numeric data
Tableau Workbook - Answers -.twb w/o data
Tableau Packaged Workbook - Answers -.twbx with data (save as this if the person
you're sharing the Tableau doesn't have the data)
text (string), Boolean cannot be continuous - Answers -a. text and Boolean are always
discrete
Discrete or continuous measures - Answers -Measures are fields containing numeric or
quantitative information. Most of the fields in the activity dataset are measures, for
example, "% Smokers", "Adult obesity rate", and "Child food insecurity". More formally,
a measure is a field that is dependent on one or more dimensions. For example, if I
wanted to visualize "% Smokers", I normally want to categorize the results, say, as "%
Smokers by State". Here, "% Smokers" is a measure that's been made dependent on
the "State" dimension. If you don't provide a dimension, Tableau will simply aggregate
the measure over the entire dataset.
EXAM
QUESTIONS
AND ANSWERS
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. - Answers -c. You need to apply
an aggregation that takes too long when using a live connection.
Interactive elements that you can add to a dashboard for users include ______. (Select
all that apply.)
a. URL actions
b. edit tooltip options
c. filter actions
d. hide and unhide all sheet options - Answers -a. URL actions
c. filter actions
A field that shows average home values for the United States in 2016 is most likely:
a. A discrete date part dimension
b. A continuous date value dimension
c. A geographical dimension
d. An aggregated measure - Answers -d. An aggregated measure
A field that shows average product price most likely become a - Answers -continuous
measure
Which of the followings are correct? - Answers -a. discrete dimensions fields are blue
(textual, qualitative data)
i. e.g. (Dates)
, ii. **doesn't mean that blue is dimensions
b. continuous measures fields are green (numeric data)
Measures - Answers -can be discrete or continuous so they can be either blue or green
You created a group by selecting field labels in a view. How can you remove members
from the group?
a. In the view, right-click the group members you want to remove and select Exclude.
b. In the Data pane, right-click the group and select Edit Group. c. In the view, right-click
the group members you want to remove and select Format.
d. On a color legend, right-click a member you want to remove and select Format
legends. - Answers -b. In the Data pane, right-click the group and select Edit Group.
Which of the following can you use to create a calculated field that returns data
independent of the data granularity in a view?
a. An INCLUDE LOD calculation
b. A table calculation
c. A basic calculation
d. A FIXED LOD calculation - Answers -d. A FIXED LOD calculation
A date field is - Answers -a good example of a discrete or continuous dimension
What do you need to create a scatter plot? - Answers -at least 2 continuous measures
What do you need to create a histogram? - Answers -1 continuous measures
Columns name ends with "ID" - Answers -Tableau considers it dimension even if it's
numeric data
Tableau Workbook - Answers -.twb w/o data
Tableau Packaged Workbook - Answers -.twbx with data (save as this if the person
you're sharing the Tableau doesn't have the data)
text (string), Boolean cannot be continuous - Answers -a. text and Boolean are always
discrete
Discrete or continuous measures - Answers -Measures are fields containing numeric or
quantitative information. Most of the fields in the activity dataset are measures, for
example, "% Smokers", "Adult obesity rate", and "Child food insecurity". More formally,
a measure is a field that is dependent on one or more dimensions. For example, if I
wanted to visualize "% Smokers", I normally want to categorize the results, say, as "%
Smokers by State". Here, "% Smokers" is a measure that's been made dependent on
the "State" dimension. If you don't provide a dimension, Tableau will simply aggregate
the measure over the entire dataset.
