Tableau Certification Exam UPDATED
Questions and CORRECT Answers
To connect tableau to a CSV data source what type of connection should you use? - CORRECT
ANSWER - text file
what are the two main groups that all fields are broken up into in Tableau - CORRECT
ANSWER - dimension and measures
what are calculated fields in tableau - CORRECT ANSWER - these are custom variables
that you create from fields provided in the data
how many fields can you add to be shown in the label - CORRECT ANSWER - no limit
How do you decide what colors to use - CORRECT ANSWER - the main thing to take
into account is the end user / viewer. colors should assist them in seeing the insights that your
charts are portraying
which of these is a valid reason to use a data extract over a live connection to the dataset -
CORRECT ANSWER - your data is constantly being updated and you want to work with
a static file when building your visual (you will later return to the live connection when the
visual is ready)
what is the difference between the blue month() and the green month() - CORRECT
ANSWER - blue is a dimension and green is a measure. blue ignores higher periods such
as year and treats month as a category. Green creates a proper TIMELINE
how does tableau know at which level to aggregate variables - CORRECT ANSWER -
values are always aggregated at the level of granularity of the worksheet
,which of these explains the conceptual difference between a line chart and an area chart -
CORRECT ANSWER - an area chart stacks up values of different categories on top of
each other. a line chart visualizes them separately
which of these is NOT a type of quick filter available in tableau - CORRECT ANSWER -
json lookup category
when would you need to create hierarchies in tableau - CORRECT ANSWER - when there
are hierarchies present in the dimensions and tableau needs to know about them for you to build
your visualization
which of the following are different ways you can select the worksheets to which you want to
apply a filter - CORRECT ANSWER - all using this data source, selected worksheets, only
this worksheet
to add worksheets to a dashboard you can simply drag them onto the dashboard - CORRECT
ANSWER - true
what is the main conceptual difference between action: filter and action: highlight for a
dashboard - CORRECT ANSWER - when you use action: filter you are removing data
from analysis before it is illustrated on the visualization. action: highlight all the data is
visualized first and then the action is applied after. can lead to discrepancies in results.
you can automatically generate action: filter through the dropdown of the selected worksheet in
the dashboard - CORRECT ANSWER - true
which of these is a good rough description of what happens when two tables are joined -
CORRECT ANSWER - the rows of the second table are placed to the side of the rows of
the first. the table is extended horizontally
what happens when one of the tables has duplicate values in the join clause - CORRECT
ANSWER - the matching row of the other table is replicated to accommodate the number
of duplicates
,what can happen when you join on a single field when it is required to join on multiple fields -
CORRECT ANSWER - rows will be duplicated without an actual reason, hyper inflation
of measures, incorrect insights and business decisions
data blending in tableau happens after aggregation is performed on the separate datasets -
CORRECT ANSWER - false
when would you use data blending and not data joining - CORRECT ANSWER - when
your datasets have different levels of granularity. when your data comes from disparate data
sources. when you simply cannot do a join for any other reason
what is the first thing you need to do after creating a dual axis chart - CORRECT
ANSWER - synchronize the axis
how is creating calculated fields in a blend different to creating normal calculated fields -
CORRECT ANSWER - the data elements used have to be aggregated
how do you set geographic roles - CORRECT ANSWER - right click the appropriate field
and select the appropriate geographic role
which of the following is NOT a quick table calculation in tableau - CORRECT
ANSWER - stochastic oscillation
which of these are types of allowable values for any parameter - CORRECT ANSWER -
all. list. range.
what is the main visual element of a treemap called - CORRECT ANSWER - box
, what are customer segmentation dashboards used for - CORRECT ANSWER - understand
how customers are segmented across different geographies. to make better business decisions. to
deliver a better customer experience making it tailored and relevant.
which of the following statements about what can be used as pages in a storyline is TRUE -
CORRECT ANSWER - both worksheets and dashboards can be used as pages in a
storyline. they cannot be combined on one page.
when you change the value of a parameter on one page of the storyline, it also changes on all
other pages of the storyline - CORRECT ANSWER - FALSE
approximately what percent of work of a data scientist is data preparation - CORRECT
ANSWER - 70%
what is the best format of data for machines in tableau - CORRECT ANSWER - where
each measure and dimension has its own column
which of these tableau 9 features allows you to change the format of the data from where the
years are in columns to when the years have their own columns - CORRECT ANSWER -
pivot
which of the following is NOT a new feature introduced in tableau 10 - CORRECT
ANSWER - 3 dimensional dashboards
what does a highlighter allow you to accomplish - CORRECT ANSWER - subtly highlight
different marks on your chart based on the categories of the selected field without interfering
with the charts visual representation (marks shown, sizes, etc)
is it possible to specify additional variables for clustering analysis (apart from the variables
present in your chart) - CORRECT ANSWER - yes, you can specify additional variables
AND you can remove unwanted variables from the clustering analysis without removing them
from the chart
Questions and CORRECT Answers
To connect tableau to a CSV data source what type of connection should you use? - CORRECT
ANSWER - text file
what are the two main groups that all fields are broken up into in Tableau - CORRECT
ANSWER - dimension and measures
what are calculated fields in tableau - CORRECT ANSWER - these are custom variables
that you create from fields provided in the data
how many fields can you add to be shown in the label - CORRECT ANSWER - no limit
How do you decide what colors to use - CORRECT ANSWER - the main thing to take
into account is the end user / viewer. colors should assist them in seeing the insights that your
charts are portraying
which of these is a valid reason to use a data extract over a live connection to the dataset -
CORRECT ANSWER - your data is constantly being updated and you want to work with
a static file when building your visual (you will later return to the live connection when the
visual is ready)
what is the difference between the blue month() and the green month() - CORRECT
ANSWER - blue is a dimension and green is a measure. blue ignores higher periods such
as year and treats month as a category. Green creates a proper TIMELINE
how does tableau know at which level to aggregate variables - CORRECT ANSWER -
values are always aggregated at the level of granularity of the worksheet
,which of these explains the conceptual difference between a line chart and an area chart -
CORRECT ANSWER - an area chart stacks up values of different categories on top of
each other. a line chart visualizes them separately
which of these is NOT a type of quick filter available in tableau - CORRECT ANSWER -
json lookup category
when would you need to create hierarchies in tableau - CORRECT ANSWER - when there
are hierarchies present in the dimensions and tableau needs to know about them for you to build
your visualization
which of the following are different ways you can select the worksheets to which you want to
apply a filter - CORRECT ANSWER - all using this data source, selected worksheets, only
this worksheet
to add worksheets to a dashboard you can simply drag them onto the dashboard - CORRECT
ANSWER - true
what is the main conceptual difference between action: filter and action: highlight for a
dashboard - CORRECT ANSWER - when you use action: filter you are removing data
from analysis before it is illustrated on the visualization. action: highlight all the data is
visualized first and then the action is applied after. can lead to discrepancies in results.
you can automatically generate action: filter through the dropdown of the selected worksheet in
the dashboard - CORRECT ANSWER - true
which of these is a good rough description of what happens when two tables are joined -
CORRECT ANSWER - the rows of the second table are placed to the side of the rows of
the first. the table is extended horizontally
what happens when one of the tables has duplicate values in the join clause - CORRECT
ANSWER - the matching row of the other table is replicated to accommodate the number
of duplicates
,what can happen when you join on a single field when it is required to join on multiple fields -
CORRECT ANSWER - rows will be duplicated without an actual reason, hyper inflation
of measures, incorrect insights and business decisions
data blending in tableau happens after aggregation is performed on the separate datasets -
CORRECT ANSWER - false
when would you use data blending and not data joining - CORRECT ANSWER - when
your datasets have different levels of granularity. when your data comes from disparate data
sources. when you simply cannot do a join for any other reason
what is the first thing you need to do after creating a dual axis chart - CORRECT
ANSWER - synchronize the axis
how is creating calculated fields in a blend different to creating normal calculated fields -
CORRECT ANSWER - the data elements used have to be aggregated
how do you set geographic roles - CORRECT ANSWER - right click the appropriate field
and select the appropriate geographic role
which of the following is NOT a quick table calculation in tableau - CORRECT
ANSWER - stochastic oscillation
which of these are types of allowable values for any parameter - CORRECT ANSWER -
all. list. range.
what is the main visual element of a treemap called - CORRECT ANSWER - box
, what are customer segmentation dashboards used for - CORRECT ANSWER - understand
how customers are segmented across different geographies. to make better business decisions. to
deliver a better customer experience making it tailored and relevant.
which of the following statements about what can be used as pages in a storyline is TRUE -
CORRECT ANSWER - both worksheets and dashboards can be used as pages in a
storyline. they cannot be combined on one page.
when you change the value of a parameter on one page of the storyline, it also changes on all
other pages of the storyline - CORRECT ANSWER - FALSE
approximately what percent of work of a data scientist is data preparation - CORRECT
ANSWER - 70%
what is the best format of data for machines in tableau - CORRECT ANSWER - where
each measure and dimension has its own column
which of these tableau 9 features allows you to change the format of the data from where the
years are in columns to when the years have their own columns - CORRECT ANSWER -
pivot
which of the following is NOT a new feature introduced in tableau 10 - CORRECT
ANSWER - 3 dimensional dashboards
what does a highlighter allow you to accomplish - CORRECT ANSWER - subtly highlight
different marks on your chart based on the categories of the selected field without interfering
with the charts visual representation (marks shown, sizes, etc)
is it possible to specify additional variables for clustering analysis (apart from the variables
present in your chart) - CORRECT ANSWER - yes, you can specify additional variables
AND you can remove unwanted variables from the clustering analysis without removing them
from the chart
