Tableau Desktop Specialist Exam- Questions With Correct Solutions

Tableau Desktop Specialist Exam- Questions With
Correct Solutions

Dimensions containing ____________ and ____________ values cannot be
continuous.
a) Boolean
b) Date and Time
c) String
d) Date Right Ans - a) Boolean
c) String

Is it possible to add both a Dashboard and a Worksheet at the same time to a
Story Point in Tableau?
a) Yes
b) No Right Ans - b) No

How would you calculate GDP per capita in Tableau?
a) SUM([GDP]*[POPULATION])
b) SUM([GDP]/[POPULATION])
c) SUM([GDP]) / SUM([Population])
d) SUM([Population]/[GDP]]) Right Ans - c) SUM([GDP]) /
SUM([Population])

True or False: It is possible to add a field to more than one hierarchy Right
Ans - True -- Right click and choose duplicate.

By definition, Tableau displays measures over time as a ____________
a) Bar
b) Line
c) Packed Bubble
d) Stacked Bar Right Ans - b) Line

True or False: Trend lines can only be used with numeric or date fields
Right Ans - True

You clicked Sheet 1 from the data source page, and now you have opened the
Tableau Desktop workspace as shown above. What is the main thing that you
do here?

,a) Create visualisations to analyze your data
b) Rename the fields and change data types
c) Clean the data
d) Preview the data Right Ans - a) Create visualisations to analyze your
data

Which of the following are benefits of using Data Extracts in Tableau?
a) Improved Performance
b) Faster to work with
c) Ability to use the data offline
d) Working with freshest data at all times Right Ans - a) Improved
Performance
b) Faster to work with
c) Ability to use the data offline

Which of the following is true about 'Incremental refresh' when creating
Extracts in Tableau?
a) There is no difference, both are the same when using extracts. They are
different when using live connections.
b) It only adds rows that are new since the previous refresh.
c) They can only be used with large datasets
d) It replaces all of the contents in the extract Right Ans - b) It only adds
rows that are new since the previous refresh.

True or False : Bins can be created on dimensions Right Ans - True.

Bins are a user-defined grouping of numerical data in the data source.
According to the official Tableau documentation: It's sometimes useful to
convert a continuous measure (or a numeric dimension) into bins.

We can clearly create bins from dimensions too - they just have to be numeric!

Which of the following can you use to create a Histogram?
a) 2 dimensions
b) 2 measures
c) 1 measure
d) 1 dimension Right Ans - c) 1 measure

,A histogram is a chart that displays the shape of a distribution. A histogram
looks like a bar chart but groups values for a continuous measure into ranges,
or bins.

Is SUM a table calculation? Right Ans - No - SUM is an aggregate function,
not a table calculation!

Which of the following shapes does a Heat Map use by default?
a) Text
b) Line
c) Square
d) Circle Right Ans - c) Square

The default path for all supporting files, data sources, icons, logs etc is in
a) Documents -> Tableau
b) Documents -> Tableau Files
c) Documents -> My Tableau Repository
d) Downloads -> Tableau Support Files Right Ans - c) Documents -> My
Tableau Repository

_______________ enables us to create workbooks and views, dashboards, and data
sources in Tableau Desktop, and then publish this content to our own server.
a) Tableau Server
b) Tableau Prep
c) Tableau myServer
d) Tableau Public Right Ans - a) Tableau Server

If you use a percent difference Quick Table Calculation, what value will be the
first data value?
a) null
b) -1
c) 0
d) 0000 Right Ans - a) null

When using a Percent difference, Tableau calculates what the percent change
has occured as compared to the last data value. BUT, for the first data value,
there is no previous value to compare it to. Hence, it appears as NULL.

, Tableau auto-generates ____________ dimension(s) and _____________ measure(s)
for us
a) 1 , 2
b) 2 , 3
c) 2 , 2
d) 1 , 4 Right Ans - d) 1 , 4

Tableau auto-generates :
1 Dimension - Measure Names
4 Measures - Latitude, Longitude, Number of records, Measure Values

Which of the following would you use to connect to multiple tables in a single
data source at once?
a) A Join
b) A Hierarchy
c) A Blend
d) A Set Right Ans - a) A Join

The data that you analyze in Tableau is often made up of a collection of tables
that are related by specific fields (that is, columns). Joining is a method for
combining data on based on those common fields. The result of combining
data using a join is a virtual table that is typically extended horizontally by
adding columns of data.

True or False: We get different colour pallete options if we drop a discrete
field on "Color" in the marks card compared to if we drop a continous field on
Color. Right Ans - True

Yes! We get different color palettes. They are: Categorical Palettes &
Quantitative Palettes

Which of the following are valid objects when creating a dashboard in
Tableau? Choose 4.
a) Text
b) Extension
c) Image
d) Video
e) Web Page Right Ans - a) Text
b) Extension