Tableau Desktop Specialist - Questions & Verified Solutions

Tableau Desktop Specialist - Questions & Verified
Solutions

What is the difference between Live and Extract connections? Right Ans - -
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? Right Ans - -
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?
Right Ans - - 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? Right Ans - Select 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 Right Ans - b) .tdsx
c) .tds

How many data sources can we blend in Tableau?
a) two
b) three

,c) four
d) five Right Ans - a) 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 Right Ans - d) it is
not required to define a join type in a relationship

Which option leads to adjusting the granularity of data in Tableau?
a) aggregate
b) group by
c) grouped fields
d) extract Right Ans - a) 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
Right Ans - b) 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 Right Ans - Relationships
-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 Right Ans -
a) 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 Right Ans - b) Continuous dimension
c) Measures
d) Dates

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

When assigning geographic role to a field, tableau adds two fields to the
Measurers area of the Data pane: Right Ans - Latitude 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 Right Ans - b) Right click the field in the Data
pane -> Change Data Type -> Choose appropriate type

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 Right Ans - a) Right click a field in the Data Pane -
> Default Properties -> Comment