Tableau Desktop Specialist UPDATED
Questions and CORRECT Answers
For a bullet graph, we need at least ______ measures? - CORRECT ANSWER - 2. A
bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A
bullet graph is useful for comparing the performance of a primary measure to one or more other
measures.
Dimensions containing _______ and _______ values cannot be continuous.
a. string
b. date and time
c. date
d. boolean - CORRECT ANSWER - a and d
which of the following are benefits of using data extracts of tableau? multiple choice
a. faster to work with
b. working with the freshest data at all times
c. ability to use the data offline
d. improved performance - CORRECT ANSWER - a, c, and d
extracts are advantageous for several reasons:
1. support large data sets
2. fast to create
3. help improve performance
4. support additional functionality
when you want to first apply a filter and THEN show the top n or bottom n elements, which of
the following filters would you use?
a. extract filters
b. none of these
,c. data source filter
d. context filter - CORRECT ANSWER -d
by default, what does tableau do when you connect to a data source?
a. loads your actual file into tableau
b. creates an extract of the data
c. creates a live connection to the data
d. sorts the data in descending order - CORRECT ANSWER - c.
which of the following represent a valid method to create a bullet graph with the least number of
fields possible?
a. using 2 dimensions and 3 measures
b. using 2 dimensions
c. using 1 measure
d. using 2 measures - CORRECT ANSWER - d.
you need at least 2 measures for a bullet graph and then 0 or more dimensions
t/f the highlighting action can be disables for the entire workbook - CORRECT
ANSWER - true
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 the requirement?
a. save it as a .tds file
b. save it as a .twbx file
c. save it as a .twm file
d. save it as a .twb filw - CORRECT ANSWER - a.
to save, go to data menu on top and then choose your current connected data source. 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 appear on Tableau Home Page
under saved data sources like SampleSuperStore.
Note: Data source file do not contain the actual data, but rather the info necessary to connect to
the actual data as well as any mods you've made on top of the actual data such as changing
default properties, creating calculated fields, adding groups, and so on.
You want to save your changes and workbooks. What is the best way to do so? multiple choice
a. save it as a .tds file
b. save it as a .twbx file
c. save it as a .twm file
d. save it as a .twb filw - CORRECT ANSWER - b and d
You want to save these a worksheet to easily and quickly share, what is the best way?
a. save it as a .tds file
b. save it as a .twbx file
c. save it as a .twm file
d. save it as a .twb filw - CORRECT ANSWER - c.
t/f trend lines can only be used with numeric or date fields - CORRECT ANSWER - true
to add a trend line, both axes must contain a filed that can be interpreted as a number
You add SUM(Profit) to the columns shelf, what will it create?
a. a horizontal axis
b. a horizontal header
c. a vertical header
d. a vertical axis - CORRECT ANSWER -a
Y/N is it possible to add both a dashboard and a worksheet at the same time to a story point? -
CORRECT ANSWER - no
, t/f all rows from both tables are returned in an inner join - CORRECT ANSWER - false
which of the following chart type makes use of 'binned' data?
a. histogram
b gantt chart
c. bullet chart
d. treemaps - CORRECT ANSWER -a
__________ refers to the level of detail for a piece of data, wherever you are looking.
a. data cleanliness
b. data granularity
c. data LOD
d. data connectivity - CORRECT ANSWER -b
How would you calculate GDP per capita?
a. SUM([GDP])/SUM([Population])
b. SUM([Population]/[GDP])
c. SUM([GDP]/[Population])
d. SUM([GDP]*[Population]) - CORRECT ANSWER -a
we can join a max of _____ tables in tableau.
a. 16
b. 128
c. 32
d. 64 - CORRECT ANSWER -c
if you use a perfect difference Quick Table Calculation, what value will be the first data value?
Questions and CORRECT Answers
For a bullet graph, we need at least ______ measures? - CORRECT ANSWER - 2. A
bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A
bullet graph is useful for comparing the performance of a primary measure to one or more other
measures.
Dimensions containing _______ and _______ values cannot be continuous.
a. string
b. date and time
c. date
d. boolean - CORRECT ANSWER - a and d
which of the following are benefits of using data extracts of tableau? multiple choice
a. faster to work with
b. working with the freshest data at all times
c. ability to use the data offline
d. improved performance - CORRECT ANSWER - a, c, and d
extracts are advantageous for several reasons:
1. support large data sets
2. fast to create
3. help improve performance
4. support additional functionality
when you want to first apply a filter and THEN show the top n or bottom n elements, which of
the following filters would you use?
a. extract filters
b. none of these
,c. data source filter
d. context filter - CORRECT ANSWER -d
by default, what does tableau do when you connect to a data source?
a. loads your actual file into tableau
b. creates an extract of the data
c. creates a live connection to the data
d. sorts the data in descending order - CORRECT ANSWER - c.
which of the following represent a valid method to create a bullet graph with the least number of
fields possible?
a. using 2 dimensions and 3 measures
b. using 2 dimensions
c. using 1 measure
d. using 2 measures - CORRECT ANSWER - d.
you need at least 2 measures for a bullet graph and then 0 or more dimensions
t/f the highlighting action can be disables for the entire workbook - CORRECT
ANSWER - true
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 the requirement?
a. save it as a .tds file
b. save it as a .twbx file
c. save it as a .twm file
d. save it as a .twb filw - CORRECT ANSWER - a.
to save, go to data menu on top and then choose your current connected data source. 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 appear on Tableau Home Page
under saved data sources like SampleSuperStore.
Note: Data source file do not contain the actual data, but rather the info necessary to connect to
the actual data as well as any mods you've made on top of the actual data such as changing
default properties, creating calculated fields, adding groups, and so on.
You want to save your changes and workbooks. What is the best way to do so? multiple choice
a. save it as a .tds file
b. save it as a .twbx file
c. save it as a .twm file
d. save it as a .twb filw - CORRECT ANSWER - b and d
You want to save these a worksheet to easily and quickly share, what is the best way?
a. save it as a .tds file
b. save it as a .twbx file
c. save it as a .twm file
d. save it as a .twb filw - CORRECT ANSWER - c.
t/f trend lines can only be used with numeric or date fields - CORRECT ANSWER - true
to add a trend line, both axes must contain a filed that can be interpreted as a number
You add SUM(Profit) to the columns shelf, what will it create?
a. a horizontal axis
b. a horizontal header
c. a vertical header
d. a vertical axis - CORRECT ANSWER -a
Y/N is it possible to add both a dashboard and a worksheet at the same time to a story point? -
CORRECT ANSWER - no
, t/f all rows from both tables are returned in an inner join - CORRECT ANSWER - false
which of the following chart type makes use of 'binned' data?
a. histogram
b gantt chart
c. bullet chart
d. treemaps - CORRECT ANSWER -a
__________ refers to the level of detail for a piece of data, wherever you are looking.
a. data cleanliness
b. data granularity
c. data LOD
d. data connectivity - CORRECT ANSWER -b
How would you calculate GDP per capita?
a. SUM([GDP])/SUM([Population])
b. SUM([Population]/[GDP])
c. SUM([GDP]/[Population])
d. SUM([GDP]*[Population]) - CORRECT ANSWER -a
we can join a max of _____ tables in tableau.
a. 16
b. 128
c. 32
d. 64 - CORRECT ANSWER -c
if you use a perfect difference Quick Table Calculation, what value will be the first data value?
