Tableau Desktop Specialist Questions With Well
Detailed Answers
For a bullet graph, we need at least ______ measures? Right Ans - 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 Right Ans - 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 Right Ans - 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 Right Ans - 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 Right Ans - 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 Right Ans - 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 Right
Ans - 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 Right Ans - 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 Right Ans - 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 Right Ans - c.
t/f trend lines can only be used with numeric or date fields Right Ans - 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 Right Ans - a
Y/N is it possible to add both a dashboard and a worksheet at the same time
to a story point? Right Ans - no
t/f all rows from both tables are returned in an inner join Right Ans - false
which of the following chart type makes use of 'binned' data?
a. histogram
b gantt chart
c. bullet chart
d. treemaps Right Ans - 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 Right Ans - 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]) Right Ans - a
Detailed Answers
For a bullet graph, we need at least ______ measures? Right Ans - 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 Right Ans - 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 Right Ans - 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 Right Ans - 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 Right Ans - 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 Right Ans - 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 Right
Ans - 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 Right Ans - 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 Right Ans - 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 Right Ans - c.
t/f trend lines can only be used with numeric or date fields Right Ans - 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 Right Ans - a
Y/N is it possible to add both a dashboard and a worksheet at the same time
to a story point? Right Ans - no
t/f all rows from both tables are returned in an inner join Right Ans - false
which of the following chart type makes use of 'binned' data?
a. histogram
b gantt chart
c. bullet chart
d. treemaps Right Ans - 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 Right Ans - 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]) Right Ans - a