Tableau Desktop Specialist Key PASSED Exam Questions and CORRECT Answers

Tableau Desktop Specialist Key PASSED
Exam Questions and CORRECT Answers

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


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

d) five - ✔✔✔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 - ✔✔✔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 - ✔✔✔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 - ✔✔✔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 - ✔✔✔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 - ✔✔✔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 - ✔✔✔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 - ✔✔✔b) discrete dimension