TABLEAU DESKTOP SPECIALIST QUESTIONS & ANSWERS(RATED A+)

TABLEAU DESKTOP SPECIALIST
QUESTIONS & ANSWERS(RATED
A+)
What is the difference between Live and Extract connections? - ANSWER-Live
allows real-time data while extracts are kind of batch which needs to be refreshed
from time to get the updated data

-Live Connection takes more time to load data than Extract Connection

Why the direct connection to the extract is not recommended? - ANSWER-The table
names will be different
-The extract cannot be refreshed
-The data model and relationships will be lost

*it can be removed once it's connected directly

How can the users refresh an extract immediately in Tableau desktop? - ANSWER-
Select a Data Source on Data Menu -> Extract

- Select a Data Source on Data Menu -> Extract -> Refresh

-Sign in to Tableau Server -> Tasks -> Under Extract Refreshes select the workbook
or data source -> On the Actions menu click Run now

How to remove an extract? - ANSWERSelect the extract data source on the Data
menu -> Extract -> Remove

What is the default format (extension) that Tableau saves the files as? (multiple
possible answers)
a) .doc
b) .tdsx
c) .tds
d) .pbix - ANSWERb) .tdsx
c) .tds


Which option leads to adjusting the granularity of data in Tableau?
a) aggregate
b) group by
c) grouped fields
d) extract - ANSWERa) aggregate

Advantages to using relationships to combine tables: (multiple possible answers)

a) makes it easier to change the key fields used to combine tables

,b) makes it easier to analyze data across multiple tables at different levels of
granularity
c) makes it easier to combine rows from one table with rows from another
d) tables are only queried when fields from the tables are added to the viz -
ANSWERb) makes it easier tho analyze data across multiple tables at different
levels of granularity

d) tables are only queried when fields from the tables are added to the viz (aka when
required in the worksheet)

Relationships vs Joins - ANSWERRelationships
-do not combine rows from one table with rows from another
-duplication is avoided

Select the correct pathway to edit the data source -

a) Data Menu -> Select a Data source -> Edit Data Source
b) Data Menu -> Select a Data source -> Extract Data
c) Data Menu -> Select a Data source -> View Data
d) Data Menu -> Select a Data source -> Edit Data Source Filters - ANSWERa) Data
Menu -> Select a Data source -> Edit Data Source

Aliases cannot be created for the following -
(multiple possible answers)

a) Discrete dimension
b) Continuous dimension
c) Measurers
d) Dates - ANSWERb) Continuous dimension
c) Measures
d) Dates

How many data sources can we blend in Tableau?
a) two
b) three
c) four
d) five - ANSWERa) two

In a Relationship we need to define the following Join type-
a) Inner Join
b) Left Join
c) Right Join
d) it is not required to define a join type in a relationship - ANSWERd) it is not
required to define a join type in a relationship

Aliases CAN be created for which of the following?
a) continuous dimension
b) discrete dimension
c) measures
d) dates - ANSWERb) discrete dimension

, When assigning geographic role to a field, tableau adds two fields to the Measurers
area of the Data pane: - ANSWERLatitude and Longitude

Choose the correct path to change the data type for a field in the view -

Right click the field in the Data pane and then:
a) Change Data Type -> Data Types -> choose appropriate type
b) Change Data Type -> choose appropriate type
c) Data Types -> Choose appropriate type
d) choose appropriate type - ANSWERb) Right click the field in the Data pane ->
Change Data Type -> Choose appropriate type

Which of the following can prevent a refresh for a refreshable list of parameter
values? (select all that apply)
a) default field returns null
b) default field does not return a single value
c) default field is in a data source that's not yet connected
d) user cancels the query to the data source while Tableau is attempting to connect -
ANSWERa) default field returns null
c) default field is in a non-connected source
d) user cancels the query


Choose the correct path to add a default comment for a field -

Right click a field in the Data Pane and then:
a) Default Properties -> Comment
b) Aggregation -> Default Properties -> Comment
c) Comment
d) Describe -> Comment - ANSWERa) Right click a field in the Data Pane -> Default
Properties -> Comment

What steps should be taken to change a vertical Baar chart to horizontal?
a) Drag the measure to the columns shelf and the dimension to the row shelf
b) Drag the measure to the rows shelf and the dimension to the column shelf
c) Drag the measure to both the row shelf and the columns shelf
d) Drag the dimension to both the rows shelf and the column shelf - ANSWERa)
Drag the measure to the columns shelf and the dimension to the row shelf

What types of trend lines are available in Tableau?
a) logistic
b) linear
c) logarithmic
d) multinomial
e) polynomial - ANSWERb) linear
c) logarithmic
e) polynomial

What steps should be taken to create a geographical hierarchy?