Tableau Certification Exam ACTUAL
Questions and CORRECT Answers
How can users refresh an extract immediately? - CORRECT ANSWER - 1) select a data
source on data menu -> extract
2) select a data source on data menu -> extract -> refresh
3) sign in to tableau server -> go to tasks -> under extract refreshes select the workbook or data
source -> on the actions menu click run now
Why is a direct connection to an extract not recommended? - CORRECT ANSWER - -you
cannot refresh the extract (when directly connected, tableau treats the extract file as the true
source, not a copy of the underlying data, so it cannot relate it back to the primary data source)
-tables stored in a direct extract use special naming to guarantee name uniqueness
-The data model and relationship will be lost (when you connect directly, the file will be .hyper.
Only .tds stores a data model and relationship, so when you connect directly you change the file
type to .hyper and lose that info)
What is the default format (extension) that tableau saves files as? - CORRECT
ANSWER - .tds and .tdsx
How many data sources can you blend? - CORRECT ANSWER -2
What leads to adjusting the granularity of data in tableau? - CORRECT ANSWER -
Aggregate
What are the advantages to using a a relationship to combine tables (rather than a join)? -
CORRECT ANSWER - 1) make it easier to change the key fields used to combine the
tables (duplication is avoided when tables are combined with different levels of granularity)
2) tables are only queried when fields from the tables are added to the viz
,How do you edit the data source? - CORRECT ANSWER - data menu -> select a data
source -> edit data source
What can you create aliases for? What can you not? - CORRECT ANSWER - Aliases can
be created for the members of DISCRETE DIMENSIONS ONLY. They cannot be created for
continuous dimensions, dates, or measures
How do you add a default comment to a field? - CORRECT ANSWER - right click on a
field in the data pane -> default properties -> comment
How do you change a vertical bar chart to horizontal? - CORRECT ANSWER - Drag the
measure to the columns shelf and the dimension to the row shelf
What types of trend lines are available in tableau? - CORRECT ANSWER - Linear,
logarithmic, polynomial
How would you create a stacked bar chart while using a separate bar for each measure? -
CORRECT ANSWER - -Measure names to columns
-Measure values to rows
-drag a dimension to color
-on the columns shelf, right click measure names -> select filter -> select which measures to
display -> ok
How do you create a hierarchy? - CORRECT ANSWER - In the data pane drag one field
on top of another field -> enter a name for the hierarchy -> ok
What prevents a refresh for a refreshable list of parameter values? - CORRECT
ANSWER - 1) the default field returns null
2) the default field is in a data source thats not yet connected
3) the user cancels the query to the data source while Tableau is attempting to connect
, What is the order of operations of tableau filters? - CORRECT ANSWER - Extract filters -
> data source filters -> context filters (top n, fixed LOD) -> dimension filters -> measure filters
What is the difference between a bar chart and a histogram? - CORRECT ANSWER - Bar
charts display categorical variables, whereas histograms display quantitative or numerical data
How do we enable the option of animation? - CORRECT ANSWER - go to format ->
choose animations -> select on from animations tab
What color are discrete fields? - CORRECT ANSWER - blue
What are the differences between dimensions and measures? - CORRECT ANSWER - 1)
measures contain quantitative values whereas dimensions contain names, dates or geographical
data
2) dimensions increase the level of detail in the view while measures are aggregated when added
to the view
How do you disaggregate data in tableau? - CORRECT ANSWER - go to analysis ->
uncheck the aggregate measures
Where on tableau do you find data connectors that are available? (which pane) - CORRECT
ANSWER - Connect pane (then go to search for data)
What are the benefits of using an extract over a live connection? - CORRECT ANSWER -
1) supports large datasets
2) helps improve performance; faster
3) support additional functionality; allows you to take advantage of tableau functions that aren't
supported by the original data, such as count distinct
4) provide offline access to your data; allows you to use the data when the original data is
unavailable
Questions and CORRECT Answers
How can users refresh an extract immediately? - CORRECT ANSWER - 1) select a data
source on data menu -> extract
2) select a data source on data menu -> extract -> refresh
3) sign in to tableau server -> go to tasks -> under extract refreshes select the workbook or data
source -> on the actions menu click run now
Why is a direct connection to an extract not recommended? - CORRECT ANSWER - -you
cannot refresh the extract (when directly connected, tableau treats the extract file as the true
source, not a copy of the underlying data, so it cannot relate it back to the primary data source)
-tables stored in a direct extract use special naming to guarantee name uniqueness
-The data model and relationship will be lost (when you connect directly, the file will be .hyper.
Only .tds stores a data model and relationship, so when you connect directly you change the file
type to .hyper and lose that info)
What is the default format (extension) that tableau saves files as? - CORRECT
ANSWER - .tds and .tdsx
How many data sources can you blend? - CORRECT ANSWER -2
What leads to adjusting the granularity of data in tableau? - CORRECT ANSWER -
Aggregate
What are the advantages to using a a relationship to combine tables (rather than a join)? -
CORRECT ANSWER - 1) make it easier to change the key fields used to combine the
tables (duplication is avoided when tables are combined with different levels of granularity)
2) tables are only queried when fields from the tables are added to the viz
,How do you edit the data source? - CORRECT ANSWER - data menu -> select a data
source -> edit data source
What can you create aliases for? What can you not? - CORRECT ANSWER - Aliases can
be created for the members of DISCRETE DIMENSIONS ONLY. They cannot be created for
continuous dimensions, dates, or measures
How do you add a default comment to a field? - CORRECT ANSWER - right click on a
field in the data pane -> default properties -> comment
How do you change a vertical bar chart to horizontal? - CORRECT ANSWER - Drag the
measure to the columns shelf and the dimension to the row shelf
What types of trend lines are available in tableau? - CORRECT ANSWER - Linear,
logarithmic, polynomial
How would you create a stacked bar chart while using a separate bar for each measure? -
CORRECT ANSWER - -Measure names to columns
-Measure values to rows
-drag a dimension to color
-on the columns shelf, right click measure names -> select filter -> select which measures to
display -> ok
How do you create a hierarchy? - CORRECT ANSWER - In the data pane drag one field
on top of another field -> enter a name for the hierarchy -> ok
What prevents a refresh for a refreshable list of parameter values? - CORRECT
ANSWER - 1) the default field returns null
2) the default field is in a data source thats not yet connected
3) the user cancels the query to the data source while Tableau is attempting to connect
, What is the order of operations of tableau filters? - CORRECT ANSWER - Extract filters -
> data source filters -> context filters (top n, fixed LOD) -> dimension filters -> measure filters
What is the difference between a bar chart and a histogram? - CORRECT ANSWER - Bar
charts display categorical variables, whereas histograms display quantitative or numerical data
How do we enable the option of animation? - CORRECT ANSWER - go to format ->
choose animations -> select on from animations tab
What color are discrete fields? - CORRECT ANSWER - blue
What are the differences between dimensions and measures? - CORRECT ANSWER - 1)
measures contain quantitative values whereas dimensions contain names, dates or geographical
data
2) dimensions increase the level of detail in the view while measures are aggregated when added
to the view
How do you disaggregate data in tableau? - CORRECT ANSWER - go to analysis ->
uncheck the aggregate measures
Where on tableau do you find data connectors that are available? (which pane) - CORRECT
ANSWER - Connect pane (then go to search for data)
What are the benefits of using an extract over a live connection? - CORRECT ANSWER -
1) supports large datasets
2) helps improve performance; faster
3) support additional functionality; allows you to take advantage of tableau functions that aren't
supported by the original data, such as count distinct
4) provide offline access to your data; allows you to use the data when the original data is
unavailable
