TABLEAU CERTIFICATION EXAM
QUESTIONS WITH CORRECT
ANSWERS
To connect tableau to a CSV data source what type of connection should you use? -
Correct Answers -text file
what are the two main groups that all fields are broken up into in Tableau - Correct
Answers -dimension and measures
what are calculated fields in tableau - Correct Answers -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 Answers -no limit
How do you decide what colors to use - Correct Answers -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 Answers -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
Answers -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
what can happen when you join on a single field when it is required to join on multiple
fields - Correct Answers -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 Answers -false
when would you use data blending and not data joining - Correct Answers -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
,how does tableau know at which level to aggregate variables - Correct Answers -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 Answers -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 Answers -json
lookup category
when would you need to create hierarchies in tableau - Correct Answers -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 Answers -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 Answers -true
what is the main conceptual difference between action: filter and action: highlight for a
dashboard - Correct Answers -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 Answers -true
which of these is a good rough description of what happens when two tables are joined
- Correct Answers -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
Answers -the matching row of the other table is replicated to accommodate the number
of duplicates
what is the first thing you need to do after creating a dual axis chart - Correct Answers -
synchronize the axis
how is creating calculated fields in a blend different to creating normal calculated fields -
Correct Answers -the data elements used have to be aggregated
how do you set geographic roles - Correct Answers -right click the appropriate field and
select the appropriate geographic role
,which of the following is NOT a quick table calculation in tableau - Correct Answers -
stochastic oscillation
which of these are types of allowable values for any parameter - Correct Answers -all.
list. range.
what is the main visual element of a treemap called - Correct Answers -box
what are customer segmentation dashboards used for - Correct Answers -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 Answers -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 Answers -FALSE
approximately what percent of work of a data scientist is data preparation - Correct
Answers -70%
what is the best format of data for machines in tableau - Correct Answers -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
Answers -pivot
which of the following is NOT a new feature introduced in tableau 10 - Correct Answers
-3 dimensional dashboards
what does a highlighter allow you to accomplish - Correct Answers -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 Answers -yes, you can specify additional
variables AND you can remove unwanted variables from the clustering analysis without
removing them from the chart
are clusters a dimension or a measure - Correct Answers -dimension- because they
represent a categorical split of your data
, does the introduction of cross database joins render blends completely useless -
Correct Answers -no. blends are a LEFT join that happens AFTER the data has been
aggregated to the appropriate level.
it is possible to add a field to more than one hierarchy - Correct Answers -TRUE. right
click and choose duplicate field and then you can add it to more than one
we get a different color palette if we drop a discrete field on color in the marks card as
opposed to dropping a continuous field - Correct Answers -TRUE. Discrete: categorical
palette. different color for each category. have no inherent order bc they are just
categories. To change the color for a value
1) Click on an item on the left, under Select Data Item.
2) Click a new color in the palette on the right. In Tableau Desktop you can hover over a
swatch to identify the color.
3) Repeat for as many values that you want to change.
4) In Tableau Desktop, click OK to exit the Edit Colors dialog box. In Tableau Server or
Tableau Online, simply close the dialog box.
FOR CONTINUOUS: you get a continuous range of colors, like the fade thin. you can
set the number of steps and the colors for the highest and lowest and middle
by definition, tableau displays measures over time as a - Correct Answers -line. line
charts connect individual data points in a view.
as best practice, how many categories can a pie chart display effectively - Correct
Answers -2-5. anything more is not easy for your eyes to distinguish
You have cleaned a data source properly, created some calculated fields and renamed
some columns. You want to save these changes for future use cases. Which of the
following would BEST satisfy this requirement? - Correct Answers -save it as a .tds file.
Explanation:
After making changes to Data, we can save that new data source as a .tds file. To do
so, go to data menu on top and then choose your current connected data source. Then
next click on Add to Saved Data sources. This will save all calculated fields, changes to
fields etc. It will be saved in My Tableau Repository -> Mydatasources. This will then
also appear on Tableau Home Page under saved data sources like SampleSuperStore.
Note: Data source files do not contain the actual data but rather the information
necessary to connect to the actual data as well as any modifications you've made on
top of the actual data such as changing default properties, creating calculated fields,
adding groups, and so on.
.twb and .twbx are not the BEST solutions since the questions nowhere mentions that
we need to store our workbooks as well.
.twm is a bookmark which contains a single worksheet and are an easy way to quickly
share your work.
QUESTIONS WITH CORRECT
ANSWERS
To connect tableau to a CSV data source what type of connection should you use? -
Correct Answers -text file
what are the two main groups that all fields are broken up into in Tableau - Correct
Answers -dimension and measures
what are calculated fields in tableau - Correct Answers -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 Answers -no limit
How do you decide what colors to use - Correct Answers -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 Answers -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
Answers -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
what can happen when you join on a single field when it is required to join on multiple
fields - Correct Answers -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 Answers -false
when would you use data blending and not data joining - Correct Answers -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
,how does tableau know at which level to aggregate variables - Correct Answers -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 Answers -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 Answers -json
lookup category
when would you need to create hierarchies in tableau - Correct Answers -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 Answers -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 Answers -true
what is the main conceptual difference between action: filter and action: highlight for a
dashboard - Correct Answers -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 Answers -true
which of these is a good rough description of what happens when two tables are joined
- Correct Answers -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
Answers -the matching row of the other table is replicated to accommodate the number
of duplicates
what is the first thing you need to do after creating a dual axis chart - Correct Answers -
synchronize the axis
how is creating calculated fields in a blend different to creating normal calculated fields -
Correct Answers -the data elements used have to be aggregated
how do you set geographic roles - Correct Answers -right click the appropriate field and
select the appropriate geographic role
,which of the following is NOT a quick table calculation in tableau - Correct Answers -
stochastic oscillation
which of these are types of allowable values for any parameter - Correct Answers -all.
list. range.
what is the main visual element of a treemap called - Correct Answers -box
what are customer segmentation dashboards used for - Correct Answers -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 Answers -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 Answers -FALSE
approximately what percent of work of a data scientist is data preparation - Correct
Answers -70%
what is the best format of data for machines in tableau - Correct Answers -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
Answers -pivot
which of the following is NOT a new feature introduced in tableau 10 - Correct Answers
-3 dimensional dashboards
what does a highlighter allow you to accomplish - Correct Answers -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 Answers -yes, you can specify additional
variables AND you can remove unwanted variables from the clustering analysis without
removing them from the chart
are clusters a dimension or a measure - Correct Answers -dimension- because they
represent a categorical split of your data
, does the introduction of cross database joins render blends completely useless -
Correct Answers -no. blends are a LEFT join that happens AFTER the data has been
aggregated to the appropriate level.
it is possible to add a field to more than one hierarchy - Correct Answers -TRUE. right
click and choose duplicate field and then you can add it to more than one
we get a different color palette if we drop a discrete field on color in the marks card as
opposed to dropping a continuous field - Correct Answers -TRUE. Discrete: categorical
palette. different color for each category. have no inherent order bc they are just
categories. To change the color for a value
1) Click on an item on the left, under Select Data Item.
2) Click a new color in the palette on the right. In Tableau Desktop you can hover over a
swatch to identify the color.
3) Repeat for as many values that you want to change.
4) In Tableau Desktop, click OK to exit the Edit Colors dialog box. In Tableau Server or
Tableau Online, simply close the dialog box.
FOR CONTINUOUS: you get a continuous range of colors, like the fade thin. you can
set the number of steps and the colors for the highest and lowest and middle
by definition, tableau displays measures over time as a - Correct Answers -line. line
charts connect individual data points in a view.
as best practice, how many categories can a pie chart display effectively - Correct
Answers -2-5. anything more is not easy for your eyes to distinguish
You have cleaned a data source properly, created some calculated fields and renamed
some columns. You want to save these changes for future use cases. Which of the
following would BEST satisfy this requirement? - Correct Answers -save it as a .tds file.
Explanation:
After making changes to Data, we can save that new data source as a .tds file. To do
so, go to data menu on top and then choose your current connected data source. Then
next click on Add to Saved Data sources. This will save all calculated fields, changes to
fields etc. It will be saved in My Tableau Repository -> Mydatasources. This will then
also appear on Tableau Home Page under saved data sources like SampleSuperStore.
Note: Data source files do not contain the actual data but rather the information
necessary to connect to the actual data as well as any modifications you've made on
top of the actual data such as changing default properties, creating calculated fields,
adding groups, and so on.
.twb and .twbx are not the BEST solutions since the questions nowhere mentions that
we need to store our workbooks as well.
.twm is a bookmark which contains a single worksheet and are an easy way to quickly
share your work.
