TABLEAU DESKTOP SPECIALIST UPDATED
COMPREHENSIVE EXAM QUESTIONS AND ANSWERS
SURE A+
✔✔The highlight action in a dashboard is similar to filtering action in a worksheet.
A. Cross Join
B. Inner Join
C. Left outer Join
D. Full outer Join - ✔✔C. Left outer Join
✔✔Bins cannot be created on dimensions.
A. True
B. False - ✔✔False
✔✔Which of the following is an example of metadata that can be managed in Tableau?
- ✔✔Which fields are hidden, and default aggregation for a field
✔✔Which file type can include an extract? - ✔✔Packaged Data Source (.tdsx) and
Packaged Workbooks (.twbx).
, ✔✔Which of the following is most likely to reduce the size of the extract? - ✔✔Selecting
"Multiple Table" rather than "Single Tables"
✔✔If a Tableau workbook does not include the fields Latitude (generated) and
Longitude (generated) this indicates which of the following: - ✔✔The workbook does not
include any fields with a geographic role of state, city, country, or zip code
✔✔Which visualization always represents a measure using color? - ✔✔Highlight Table
✔✔You would like to divide your customers into two categories - those with sales above
a certain threshold and those with sales below that threshold. Which of the following
tools will allow you to do this? - ✔✔Set and calculation
✔✔Which of the following does Tableau automatically put into a hierarchy? - ✔✔Date
fields (year > month > day)
✔✔Which of the following can you use to create a calculated field that shows the
change from the prior month total? - ✔✔A table calculation
✔✔A histogram must include which of the following? - ✔✔Bin, count, or count distinct
✔✔If you are creating a geographic map with cities, but some of the locations are
showing as ambiguous, how might you correct this? - ✔✔Add a field called "State" to
the view
✔✔Your view has a histogram showing the distribution of Sales. You'd like to use a
color gradient to shade the bars according to the value of Profit. You drag profit to the
color mark. How would you adjust the colors so that all negative values are shown in
one color and all positive values are shown in a second color? - ✔✔Click the arrow on
the colors mark, select edit colors, select a diverging palette from the dropdown and
check stepped color with two steps and check center on zero.
✔✔For which of the following is it not possible to adjust the size of the marks? - ✔✔Tree
Map
✔✔Editing the font at the worksheet level applies the changes you make to all text fields
in view except for which of the following? - ✔✔Tooltip
✔✔You have a dashboard containing multiple worksheets. One of the worksheets in the
dashboard has a scroll bar. Which of the following steps can you take to remove the
scroll bar? - ✔✔Click the more options arrow, select fit, and select fit height.
COMPREHENSIVE EXAM QUESTIONS AND ANSWERS
SURE A+
✔✔The highlight action in a dashboard is similar to filtering action in a worksheet.
A. Cross Join
B. Inner Join
C. Left outer Join
D. Full outer Join - ✔✔C. Left outer Join
✔✔Bins cannot be created on dimensions.
A. True
B. False - ✔✔False
✔✔Which of the following is an example of metadata that can be managed in Tableau?
- ✔✔Which fields are hidden, and default aggregation for a field
✔✔Which file type can include an extract? - ✔✔Packaged Data Source (.tdsx) and
Packaged Workbooks (.twbx).
, ✔✔Which of the following is most likely to reduce the size of the extract? - ✔✔Selecting
"Multiple Table" rather than "Single Tables"
✔✔If a Tableau workbook does not include the fields Latitude (generated) and
Longitude (generated) this indicates which of the following: - ✔✔The workbook does not
include any fields with a geographic role of state, city, country, or zip code
✔✔Which visualization always represents a measure using color? - ✔✔Highlight Table
✔✔You would like to divide your customers into two categories - those with sales above
a certain threshold and those with sales below that threshold. Which of the following
tools will allow you to do this? - ✔✔Set and calculation
✔✔Which of the following does Tableau automatically put into a hierarchy? - ✔✔Date
fields (year > month > day)
✔✔Which of the following can you use to create a calculated field that shows the
change from the prior month total? - ✔✔A table calculation
✔✔A histogram must include which of the following? - ✔✔Bin, count, or count distinct
✔✔If you are creating a geographic map with cities, but some of the locations are
showing as ambiguous, how might you correct this? - ✔✔Add a field called "State" to
the view
✔✔Your view has a histogram showing the distribution of Sales. You'd like to use a
color gradient to shade the bars according to the value of Profit. You drag profit to the
color mark. How would you adjust the colors so that all negative values are shown in
one color and all positive values are shown in a second color? - ✔✔Click the arrow on
the colors mark, select edit colors, select a diverging palette from the dropdown and
check stepped color with two steps and check center on zero.
✔✔For which of the following is it not possible to adjust the size of the marks? - ✔✔Tree
Map
✔✔Editing the font at the worksheet level applies the changes you make to all text fields
in view except for which of the following? - ✔✔Tooltip
✔✔You have a dashboard containing multiple worksheets. One of the worksheets in the
dashboard has a scroll bar. Which of the following steps can you take to remove the
scroll bar? - ✔✔Click the more options arrow, select fit, and select fit height.
